cancel
Showing results for 
Search instead for 
Did you mean: 

AS400JDBCDriver does not work on ver 12

0 Kudos

I am trying to make a connection to a AS400 using the JTOpen JDBC driver on ver 12 of xMII. This is the same JDBC driver that works on ver 11.5. On ver 12 error "unable to determine maximum number of connections from jdbc driver" and others

JDBC driver - com.ibm.as400.access.AS400JDBCDriver

ServerURL - jdbc:as400://hyrkmfg1/SWCRLOD;date format=iso;date separator=-

I tried to used the server name (hyrkmfg1) and IP address in the server url both fail. Not sure if JTOpen supports use of IP.

Edited by: Sam Lubbad on Mar 18, 2008 10:54 AM

Accepted Solutions (1)

Accepted Solutions (1)

jcgood25
Active Contributor
0 Kudos

Sam,

I assume you've used the menu web page and uploaded the necessary jar/zip file(s) for the JTOpen driver?

http://superb-east.dl.sourceforge.net/sourceforge/jt400/readme_6_1.html

Can you ping the server name from the web server? Using the IP address should work just fine as well, as long as there are no TCP/IP port issues between the NW and DB2 servers.

Regards,

Jeremy

0 Kudos

Restarting the server fixed the problem. Not sure if the server needs to be restarted after any jdbc driver upload???

jcgood25
Active Contributor
0 Kudos

Glad to hear you are connected!

v12 should only require an Upload and Deploy from the jsp page. If you didn't do the Deploy then it sort of makes sense that a NW restart did the trick, since I think that's part of the startup process.

Regards,

Jeremy

0 Kudos

Uploaded AND deployed but did not work. Not sure???

Answers (0)