RE: JT400 connection string

Is there a reason you wouldn't just stick with jt400.jar ?

Do you have something like db2 connect ?

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
 
----------------------------------------------------------------------

message: 1
date: Mon, 30 Sep 2024 13:10:05 -0500
from: DOUGLAS ENGLANDER via JAVA400-L <java400-l@xxxxxxxxxxxxxxxxxx>
subject: JT400 connection string

I have this in my Java program and it works to get a connection. I think this is not using JT400.JAR. The connection works. But when I try to run a SQL Insert, it says it can't find the table in the ABCDEFGH library. Which is correct since that library does not exist. What do I need to change here so the driver uses *LIBL instead of ABCDEFGH?

Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
db2_conn = DriverManager.getConnection("jdbc:db2:localhost", "ABCDEFGH", db2password);

db2password is a String that is populated two lines above by reading one line from a hardcoded IFS file.


When I use this [which I think is accessing JT400.JAR]:

Class.forName("com.ibm.as400.access.AS400JDBCDriver")
db2_conn = DriverManager.getConnection(
"jdbc:as400://system;libraries=*LIBL;naming=sql;", "ABCDEFGH", "password"
);


I replace system with our system ID. When I run the program, I get this
message:

java.sql.SQLException: Communication link failure. (Connection was dropped
unexpectedly.)


This import is at the beginning of the program:

import com.ibm.as400.access.*;


Can anyone advise as to why neither of these are working?

Thank you,

Doug