File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes WSAD and JSQLConnect Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "WSAD and JSQLConnect Driver" Watch "WSAD and JSQLConnect Driver" New topic
Author

WSAD and JSQLConnect Driver

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hello All,
I am having a problem, configuring my JSQLConnect( a type 4 driver for SQL Server 2000) and WSAD(Websphere Application Developer). In this new IDE you can switch JVM's. So I downloaded the driver JSQLConnect2_27 and configured my datasource. However when I run a small app to establish a connection to my SQL Server 2000 it gives me the following error

SO I thought that maybe I ought to get the latest driver which is JSQLConnect3_27, which adheres to the latest spec. When I run that it tells me that java/sql/SavePoint is not present. Which leads me to believe that IBM's JDK which in in WSAD is not upto the standards. So I download the SUN's JDK1.4.0 which when I run it gives me error that the IntialContext does not work, because apparently IBM jdk comes with a specific class called com.ibm.ejs.ns.jndi.CNInitialContextFactory. After searching on the web I found out that the new Sun's JDK also has a similar class called com.sun.jndi.cosnaming.CNCtxFactory, but it does not work with the DataSources. So I am stuck not knowing what to do. Any help will be appreciated.
Thank you all in advance!
-Amish
Simon Song
Ranch Hand

Joined: Feb 01, 2002
Posts: 217
We are using the Merant driver comes with WAS. It has Type3 and Type4 driver.
And Microsoft has OEMed their technology and to deliver Type4 driver pretty soon.
So I think you can consider Merant's driver, and later on switch to MS's. And I hope MS can have solid/serious support to JDBC driver.
WebSphere hasn't certified any other 3rd drivers yet. So you are on your own luck!


Simon Song
Certified Entperise Developer of Websphere
Giri Prasad
Ranch Hand

Joined: Mar 08, 2001
Posts: 56
Hi Amish
I am using the oracle thin driver and getting the same error
java.sql.SQLException: CONM7005E: The class (oracle.jdbc.driver.OracleDriver) does not implement javax.sql.ConnectionPoolDataSource or javax.sql.XADataSource
Could you find a solution to your problem? Can you help me on this
Thanks
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi Giri Prasad,
What is going on atleast in my case is that Websphere App Developer uses it own JDK. Which is the IBM JDK, I think it is the 1.3.*. Your driver supports the latest version of the JDBC API which uses the Sun JDK 1.4. SO if you download the new SUN JDK 1.4 this will not give you the errors you have mentioned, but in my case when I switch the JDK, I ran into a problem where IBM for optimization was using a class that was not supported or implemented the exact same way by the SUN JDK. So I was not able to configure my JSQLConnect Driver with the Sun JDK/IBM JDK.
For more info please visit the following link...
http://www.ejbinfo.com/WebSphere/01/01/28/0629217.shtml
Hope this helps!
-Amish
Originally posted by Giri Prasad:
Hi Amish
I am using the oracle thin driver and getting the same error
java.sql.SQLException: CONM7005E: The class (oracle.jdbc.driver.OracleDriver) does not implement javax.sql.ConnectionPoolDataSource or javax.sql.XADataSource
Could you find a solution to your problem? Can you help me on this
Thanks
Abhilesh Khatri
Ranch Hand

Joined: Oct 02, 2002
Posts: 39
Hi Giri
Even i'm facing the same problem. By this time, if you got any solution to it. If yes then could you help me out.
Thanks in advance.
regards
abhilesh
Originally posted by Giri Prasad:
Hi Amish
I am using the oracle thin driver and getting the same error
java.sql.SQLException: CONM7005E: The class (oracle.jdbc.driver.OracleDriver) does not implement javax.sql.ConnectionPoolDataSource or javax.sql.XADataSource
Could you find a solution to your problem? Can you help me on this
Thanks
Atul Prasad
Greenhorn

Joined: Oct 03, 2002
Posts: 1
I think the root of the problem is oversight and here's how to fix it..
On the administrative console, go to Resources->JDBC driver and click on 'Oracle JDBC driver'. In the Implementation classname, most likely you have put oracle.jdbc.OracleDriver. Change this or whatever is there to the following:
oracle.jdbc.pool.OracleConnectionPoolDataSource
( for one phase commit protocol)
--------OR-----------
oracle.jdbc.xa.client.OracleXADataSource
( for two phase commit protocol)
Hopefully it should work.
dave smethurst
Greenhorn

Joined: Oct 04, 2002
Posts: 1
Originally posted by Amish A Patel:
Hello All,
I am having a problem, configuring my JSQLConnect( a type 4 driver for SQL Server 2000) and WSAD(Websphere Application Developer). In this new IDE you can switch JVM's. So I downloaded the driver JSQLConnect2_27 and configured my datasource. However when I run a small app to establish a connection to my SQL Server 2000 it gives me the following error

SO I thought that maybe I ought to get the latest driver which is JSQLConnect3_27, which adheres to the latest spec. When I run that it tells me that java/sql/SavePoint is not present. Which leads me to believe that IBM's JDK which in in WSAD is not upto the standards. So I download the SUN's JDK1.4.0 which when I run it gives me error that the IntialContext does not work, because apparently IBM jdk comes with a specific class called com.ibm.ejs.ns.jndi.CNInitialContextFactory. After searching on the web I found out that the new Sun's JDK also has a similar class called com.sun.jndi.cosnaming.CNCtxFactory, but it does not work with the DataSources. So I am stuck not knowing what to do. Any help will be appreciated.
Thank you all in advance!
-Amish
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: WSAD and JSQLConnect Driver