aspose file tools*
The moose likes JDBC and the fly likes DataSource Connection in WSAD Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DataSource Connection in WSAD" Watch "DataSource Connection in WSAD" New topic
Author

DataSource Connection in WSAD

Chalapathi Rao
Greenhorn

Joined: Jul 08, 2003
Posts: 19
I have problems in connecting to the Database using Datasource. Previously i was using VAJ3.5 there the connection to local UDB is working fine with "COM.ibm.db2.jdbc.app.DB2Driver". But now when i use the same driver iam getting the following exception while the Entity bean(BMP) is being loaded into the local test Environment.
ERROR:
[8/5/03 8:30:03:148 GMT+01:00] 4206deb DataSourcePro W CONM7002W: Could not find the property user on class COM.ibm.db2.jdbc.app.DB2Driver
[8/5/03 8:30:03:273 GMT+01:00] 4206deb DataSourcePro W CONM7002W: Could not find the property password on class COM.ibm.db2.jdbc.app.DB2Driver
[8/5/03 8:30:03:273 GMT+01:00] 4206deb DataSourcePro W CONM7002W: Could not find the property description on class COM.ibm.db2.jdbc.app.DB2Driver
[8/5/03 8:30:03:273 GMT+01:00] 4206deb DataSourcePro W CONM7002W: Could not find the property databaseName on class COM.ibm.db2.jdbc.app.DB2Driver
[8/5/03 8:30:03:289 GMT+01:00] 4206deb DataSourcePro X CONM7005E: The class (COM.ibm.db2.jdbc.app.DB2Driver) does not implement javax.sql.ConnectionPoolDataSource or javax.sql.XADataSource
java.sql.SQLException: CONM7005E: The class (COM.ibm.db2.jdbc.app.DB2Driver) does not implement javax.sql.ConnectionPoolDataSource or javax.sql.XADataSource

Please help me to sort out this problem.
Thanks a lot in Anticipation.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

This will need to be moved to the IBM/Websphere forum, but what version of WSAD are you using? They're different.
Chalapathi Rao
Greenhorn

Joined: Jul 08, 2003
Posts: 19
Iam using WSAD4.0. Now iam testing my application in WSAD4.0 Test Environment.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30537
    
150

Did you add db2 to the classpath for your EJB project? It's one of the predefined variables, but you need to explicitly include it. Otherwise, you get lots of classpath issues.
Also, check whether the EJB project is set up to use the same server as the one that you set up the datasource on.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Chalapathi Rao
Greenhorn

Joined: Jul 08, 2003
Posts: 19
Thanks Jeanne and David for your interest.
The problem is solved when i changed the DB2 driver to COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
Now it's working fine.
 
Don't get me started about those stupid light bulbs.
 
subject: DataSource Connection in WSAD