Re: Test a JDBC connection

[Jim Mason <jmason900@xxxxxxxxx>]

Hi.

Obviously ANY connection DOES create some overhead in
terms of work in an SQL server job based on your
connection method.  One of the "lightest" statements
to execute would be:


mystmt.execute("SET PATH 'MYLIB'");

This sets the library list for the job to mylib.

Jim Mason

--- David Gibbs <david@midrange.com> wrote:
> Anyone know of a way to test a JDBC connection
> without actually doing
> anything significant?  I basically want to make sure
> a JDBC connection is
> working, but without putting a load on the system.
> 
> Thanks!
> 
> david
> 
> 
> _______________________________________________
> 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/mailman/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.
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com