RE: JDBC URL for native connection

You can also use the toolbox driver (as per your first example) and include
driver=native in the jdbc url.
The toolbox driver will see if it's trying to connect to a local database,
and if so use the db2 driver.

-----Original Message-----
From: Ashish Kulkarni [mailto:kulkarni_ash1312@xxxxxxxxx]
Sent: 05 July 2005 21:38
To: Java Programming on and around the iSeries / AS400
Subject: Re: JDBC URL for native connection


Hi
I was able to solve my first question, how to use
native driver in AS400, 
Can any one point out how to have more then one
library in connection URL

This is how i have defined my properties file
driver=com.ibm.db2.jdbc.app.DB2Driver
url=jdbc:db2:*local/MAPS6300F3;naming=system;date
format=iso;time format=hms;prompt=false;behavior
override=1
username=*CURRENT
password=*CURRENT

Ashish
--- Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>
wrote:

> Hello
> If i have to connect to DB2 from out side AS400
> using
> JDBC connection i use
> com.ibm.as400.access.AS400JDBCDriver and define the
> following connection properties
> driver=com.ibm.as400.access.AS400JDBCDriver
> jdbc:as400:148.168.77.12/CXASH;naming=system;date
> format=iso;time format=hms;prompt=false
> username=userid
> password=password
> 
> where 148.168.77.12 is my AS400 ip address and CXASH
> is database name(library name)
> 
> Q1:-- how do i do the same if i am trying to connect
> from AS400, my property file is in IFS file system.
> Q2:-- Is it possible to have more then one library
> in
> connection URL
> 
> Regards
> 
> Ashish 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> http://mail.yahoo.com 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 


A$HI$H


                
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail