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)
Try using the driver in c:/sqllib/java12
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
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...
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>...