Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[IBM][JDBC Driver] CLI0626E getXAConnection() through the net driver is not supported in this version of DB2 JDBC 2.0 driver..

9 views
Skip to first unread message

Yongtao

unread,
Mar 16, 2004, 2:37:22 PM3/16/04
to
Hi,

I am getting the error message as shown on the subject line. My
configurations are as follows:

o Application Server: WebSphere AppServer v5.1;
o JDBC dirver: DB2 Connect Enterprise Edition v8.1
o Client platform: Windows XP
o Host platform: DB2 on z/OS
o Classpath: c:/sqllib/java/db2java.zip
o Implementation Classname: COM.ibm.db2.jdbc.DB2XADataSource
o Datasource Helper Classname:
com.ibm.websphere.rsadapter.DB2DataStoreHelper
also tried com.ibm.websphere.rsadapter.DB2390DataStoreHelper
o Custom Property: enable2Phase=true

Any hint what did I do wrong?

Thanks.
Yongtao

Here is the full stack trace:

R java.lang.Exception: java.sql.SQLException: [IBM][JDBC Driver]
CLI0626E getXAConnection() through the net driver is not supported in
this version of DB2 JDBC 2.0 driver.
R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:1810)
R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
R at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:523)
R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:451)
R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
R at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
R at com.tivoli.jmx.modelmbean.MMBInvoker.invoke(MMBInvoker.java:46)
R at com.tivoli.jmx.modelmbean.MMBInvoker.invokeOperation(MMBInvoker.java:115)
R at com.tivoli.jmx.modelmbean.DynamicModelMBeanSupport.invoke(DynamicModelMBeanSupport.java:409)
R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:323)
R at com.tivoli.jmx.GenericMBeanSupport.invoke(GenericMBeanSupport.java:178)
R at com.tivoli.jmx.MBeanAccess.invoke(MBeanAccess.java:113)
R at com.tivoli.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:290)
R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:659)
R at com.ibm.ws.console.resources.jdbc.DataSourceCollectionAction.perform(DataSourceCollectionAction.java:248)
R at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1791)
R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
R at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
R at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)

Paul Ilechko

unread,
Mar 16, 2004, 3:19:53 PM3/16/04
to
Yongtao wrote:
> Hi,
>
> I am getting the error message as shown on the subject line. My
> configurations are as follows:
>
> o Application Server: WebSphere AppServer v5.1;
> o JDBC dirver: DB2 Connect Enterprise Edition v8.1
> o Client platform: Windows XP
> o Host platform: DB2 on z/OS
> o Classpath: c:/sqllib/java/db2java.zip
> o Implementation Classname: COM.ibm.db2.jdbc.DB2XADataSource
> o Datasource Helper Classname:
> com.ibm.websphere.rsadapter.DB2DataStoreHelper
> also tried com.ibm.websphere.rsadapter.DB2390DataStoreHelper
> o Custom Property: enable2Phase=true
>
> Any hint what did I do wrong?
>

Try using the driver in c:/sqllib/java12


Yongtao

unread,
Mar 16, 2004, 10:01:29 PM3/16/04
to
Paul Ilechko <ple...@us.ibm.com> wrote in message news:<40576169...@us.ibm.com>...

I can't find the directory c:/sqllib/java12 under my installation. I
tried both "Typical" and "Custom" (where I selected everything)
install. None of them created a directory called java12.

BTW, I installed both DB2 Connect Enterprise Edition V8.1 and DB2
Application Development Clients V8.1.

What do I need to install in order to get it?

Thanks a lot.
Yongtao

Andreas Bergmann

unread,
Mar 17, 2004, 3:00:17 AM3/17/04
to
I believe the db2.net driver does not support XA connections.

Try using a different driver instead.

If you use the wizards in WSAD/WAS to set up a datasource it shows that the
"DataSource (XA) Driver" is deprecated and recommends you use the DB2 Legacy
CLI-based Type 2 JDBC Driver (XA) instead.

Its implementation class is:
COM.ibm.db2.jdbc.DB2XADataSource

Also, if you use this driver: You need a db2 client on your WAS server and
must register your database on your DB2 server with it in order to connect
to it from the was server using this db2.app driver.

hope this helps
Andreas
"Yongtao" <yon...@hotmail.com> wrote in message
news:163a514a.04031...@posting.google.com...

DB2

unread,
Mar 17, 2004, 12:29:53 PM3/17/04
to
Hi,

I suggest you try with another DB2 JDBC driver, ie StarSQL (www.starquest.com).

Bob

yon...@hotmail.com (Yongtao) wrote in message news:<163a514a.04031...@posting.google.com>...

0 new messages