Connecting to db2/400 of AS400 through java throwing SQLException  
Author Message
savita





PostPosted: 2006-12-29 20:55:00 Top

java-programmer, Connecting to db2/400 of AS400 through java throwing SQLException Hello,

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.

I am not ableto connect with db2/400
The code for connecting to the database is follows-->

******************************************************************************
//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 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
In the actual code instead of 192.168.0.10 they have used databasename.
My requirement is , to call stored procedure from db2/400 of as400.
Firstly how do I connect to db2/400?
Can please any body help me out.
Thanks
Regards
Savita

 
Arne Vajh鴍





PostPosted: 2006-12-29 21:01:00 Top

java-programmer >> Connecting to db2/400 of AS400 through java throwing SQLException 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

 
Lew





PostPosted: 2006-12-30 11:53:00 Top

java-programmer >> Connecting to db2/400 of AS400 through java throwing SQLException savita wrote:
>> Do I have to use other url apart from jdbc:db2:192.168.0.10

Arne Vajh鴍 wrote:
> This should be in the DB2 JDBC docs.

E.g.,
<http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/cjvjt2cn.htm>

"Syntax for a URL for the DB2 JDBC Type 2 Driver:
jdbc:db2:database

"database
A database alias. The alias refers to the DB2 database catalog entry on the
DB2 client."

This is for the case where there is a database catalog and a Type 2 driver.

Arne Vajh鴍 wrote:
> I use a URL syntax like:
>
> Connection con =
> DriverManager.getConnection("jdbc:db2://localhost:50000/xxxx", "xxxx",
> "xxxx");
>
> where xxxx is database, username and password.

From
<http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504vohra/index.html>

"The format of the DB2 JDBC Type 4 driver [URL] is
jdbc:db2://<server>:<port>/<database>"

Can't avow that these are the last words on the subject, just the ones I
turned up googling around a bit.

- Lew
 
 
Arne Vajh鴍





PostPosted: 2006-12-30 12:22:00 Top

java-programmer >> Connecting to db2/400 of AS400 through java throwing SQLException Lew wrote:
> <http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/cjvjt2cn.htm>
>
>
> "Syntax for a URL for the DB2 JDBC Type 2 Driver:
> jdbc:db2:database

> <http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504vohra/index.html>
>
> "The format of the DB2 JDBC Type 4 driver [URL] is
> jdbc:db2://<server>:<port>/<database>"

The original post shows the type 4 jar file and class name.

Arne
 
 
Lew





PostPosted: 2006-12-30 14:59:00 Top

java-programmer >> Connecting to db2/400 of AS400 through java throwing SQLException Arne Vajh鴍 wrote:
> The original post shows the type 4 jar file and class name.

The point being that perhaps use of the Type 2 syntax was not correct, eh?

- Lew