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-DiTrGpQEJGItADg8e/3/[email protected]
 
----------------------------------------------------------------------

message: 1
date: Mon, 30 Sep 2024 13:10:05 -0500
from: DOUGLAS ENGLANDER via JAVA400-L <[email protected]>
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

-- 
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.