|JDBC driver error message from EGL on Tomcat 6 on iSeries [message #919248]
||Fri, 21 September 2012 16:51
| Jeffrey Gardner
Registered: August 2012
When the exported war file for the "Access a Database with EGL Rich UI" tutorial is deployed on Tomcat 6 on the iSeries, the following runtime error message is produced:
Failure: An exception occurred during a service call. Service:services.SQLService, Function:services.SQLService
Detail 3: Exception: SQLService, getAllPayments, SQLSTATE = , message = Cannot create JDBC driver of class '' for connect URL 'null': [sqlstate:null][sqlcode:0]
I worked back through the tutorial changing database access from the Derby database to the DB2 database on my iSeries. I set up the connection profile to access the iSeries with my userid and password. I qualified all references to the file/table on the iSeries (pending my default schema and library list question elsewhere in this forum).
- The application functions without errors, correctly accessing the file on the iSeries using the Preview tab.
- Copying the jt400.jar file from the EDT program files directory to the "Tomcat6.0.20/lib" directory on my PC allowed the application to "Run as/Run on server" within the IDE.
- I exported the application to a war and deployed it into Tomcat running on my PC. It runs correctly.
- I copied the jt400Native.jar from the QIBM directory into the "Tomcat6.0.20/lib" in the IFS of the iSeries and deployed the same war file to that Tomcat installation. (That installation directory is a copy of what is on my PC with a few modifications to configuration files to make Tomcat run on the iSeries). When I run the application from that server, it produces the error.
I tried using jt400.jar instead (just to make sure) and the error message is the same. Even with neither jar file in the lib directory, the same message.
The iSeries java version is the new /QOpenSys/QIBM/ProdData/JavaVM/jdk60/32bit