Re: JT400 connection string

Use the “net.sf.jt400” it is on maven and is the jt open

tirs. 1. okt. 2024 kl. 19.42 skrev Richard Schoen <richard@xxxxxxxxxxxxxxxxx

:

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

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