WSAD and JSQLConnect Driver

[Anonymous]

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

Error opening SQL connection: CONM7005E: The class (com.jnetdirect.jsql.JSQLDriver) does not implement javax.sql.ConnectionPoolDataSource or javax.sql.XADataSource
UTILEXCEPTION: DbUtil.openConnection: Unable to get a connection to the database

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]

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!

[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

[Anonymous]

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]

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]

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]

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

Error opening SQL connection: CONM7005E: The class (com.jnetdirect.jsql.JSQLDriver) does not implement javax.sql.ConnectionPoolDataSource or javax.sql.XADataSource
UTILEXCEPTION: DbUtil.openConnection: Unable to get a connection to the database

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