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

Re: JNDI example for connecting to a DB2 on OS400

2007-01-11 Thread Greg Foulks
k like: url jdbc:as400://yourServerName;libraries=YOURSLIB1,YOURSLIB2;prompt=false;errors=full;trace=false driverClassName com.ibm.as400.access.AS400JDBCDriver On 1/9/07, Greg Foulks <[EMAIL PROTECTED]> wrote: > > I've read the JNDI

Re: How to forcibly close abandoned database connections?

2007-01-10 Thread Greg Foulks
David, Any chance you could share with me your connection pool configuration? I've been struggling with trying to setup my own connection to our DB2 using the jt400 jar and have not been able to find any documentation for doing this with a DB2 connection. Thanks, Greg On 1/10/07, David Uctaa <[

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