Error while connecting to DB2 from JBoss Application Server

views:

464

answers:

Error while connecting to DB2 from JBoss Application Server

Hi,

I'm trying to connect to the AS400 database DB2 from a Java application hosted in JBoss application server. But, I'm getting the below error when ever I run my application:

Apparently wrong driver class specified for URL: class: com.ibm.as400.access.AS400JDBCDriver, url: jdbc:as400://DBSYTEM;driver=toolbox;trace=false;errors=full;prefetch=true;naming=system;libraries=*LIBL

Has anyone ever faced similar problem before?

Thanks,

Veera.

From the connection URL in your question, I think you're using DB2 on AS/400.

Have you verified the existence of the correct classpath of IBM DB2 for AS/400 JDBC driver? The JDBC driver of IBM DB2 for AS/400 is not provided by JBoss Application Server, it's provided only from IBM.

eriawan 2009-03-13 05:29:19

I've placed the the DB2 JDBC driver db2java.jar as well as jt400.jar files inside the WEB-INF/lib folder. but still I'm getting the errors. :(

2009-03-13 09:03:48

No, this is sometimes not enough. you have to be sure that your Java CLASSPATH has included your Java classes or jar files of your IBM DB2 for AS/400 JDBC driver, not just the WEB-INF folder/directory.

eriawan 2009-03-13 16:03:41

+1 A:

I had exactly the same problem.

Setting connection-url as the following resolved the problem. jdbc:as400://[systemname]/[schema];extended dynamic=true;package=jbpkg;package cache=true;package library=jboss;errors=full

Evgeny Tshiorny 2009-09-22 17:27:26

ansaurus

tags:

views:

answers:

Error while connecting to DB2 from JBoss Application Server

related questions