|
Wonderful, exactly what I was looking for. -----Original Message----- From: Dave Wall [mailto:dawall@us.ibm.com] Sent: Friday, March 08, 2002 8:40 AM To: java400-l@midrange.com Subject: Re: Toolbox and JDBC User / Password 1. Use the default AS400 c'tor ... AS400 system = new AS400(); That will connect you to the current system using the current job's uid/pwd. 2. Same answer for Toolbox JDBC -- don't specify system name, uid or pwd ... connection = DriverManager.getConnection ("jdbc:as400://;prop1=value;prop2=value"); Don't forget to add the classes that extract the current job's uid/pwd to your CLASSPATH. Use /qibm/proddata/os400/jt400/lib/jt400Native.jar (v5r1 and later), or jt400.jar plus /QIBM/ProdData/Java400/jt400ntv.jar David Wall Toolbox for Java iSeries ODBC Driver for Linux "Richards, Etienne (CAP, PTL)" To: "'java400-l@midrange.com'" <java400-l@midrange.com> <Etienne.Richards@ cc: penske.com> Subject: Toolbox and JDBC User / Password Sent by: java400-l-admin@mi drange.com 03/08/2002 07:03 AM Please respond to java400-l All, Two questions: 1. How do you connect to an AS/400 using the AS400 Toolbox object if you are running the code on the AS/400 and you want to connect as the current user? AS400 system = new AS400("localhost", ?, ?); 2. How do you connect to an AS/400 database using the Toolbox jdbc driver and the native DB2 jdbc driver if you are running the code on the AS/400 and you want to connect as the current user? Connection conn = DriverManager.getConnection("localhost", ?, ?); Thanks, Etienne _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l or email: JAVA400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l or email: JAVA400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.