• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

DataSource Problem

 
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi

I am having the following error when I am testing the data source created to access SQL server 2005.

The error:

[6/22/15 10:41:21:781 CDT] 00000084 DataSourceCon E DSRA8040I: Failed to connect to the DataSource "". Encountered java.lang.NoSuchFieldError: .fd
at com.ibm.i5os.jsse.JSSESocket.beginHandshake(Native Method)
at com.ibm.i5os.jsse.JSSESocket.startHandshake(JSSESocket.java:1477)



I put the sqljdbc4.jar in ${WAS_INSTALL_ROOT}/lib and mentioned the same for MICROSOFT_JDBC_DRIVER_PATH.

I have no clue why it is failing. I also created 2 data sources for DB2 and they work fine without any problem.

Any help would be appreciated.
Thanks
 
Bartender
Posts: 1357
39
IBM DB2 Netbeans IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In the stack trace I read a problem related to com.IBM.i5os.jsse provider, is your WAS instance running on IBM i platform?
If JSSE is involved, I guess you want to use cryptography. What about if you try to disable SSL in data source config? Please note: I don't remember well if SSL is optional for every datasource type.
 
prasad agarwal
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Hi Claude ,
Thanks for your response.

Yes, WAS instance is running on IBM i platform (V7R1).
We do not have SSL enabled on the IBM i as of now. We are still in the beginning stages of migration from old version of WAS.

I might call the IBM tech support guys tomorrow to see if any of the config xml files got messed up in some way.
When I test the data source connection even from HTTPAdmin (WAS admin console), even there it fails with the same error. So, something doesn't sound right in the setup itself !

Thanks
 
prasad agarwal
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Hi Claude ,

The more I look in stack trace: it appears like, there is an attempt to enable SSL? but if I look at custom properties for the data source, I do have encrypt=false.
Any idea why it is behaving this way?

[6/23/15 17:06:18:881 CDT] 00000073 SystemErr R java.lang.NoSuchFieldError: .fd
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.ibm.i5os.jsse.JSSESocket.startHandshake(JSSESocket.java:1477)
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1394)
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1204)
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(SQLServerConnection.java:1054)
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:758)
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(SQLServerDataSource.java:578)
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.createNewConnection(SQLServerPooledConnection.java:67)
[6/23/15 17:06:18:882 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.<init>(SQLServerPooledConnection.java:43)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource.getPooledConnection(SQLServerConnectionPoolDataSource.java:34)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.rsadapter.DSConfigHelper$1.run(DSConfigHelper.java:1267)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5387)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5603)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.rsadapter.spi.ServerFunction$6.run(ServerFunction.java:567)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1282)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1190)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:2075)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:1951)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2819)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:556)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:484)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[6/23/15 17:06:18:883 CDT] 00000073 SystemErr R at



Could not invoke an operation on object: WebSphere:name=DataSourceCfgHelper,process=Webspher85SVR,platform=dynamicproxy,node=LOCAL_Webspher85SVR,version=8.5.5.5,type=DataSourceCfgHelper,mbeanIdentifier=DataSourceCfgHelper,cell=LOCAL_Webspher85SVR,spec=1.0 because of an mbean exception: java.sql.SQLException: java.lang.NoSuchFieldError: .fd



Thanks
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
SQL Server on the System i... I remember having that problem. Even if you don't configure it to run over SSL, it still uses SSL to make the initial connection. At least, the Microsoft JDBC driver does. We switched to the JTDS driver, which doesn't have that problem.
 
prasad agarwal
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Hi Paul,

Yes, that was what is puzzling me; when encrypt is set to false, it should mean the communication with database should be without SSL.
I will try the JTDS driver tomorrow and see how it works.
I did use JTDS driver with Websphere 6.x to connect to SQL server 7 before.

Thanks.
 
prasad agarwal
Ranch Hand
Posts: 79
  • Likes 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
jTDS driver got the job done.
 
Claude Moore
Bartender
Posts: 1357
39
IBM DB2 Netbeans IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for sharing this solution with us. It may help someone else.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic