1

I usually use AS400JDBCDriver to connect to AS400 and work with the DB and this works fine both inside and outside AS400.

Now I've developed a class that will run on AS400 and access the DB, but the customer doesn't want to provide credential to access the DB, assuming that the access from inside AS400 should not need a user and password because the user is already logged.

Some time ago I used com.ibm.db2.jdbc.app.DB2Driver instead of com.ibm.as400.access.AS400JDBCDriver to access the AS400 DB from local classes.

My first problem is that I cannot find the class com.ibm.db2.jdbc.app.DB2Driver inside jt400.jar from sourceforge.

The second problem is that, assuming I could find the class com.ibm.db2.jdbc.app.DB2Driver, does this class allow an access without credetials ?

Any hint would be appreciated

Flavio

user1805879
  • 61
  • 1
  • 7

2 Answers2

4

com.ibm.db2.jdbc.app.DB2Driver is supplied with the Developer Kit for Java and is located in the $JDK_HOME/lib/tools.jar library.

JDK_HOME is in /QIBM/ProdData/Java400/jdkversion for V5R4 and earlier and /QOpenSys/ProdData/JavaVM/jdkversion/architecture for V6R1 and above.

Class Names for IBM i Native and IBM DB2 Connect JDBC Drivers

The credentials are not necessary if you are using a native driver (jt400Native.jar, tools.jar).

James Allman
  • 40,573
  • 11
  • 57
  • 70
  • I cannot find that path, under /QIBM/ProdData/Java400 I've only 4 directories, com, ext, fonts and MRI2932. We run on a V7R1 machine. – user1805879 Jul 29 '13 at 15:41
  • @user1805879 Updated my answer with the V7R1 JDK_HOME path information. – James Allman Jul 29 '13 at 16:12
  • On our system I found the driver class located into /QIBM/ProdData/Java400/ext inside db2_classes.jar. The driver needs a CCSID (at job level) different from 65535 and user and password set to null. In this way I can open the connection using the logged in user credentials. – user1805879 Jul 30 '13 at 09:26
1

If you run on the AS/400 itself using the jt400/jtopen driver you can connect to "localhost" as user *CURRENT with password *CURRENT and not have to provide actual credentials.

This works both for JDBC connections and AS400 objects (which is used by the JDBC driver).

Thorbjørn Ravn Andersen
  • 73,784
  • 33
  • 194
  • 347