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

camma0001

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: mi**@yahoo.com.ibatis.dao.client.DaoException: Error getting
person for email: mi**@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.jav a:264)
at
org.apache.commons.dbcp.BasicDataSource.createData Source(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

May 11 '06 #1

Artur

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/infoce...d/t0010264.htm

-- Artur Wronski

May 11 '06 #2

camma0001

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

Thanks again,
Mike

May 11 '06 #3