tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Foulks" <gfou...@gmail.com>
Subject Re: JNDI example for connecting to a DB2 on OS400
Date Thu, 11 Jan 2007 12:56:06 GMT
then what would be a vaild validation query?

On 1/11/07, olivier nouguier <olivier.nouguier@gmail.com> 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>
>         <name>url</name>
> <value>jdbc:as400://yourServerName;libraries=YOURSLIB1,YOURSLIB2;prompt=false;errors=full;trace=false</value>
>       </parameter>
>       <parameter>
>         <name>driverClassName</name>
>         <value>com.ibm.as400.access.AS400JDBCDriver</value>
>       </parameter>
>       <parameter>
>
> On 1/9/07, Greg Foulks <gfoulks@gmail.com> 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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message