Re: Connecting to db2/400 of AS400 through java throwing SQLException

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 29 Dec 2006 08:01:11 -0500

Message-ID:

<4595118c$0$49199$14726298@news.sunsite.dk>

savita wrote:

I am trying to connect to db2/400 of as400 through java in WDSC.
I am usinf the driver ->
com.ibm.db2.jcc.DB2Driver
I have put the db2jcc.jar and db2jcc_license_c.jar in classpath.

//Connect to a database
try
          {
                Connection conn = DriverManager.getConnection
                    ("jdbc:db2:192.168.0.10","SAVITA","SAVITA");
           }
catch (SQLException e)
          {
                          System.out.println("SQL Exception: ");

I strongly recommend you to print out e.

}
*******************************************************************************
I am getting the following run time error
SQL Exception
....................................................................................................
Do I have to use other url apart from jdbc:db2:192.168.0.10

I have used jdbc:db2:S650B66E

where S650B66E=system name

This should be in the DB2 JDBC docs.

I use a URL syntax like:

Connection con =
DriverManager.getConnection("jdbc:db2://localhost:50000/xxxx", "xxxx",
"xxxx");

where xxxx is database, username and password.

Arne