then what would be a vaild validation query?

On 1/11/07, olivier nouguier <olivier.nouguier@(protected):
> 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@(protected):
> >
> > 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@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)