DB2 JDBC Load issue for xMII 11.5

[Former Member]

Hi All. We are attempting to create a data connection to a DB2 database. When we test the connection, we see this in the backend of the system:

2008-02-12 14:48:56,547 [ServletExec: request: time=1202849336547, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Disabling server AltivityMasterData_DB2

2008-02-12 14:48:56,563 [ServletExec: request: time=1202849336547, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Enabling server AltivityMasterData_DB2

2008-02-12 14:48:56,579 [ServletExec: request: time=1202849336547, uri=/Lighthammer/Admin/CMSAdmin] ERROR ConnectionPool - Error loading JDBC driver, java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.net.DB2Driver, App folder=D:\ServletExec AS\se-xMII\webapps\default\Lighthammer\

2008-02-12 14:48:56,579 [ServletExec: request: time=1202849336547, uri=/Lighthammer/Admin/CMSAdmin] FATAL Connector - Unable to create connection pool for AltivityMasterData_DB2: java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.net.DB2Driver, App folder=D:\ServletExec AS\se-xMII\webapps\default\Lighthammer\

2008-02-12 14:48:56,579 [ServletExec: request: time=1202849336547, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Create Server [name=AltivityMasterData_DB2,className=com.lighthammer.Illuminator.connectors.IDBC.IDBC,description=Altivity Master Data DB2 database,enabled=true,connected=false,holder=null]

2008-02-12 14:50:31,097 [ServletExec: request: time=1202849431097, uri=/Lighthammer/Illuminator] ERROR CMSFilter - Authorization error, -101 - ticket 'ST-161-uFmz15jpuZVYIBJm3fa7' not recognized

2008-02-12 14:50:39,956 [ServletExec: request: time=1202849439956, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Disabling server Altivity Development DB2 xMII Database

2008-02-12 14:50:39,956 [ServletExec: request: time=1202849439956, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Enabling server Altivity Development DB2 xMII Database

2008-02-12 14:50:39,972 [ServletExec: request: time=1202849439956, uri=/Lighthammer/Admin/CMSAdmin] ERROR ConnectionPool - Error loading JDBC driver, java.lang.ClassNotFoundException: db2jcc4.jar, App folder=D:\ServletExec AS\se-xMII\webapps\default\Lighthammer\

2008-02-12 14:50:39,972 [ServletExec: request: time=1202849439956, uri=/Lighthammer/Admin/CMSAdmin] FATAL Connector - Unable to create connection pool for Altivity Development DB2 xMII Database: java.lang.ClassNotFoundException: db2jcc4.jar, App folder=D:\ServletExec AS\se-xMII\webapps\default\Lighthammer\

2008-02-12 14:50:39,972 [ServletExec: request: time=1202849439956, uri=/Lighthammer/Admin/CMSAdmin] SYSTEM Connector - Create Server [name=Altivity Development DB2 xMII Database,className=com.lighthammer.Illuminator.connectors.IDBC.IDBC,description=DB2_Database,enabled=true,connected=false,holder=null]

2008-02-12 14:55:37,401 [JCO.ServerThread-1] ERROR SERVER-EXCEPTION - [null,null,null,] com.sap.mw.jco.JCO$Exception: (129) JCO_ERROR_SERVER_STARTUP: Server startup failed at Tue Feb 12 14:55:37 GMT-06:00 2008.

This is caused by either a) erroneous server settings, b) the backend system has been shutdown, c) network problems. Will try next startup in 1024 seconds.

Missing -a<Program ID>,

Has anyone seen this before? We have a SQL Server connection up and running without issue. Not sure where to look for this problem. Any help is appreciated!

Cheers,

Tim

[jcgood25]

It doesn't appear that you've deployed the proper driver components. Is your DB2 database really running on a Windows server?

The following 2 errors seem to indicate that you are missing some components, the class not found would indicate that the jar file you put into the lib directory doesn't contain this java class file, and the missing jar file might indicate that you need more than one file for this driver to function.

java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.net.DB2Driver

java.lang.ClassNotFoundException: db2jcc4.jar

Here are some reference sites that might help:

http://www.minq.se/products/dbvis/drivers.html#db2

http://www.oxygenxml.com/database_drivers.html

IBM's JTOpen would be the JDBC driver to use is your DB2 instance is on an AS/400 server.

Regards,

Jeremy

[Former Member]

Hi Jeremy,

THank you for your reponse - I should have mentioned this. The DB2 database sits on an AIX server. The xMII server is on windows of course. There is a PI server involved too, but that's not relevant. DB2 and xMII sit on separate boxes.

I'll research your links - greatly appreciated.

-Tim