f



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

0
12/29/2006 12:54:31 PM
comp.lang.java.programmer 52714 articles. 1 followers. Post Follow

4 Replies
595 Views

Similar Articles

[PageSpeed] 19

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

0
arne6 (9808)
12/29/2006 1:01:11 PM
savita wrote:
>> Do I have to use other url apart from jdbc:db2:192.168.0.10

Arne Vajh�j 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�j 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
0
lew35 (549)
12/30/2006 3:53:28 AM
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
0
arne6 (9808)
12/30/2006 4:22:21 AM
Arne Vajh�j 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

0
lew35 (549)
12/30/2006 6:58:53 AM
Reply: