Solved

SQL datasource error for WAS 6.0

Posted on 2008-10-20
10
460 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
 

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
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.

 

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 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...
0
 

Author Closing Comment

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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

896 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now