Re: JNDI example for connecting to a DB2 on OS400

2007-01-11 Thread olivier nouguier
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: parameter nameurl/name

Re: JNDI example for connecting to a DB2 on OS400

2007-01-11 Thread Greg Foulks
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

2007-01-11 Thread olivier nouguier
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 validationQuery ( eg:

Re: JNDI example for connecting to a DB2 on OS400

2007-01-11 Thread Greg Foulks
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? On

JNDI example for connecting to a DB2 on OS400

2007-01-09 Thread Greg Foulks
I've read the JNDI docs and can't find an example as to how to configure a connection for a DB2. I need to be able to setup a autoreconnect and a validation query in my server.xml but can't seem to find an example. Anyone able to help direct me in the to right location? Greg