RE: JDBC Driver in WSAD

["Gibson.Stephen" <Gibson.Stephen@xxxxxxxxxxxxxx>]

Try using this for a URL if you using the native driver
(com.ibm.db2.jdbc.app.DB2Driver) and you want to specify a library list.

"jdbc:db2:yourdatabasename; naming=system;",userid,password

This will use the initial library list of the JOBD of the user you connect
as.  The naming = system specifies you are using the system naming
convention to specify library names.  If you need to add a library to the
library list, then use the libraries property

"jdbc:db2:yourdatabasename; naming=system;libraries=lib1 lib2;"
,userid,password

This will add lib1 and lib2 to the initial library list of the JOBD you
connect with.  You could create a user and a Job Description that specifies
a initial library list of *NONE and then add just the library(ies) you
wanted this way.



If you are using the toolbox JDBC driver
(com.ibm.as400.access.AS400JDBCDriver) use one of these URLs

"jdbc:as400://yoursystemURL; naming=system;",userid,password

or

"jdbc:as400://yoursystemURL; naming=system;libraries=lib1 lib2;"
,userid,password

Stephen Gibson

Lees Carpets
A Division of Burlington Industries
3330 West Friendly Avenue
Greensboro, NC 27410




-----Original Message-----
From: Rizwan Ahamad [mailto:rizwan@jarirbookstore.com]
Sent: Saturday, July 20, 2002 2:10 AM
To: java400-l@midrange.com
Subject: JDBC Driver in WSAD


This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Hello All

I am using WSAD 4.0.3 and using the Database web page Wizards to create the
pages fastly for a web application.

When i use the database connection using native AS/400 JDBC driver from
JT/400 it takes hell a lot of time to connect and the reason is it retrieves
all the available libraries including system libraries.

I have tried various options for url like
host.com/library;translate binary=true
host.com;translate binary=true;libraries=library

like that.I just want the wizard to retrieve only one library.

Or i am missing something in configuring the URL's of the AS400JDBC Driver.

will appreciate any help

TIA

Rizwan
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.