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: parameter nameurl/name valuejdbc:as400://yourServerName;libraries=YOURSLIB1,YOURSLIB2;prompt=false;errors=full;trace=false/value /parameter parameter namedriverClassName/name valuecom.ibm.as400.access.AS400JDBCDriver/value /parameter parameter On 1/9/07, Greg Foulks [EMAIL PROTECTED] wrote: 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 -- Souviens-toi qu'au moment de ta naissance tout le monde était dans la joie et toi dans les pleurs. Vis de manière qu'au moment de ta mort, tout le monde soit dans les pleurs et toi dans la joie.
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: parameter nameurl/name valuejdbc:as400://yourServerName;libraries=YOURSLIB1,YOURSLIB2;prompt=false;errors=full;trace=false/value /parameter parameter namedriverClassName/name valuecom.ibm.as400.access.AS400JDBCDriver/value /parameter parameter On 1/9/07, Greg Foulks [EMAIL PROTECTED] wrote: 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 -- Souviens-toi qu'au moment de ta naissance tout le monde était dans la joie et toi dans les pleurs. Vis de manière qu'au moment de ta mort, tout le monde soit dans les pleurs et toi dans la joie. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 validationQuery ( eg: select 1; is not supported by DB2/OS400 )! the URL and drivers should look like: parameter nameurl/name valuejdbc:as400://yourServerName;libraries=YOURSLIB1,YOURSLIB2;prompt=false;errors=full;trace=false/value /parameter parameter namedriverClassName/name valuecom.ibm.as400.access.AS400JDBCDriver/value /parameter parameter On 1/9/07, Greg Foulks [EMAIL PROTECTED] wrote: 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 -- Souviens-toi qu'au moment de ta naissance tout le monde était dans la joie et toi dans les pleurs. Vis de manière qu'au moment de ta mort, tout le monde soit dans les pleurs et toi dans la joie. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Souviens-toi qu'au moment de ta naissance tout le monde était dans la joie et toi dans les pleurs. Vis de manière qu'au moment de ta mort, tout le monde soit dans les pleurs et toi dans la joie.
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? 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: parameter nameurl/name valuejdbc:as400://yourServerName;libraries=YOURSLIB1,YOURSLIB2;prompt=false;errors=full;trace=false/value /parameter parameter namedriverClassName/name valuecom.ibm.as400.access.AS400JDBCDriver/value /parameter parameter On 1/9/07, Greg Foulks [EMAIL PROTECTED] wrote: 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 -- Souviens-toi qu'au moment de ta naissance tout le monde était dans la joie et toi dans les pleurs. Vis de manière qu'au moment de ta mort, tout le monde soit dans les pleurs et toi dans la joie. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Souviens-toi qu'au moment de ta naissance tout le monde était dans la joie et toi dans les pleurs. Vis de manière qu'au moment de ta mort, tout le monde soit dans les pleurs et toi dans la joie.
JNDI example for connecting to a DB2 on OS400
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