Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL datasource error for WAS 6.0

Posted on 2008-10-20
10
Medium Priority
?
469 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
[X]
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
  • 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

704 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