What's the best way to move from one DB2 server to another?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

camma0001@gmail.com - 11 May 2006 16:47 GMT

Hi. I'm in a jam... I restored a DB2 database from one win 2003 DB2 8
server system to another DB2 8 server system now I can't connect.

I'm trying to connect my tomcat app server to the remote DB2 database.
It was initially configured to work against the local DB2 database.

I can remotely connect via the DB2 command line, but my tomcat app
server is failing with:

109 IBatisDogearTransactionManager.perform: Error getting person for
email: mike@yahoo.com.ibatis.dao.client.DaoException: Error getting
person for email: mike@yahoo.com
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
JDBC driver of class 'COM.ibm.db2.jdbc.app.DB2Driver' for connect URL
'jdbc:db2://reg3:50000/DOGEARO'

Caused by: java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getDriver(DriverManager.java:264)
    at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
    ... 45 more
Cannot create JDBC driver of class 'COM.ibm.db2.jdbc.app.DB2Driver' for
connect URL 'jdbc:db2://reg3:50000/DOGEARO'
java.sql.SQLException: No suitable driver

Any suggestions would be much appreciated?

Thanks!
Mike

Reply to this Message

Artur - 11 May 2006 20:26 GMT

Mike,

First of all you are using deprecated jdbc driver
(COM.ibm.db2.jdbc.app.DB2Driver).

This driver is only Type-2, which means, that you have to install DB2
Client on tomcat server, and properly catalog remote database (check
also url and user and password).

I would suggest also to try DB2 Universal JDBC Driver
(com.ibm.db2.jcc.DB2Driver; Type-2 or Type-4).
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/ad/
t0010264.htm

-- Artur Wronski

Reply to this Message

camma0001@gmail.com - 11 May 2006 21:08 GMT

Thanks Artur, for your reponse. I'm going to give your suggestions a
try.

Thanks again,
Mike

Reply to this Message