Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

SQL datasource error for WAS 6.0

Posted on 2008-10-20
Last Modified: 2013-12-11
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.

Question by:krzy4u
  • 5
  • 5
LVL 20

Expert Comment

by:chaitu chaitu
ID: 22763958
have you deployed EAR in WAS?if yes you have give Classloader option for that EAR?

Author Comment

ID: 22770012
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.
LVL 20

Expert Comment

by:chaitu chaitu
ID: 22773624
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.
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.


Author Comment

ID: 22778540
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.
LVL 20

Expert Comment

by:chaitu chaitu
ID: 22782684
I told you select these options.......

Classes loaded with application class loader first  ---- select this option
Single class loader for application  --- select this option

Author Comment

ID: 22790590
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?
LVL 20

Expert Comment

by:chaitu chaitu
ID: 22792708
ok i am using 6.1 version may be these options are there .can you send the screen shot of the classloader?

Author Comment

ID: 22800765
The screen shot is attached.

LVL 20

Accepted Solution

chaitu chaitu earned 500 total points
ID: 22801745
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...

Author Closing Comment

ID: 31508066
didn't solve problem

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question