RE: JDBC URL for native connection

On a side note, if you use "system" naming and you leave the "libraries" param 
blank it will use the library list of the profile the driver is connecting 
with. 


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx on behalf of Pete Helgren
Sent: Tue 7/5/2005 4:45 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: JDBC URL for native connection
 
url=jdbc:db2:*local/MAPS6300F3;libraries=mylib1,mylib2,mylib3;naming=system;date


I think that is the correct syntax (libraries=mylib1,mylib2,mylib3)

Pete Helgren


Ashish Kulkarni wrote:

>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 
>  
>