Make it the servlets responsibility to convert to the JVM's Locale, and
then the JDBC driver will automatically be alter-sessionning to that
locale?
Hen
On Wed, 17 Dec 2003, Keates, Mark wrote:
> Hi,
>
> When using a servlet engine to connect to different Oracle databases,
> which can have differing default date formats, is it the responsibility of
> the
> servlet to execute an ALTER SESSION if I want to use a specific
> date format in my queries? E.g.
>
> Connection con = ds.getConnection();
> Statement s = con.createStatement();
> s.execute("alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD
> HH24:MI:SS'");
> ...
> s.close();
> con.close();
>
> Or can this be passed to the DBCP connection engine somehow so that
> when a new connection is established the correct date format is set? This
> problem has come about since the introduction of
> 'timeBetweenEvictionRunsMillis'
> into the DB ResourceParams section within server.xml.
>
> I'd rather this was done than have to intersperce 'to_date' calls everywhere
> ;(
>
> Thanks,
>
> Mark
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
