Re: JNDI example for connecting to a DB2 on OS400

an actual sql query, like this... SELECT * FROM MPLIB.VRC WHERE ( RMEMBNO = '999' ) On 1/11/07, olivier nouguier <[EMAIL PROTECTED]> wrote: A query that *always* return a row ... On 1/11/07, Greg Foulks <[EMAIL PROTECTED]> wrote: > > then what would be a vaild validation query? > >

Re: JNDI example for connecting to a DB2 on OS400

A query that *always* return a row ... On 1/11/07, Greg Foulks <[EMAIL PROTECTED]> wrote: then what would be a vaild validation query? On 1/11/07, olivier nouguier <[EMAIL PROTECTED]> wrote: > Hi, > Nothing more than for another database. > But: > - be carrefull to put a valid validationQuer

Re: JNDI example for connecting to a DB2 on OS400

then what would be a vaild validation query? On 1/11/07, olivier nouguier <[EMAIL PROTECTED]> wrote: Hi, Nothing more than for another database. But: - be carrefull to put a valid validationQuery ( eg: select 1; is not supported by DB2/OS400 )! the URL and drivers should look like:

Re: JNDI example for connecting to a DB2 on OS400

Hi, Nothing more than for another database. But: - be carrefull to put a valid validationQuery ( eg: select 1; is not supported by DB2/OS400 )! the URL and drivers should look like: url jdbc:as400://yourServerName;libraries=YOURSLIB1,YOURSLIB2;prompt=false;errors=full;trace=false