Results 1 to 3 of 3

Thread: As/400 Db2 Jdbc

  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Unanswered: As/400 Db2 Jdbc

    Hi,

    I wish to make connection to AS/400 DB2 from a NT System.

    Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
    //Class.forName("com.ibm.db2.jcc.DB2Driver");
    //Connection con = DriverManager.getConnection("jdbc:db2://(ipaddress or hostname):6789/databasename","userid","password");

    i am using db2java.zip which is taken after installation of DB2 UDB on
    AIX

    I am getting the following Exception.

    COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01
    at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.socketE xception(SQLExcepti
    onGenerator.java:646)


    This happens if the DB2 JDBC Applet Server is not running. You need start this service.

    Is this service is same as DB2JSTRT?

    If so, is it available in AS/400 DB2.

    If so, how to start this service.

    If not what is the way to get Connection?

  2. #2
    Join Date
    Mar 2003
    Location
    Denmark
    Posts
    15
    Have you run the Client Configuration Assistant on the NT system?
    You need to install the client-side first.

  3. #3
    Join Date
    Jun 2003
    Posts
    3

    Thumbs up

    Originally posted by caf78
    Have you run the Client Configuration Assistant on the NT system?
    You need to install the client-side first.
    JDBC
    JDBC(TM) is an application programming interface (API) included in the Java platform that enables Java programs to connect to a wide range of databases.

    The IBM Toolbox for Java JDBC driver allows you to use JDBC API interfaces to issue structured query language (SQL) statements to and process results from databases on the server. You can also use IBM Developer Kit for Java JDBC driver, called the 'native' JDBC driver:

    Use the Toolbox JDBC driver when the Java program is on one system and the database files are on another system, as in a client/server environment
    Use the native JDBC driver when both the Java program and database files are on the same iSeries system
    For information about ongoing improvements, see What's new for Modification 5 and Enhancements to Toolbox for Java JDBC support.


    I am unable to create db2 connection. But using JTOpen i am able to get as400 connection.

    Thanks and Regards,
    RASE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •