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