Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

SQL datasource error for WAS 6.0

One of my application uses SQL datasource. I created a user-defined datasource in WAS 6.0 admin console and was able to successfully test the datasource. But when the application starts, the following error is returned...

00000025 FreePool      E   J2CA0046E: Method createManagedConnectionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/NTSQLDB, throwing ResourceAllocationException.  Original exception: <=================================>Exception Message -> class "com.microsoft.jdbc.base.BaseExceptions"'s signer information does not match signer information of other classes in the same package
java.lang.SecurityException: class "com.microsoft.jdbc.base.BaseExceptions"'s signer information does not match signer information of other classes in the same package
      at java.lang.ClassLoader.checkCerts(ClassLoader.java(Compiled Code))
      at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code))
      at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code))
      at java.net.URLClassLoader.defineClass(URLClassLoader.java(Compiled Code))
      at java.net.URLClassLoader.access$500(URLClassLoader.java(Inlined Compiled Code))
      at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
      at java.security.AccessController.doPrivileged1(Native Method)
      at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
      at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
      at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java(Compiled Code))
      at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
      at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
      at com.microsoft.jdbcx.base.BaseDataSource.setupExceptionHandling(Unknown Source)
      at com.microsoft.jdbcx.base.BaseDataSource.getBaseConnection(Unknown Source)
      at com.microsoft.jdbcx.base.BaseXADataSource.getXAConnection(Unknown Source)
      at com.microsoft.jdbcx.sqlserver.SQLServerDataSource.getXAConnection(Unknown Source)
      at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1071)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
      at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1104)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1257)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:981)
      at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1693)
      at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1449)
      at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:2157)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:926)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:630)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:413)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:382)
      at com.xyz.abc.ejb.xyzservices.XYZServicesBean.processTCOs(TCOServicesBean.java:100)
      at com.xyz.abc.ejb.xyzservices.EJSLocalStatelessXYZServices_cc17f4f6.processTCOs(EJSLocalStatelessXYZServices_cc17f4f6.java:68)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
      at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
      at com.xyz.abcp.utils.BaseDelegate.callSessionBean(BaseDelegate.java:67)
      at com.xyz.abc.ejb.tcoservices.XYZServicesDelegate.processTCOs(XYZServicesDelegate.java:36)
      at com.xyz.abcp.tco.ProcessThread.run(ProcessThread.java:37)
      at java.lang.Thread.run(Thread.java:571)

Any ideas about the error message? I really appreciate for your help.

Thx
0
krzy4u
Asked:
krzy4u
  • 5
  • 5
1 Solution
 
chaitu chaituCommented:
have you deployed EAR in WAS?if yes you have give Classloader option for that EAR?
0
 
krzy4uAuthor Commented:
yes...i deployed the EAR in WAS. But I don't know what this Classloader option is. I am using Rational Application Developer 7 for WAS 6.0. Can you please elaborate? Thx.
0
 
chaitu chaituCommented:
In the Admin Console -Enterprise Applications -you can see ur EAR -click on EAR -now you can see lot of options were with hyper links-click on Classloading and update detection-

 
Polling interval for updated files 0 Seconds----   give 0 seconds
Class loader order Classes loaded with parent class loader first
Classes loaded with application class loader first  ---- select this option
 
WAR class loader policy Class loader for each WAR file in application
Single class loader for application  --- select this option

apply ok and save.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
krzy4uAuthor Commented:
In RAD 7, I had the following options already selected...

Class Loading and File Update Detection  
Class loader mode -Parent First  
 WAR class loader policy - Module  
 Enable class reloading  - false
 Reloading interval  - 3

Even with above settings, I am getting the error.
 
0
 
chaitu chaituCommented:
I told you select these options.......

Classes loaded with application class loader first  ---- select this option
Single class loader for application  --- select this option
0
 
krzy4uAuthor Commented:
WAS 6.0 on RAD 7 doesn't have those two options mentioned above. As I mentioned previously, it has only four attributes under Class Loading and File Update Detection -
1)Class loader mode
2)WAR class loader policy
3)Enable class reloading
4)Reloading Interval

Can you please help me find out other options that you were saying?
0
 
chaitu chaituCommented:
ok i am using 6.1 version may be these options are there .can you send the screen shot of the classloader?
0
 
krzy4uAuthor Commented:
The screen shot is attached.


ClassLoader-screenshot.doc
0
 
chaitu chaituCommented:
what are the options are there in
1)Class loader mode
2)WAR class loader policy

put different and try it yourself.

check enable classloading and put 0 in reloading interval...
0
 
krzy4uAuthor Commented:
didn't solve problem
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now