• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DataSource Connection in WSAD

 
Chalapathi Rao
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Iam using WSAD4.0. Now iam testing my application in WSAD4.0 Test Environment.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34210
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Chalapathi Rao
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic