krzy4u
asked on
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 createManagedConnectionWit hMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/NTSQLDB, throwing ResourceAllocationExceptio n. Original exception: <========================= ========>E xception Message -> class "com.microsoft.jdbc.base.B aseExcepti ons"'s signer information does not match signer information of other classes in the same package
java.lang.SecurityExceptio n: class "com.microsoft.jdbc.base.B aseExcepti ons"'s signer information does not match signer information of other classes in the same package
at java.lang.ClassLoader.chec kCerts(Cla ssLoader.j ava(Compil ed Code))
at java.lang.ClassLoader.defi neClass(Cl assLoader. java(Compi led Code))
at java.security.SecureClassL oader.defi neClass(Se cureClassL oader.java (Compiled Code))
at java.net.URLClassLoader.de fineClass( URLClassLo ader.java( Compiled Code))
at java.net.URLClassLoader.ac cess$500(U RLClassLoa der.java(I nlined Compiled Code))
at java.net.URLClassLoader$Cl assFinder. run(URLCla ssLoader.j ava(Compil ed Code))
at java.security.AccessContro ller.doPri vileged1(N ative Method)
at java.security.AccessContro ller.doPri vileged(Ac cessContro ller.java( Compiled Code))
at java.net.URLClassLoader.fi ndClass(UR LClassLoad er.java(Co mpiled Code))
at com.ibm.ws.bootstrap.ExtCl assLoader. findClass( ExtClassLo ader.java( Compiled Code))
at java.lang.ClassLoader.load Class(Clas sLoader.ja va(Compile d Code))
at java.lang.ClassLoader.load Class(Clas sLoader.ja va(Compile d Code))
at com.microsoft.jdbcx.base.B aseDataSou rce.setupE xceptionHa ndling(Unk nown Source)
at com.microsoft.jdbcx.base.B aseDataSou rce.getBas eConnectio n(Unknown Source)
at com.microsoft.jdbcx.base.B aseXADataS ource.getX AConnectio n(Unknown Source)
at com.microsoft.jdbcx.sqlser ver.SQLSer verDataSou rce.getXAC onnection( Unknown Source)
at com.ibm.ws.rsadapter.DSCon figuration Helper$1.r un(DSConfi gurationHe lper.java: 1071)
at com.ibm.ws.security.util.A ccessContr oller.doPr ivileged(A ccessContr oller.java (Compiled Code))
at com.ibm.ws.rsadapter.DSCon figuration Helper.get PooledConn ection(DSC onfigurati onHelper.j ava:1104)
at com.ibm.ws.rsadapter.spi.W SRdbDataSo urce.getPo oledConnec tion(WSRdb DataSource .java:1257 )
at com.ibm.ws.rsadapter.spi.W SManagedCo nnectionFa ctoryImpl. createMana gedConnect ion(WSMana gedConnect ionFactory Impl.java: 981)
at com.ibm.ejs.j2c.poolmanage r.FreePool .createMan agedConnec tionWithMC Wrapper(Fr eePool.jav a:1693)
at com.ibm.ejs.j2c.poolmanage r.FreePool .createOrW aitForConn ection(Fre ePool.java :1449)
at com.ibm.ejs.j2c.poolmanage r.PoolMana ger.reserv e(PoolMana ger.java:2 157)
at com.ibm.ejs.j2c.Connection Manager.al locateMCWr apper(Conn ectionMana ger.java:9 26)
at com.ibm.ejs.j2c.Connection Manager.al locateConn ection(Con nectionMan ager.java: 630)
at com.ibm.ws.rsadapter.jdbc. WSJdbcData Source.get Connection (WSJdbcDat aSource.ja va:413)
at com.ibm.ws.rsadapter.jdbc. WSJdbcData Source.get Connection (WSJdbcDat aSource.ja va:382)
at com.xyz.abc.ejb.xyzservice s.XYZServi cesBean.pr ocessTCOs( TCOService sBean.java :100)
at com.xyz.abc.ejb.xyzservice s.EJSLocal StatelessX YZServices _cc17f4f6. processTCO s(EJSLocal StatelessX YZServices _cc17f4f6. java:68)
at sun.reflect.NativeMethodAc cessorImpl .invoke0(N ative Method)
at sun.reflect.NativeMethodAc cessorImpl .invoke(Na tiveMethod AccessorIm pl.java:85 )
at sun.reflect.NativeMethodAc cessorImpl .invoke(Na tiveMethod AccessorIm pl.java:58 )
at sun.reflect.DelegatingMeth odAccessor Impl.invok e(Delegati ngMethodAc cessorImpl .java(Comp iled Code))
at java.lang.reflect.Method.i nvoke(Meth od.java(Co mpiled Code))
at com.xyz.abcp.utils.BaseDel egate.call SessionBea n(BaseDele gate.java: 67)
at com.xyz.abc.ejb.tcoservice s.XYZServi cesDelegat e.processT COs(XYZSer vicesDeleg ate.java:3 6)
at com.xyz.abcp.tco.ProcessTh read.run(P rocessThre ad.java:37 )
at java.lang.Thread.run(Threa d.java:571 )
Any ideas about the error message? I really appreciate for your help.
Thx
00000025 FreePool E J2CA0046E: Method createManagedConnectionWit
java.lang.SecurityExceptio
at java.lang.ClassLoader.chec
at java.lang.ClassLoader.defi
at java.security.SecureClassL
at java.net.URLClassLoader.de
at java.net.URLClassLoader.ac
at java.net.URLClassLoader$Cl
at java.security.AccessContro
at java.security.AccessContro
at java.net.URLClassLoader.fi
at com.ibm.ws.bootstrap.ExtCl
at java.lang.ClassLoader.load
at java.lang.ClassLoader.load
at com.microsoft.jdbcx.base.B
at com.microsoft.jdbcx.base.B
at com.microsoft.jdbcx.base.B
at com.microsoft.jdbcx.sqlser
at com.ibm.ws.rsadapter.DSCon
at com.ibm.ws.security.util.A
at com.ibm.ws.rsadapter.DSCon
at com.ibm.ws.rsadapter.spi.W
at com.ibm.ws.rsadapter.spi.W
at com.ibm.ejs.j2c.poolmanage
at com.ibm.ejs.j2c.poolmanage
at com.ibm.ejs.j2c.poolmanage
at com.ibm.ejs.j2c.Connection
at com.ibm.ejs.j2c.Connection
at com.ibm.ws.rsadapter.jdbc.
at com.ibm.ws.rsadapter.jdbc.
at com.xyz.abc.ejb.xyzservice
at com.xyz.abc.ejb.xyzservice
at sun.reflect.NativeMethodAc
at sun.reflect.NativeMethodAc
at sun.reflect.NativeMethodAc
at sun.reflect.DelegatingMeth
at java.lang.reflect.Method.i
at com.xyz.abcp.utils.BaseDel
at com.xyz.abc.ejb.tcoservice
at com.xyz.abcp.tco.ProcessTh
at java.lang.Thread.run(Threa
Any ideas about the error message? I really appreciate for your help.
Thx
have you deployed EAR in WAS?if yes you have give Classloader option for that EAR?
ASKER
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.
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.
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.
ASKER
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.
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.
I told you select these options.......
Classes loaded with application class loader first ---- select this option
Single class loader for application --- select this option
Classes loaded with application class loader first ---- select this option
Single class loader for application --- select this option
ASKER
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?
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?
ok i am using 6.1 version may be these options are there .can you send the screen shot of the classloader?
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
didn't solve problem