[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL datasource error for WAS 6.0

Posted on 2008-10-20
10
Medium Priority
?
471 Views
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.

Thx
0
Comment
Question by:krzy4u
  • 5
  • 5
10 Comments
 
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?
0
 

Author Comment

by:krzy4u
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.
0
 
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.
0
Managing Security & Risk at the Speed of Business

Gartner Research VP, Neil McDonald & AlgoSec CTO, Prof. Avishai Wool, discuss the business-driven approach to automated security policy management, its benefits and how to align security policy management with business processes to address today's security challenges.

 

Author Comment

by:krzy4u
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.
 
0
 
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
0
 

Author Comment

by:krzy4u
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?
0
 
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?
0
 

Author Comment

by:krzy4u
ID: 22800765
The screen shot is attached.


ClassLoader-screenshot.doc
0
 
LVL 20

Accepted Solution

by:
chaitu chaitu earned 1500 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...
0
 

Author Closing Comment

by:krzy4u
ID: 31508066
didn't solve problem
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

-Xmx and -Xms are the two JVM options often used to tune JVM heap size.   Here are some common mistakes made when using them:   Assume BigApp is a java class file for the below examples. 1.         Missing m, M, g or G at the end …
Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
Suggested Courses

607 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