By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

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

P: n/a
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** Error getting
person for email: mi**
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
JDBC driver of class '' for connect URL

Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.jav a:264)
org.apache.commons.dbcp.BasicDataSource.createData Source(
... 45 more
Cannot create JDBC driver of class '' for
connect URL 'jdbc:db2://reg3:50000/DOGEARO'
java.sql.SQLException: No suitable driver
Any suggestions would be much appreciated?


May 11 '06 #1
Share this Question
Share on Google+
2 Replies

P: n/a

First of all you are using deprecated jdbc driver

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
(; Type-2 or Type-4).

-- Artur Wronski

May 11 '06 #2

P: n/a
Thanks Artur, for your reponse. I'm going to give your suggestions a

Thanks again,

May 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.