Re: JT400 connection string

On 9/30/2024 2:10 PM, DOUGLAS ENGLANDER via JAVA400-L wrote:
> 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);

When SQL naming is used, the libraries property determines the default 
schema. If the first library is *LIBL, and there is no second library, 
the user profile is the default schema.

1) Change the naming to System instead of SQL; this has the behaviour 
most RPG programmers expect
2) Put the correct schema as the second library in the libraries 
property, for example libraries=*LIBL,PRODUCTION


-- 
   --buck

http://wiki.midrange.com
Your updates make it better!


-- 
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.