Re: JT400 connection string

[Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>]

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.