Re: Setting NLS_DATE_FORMAT using JDBC thin driver

Use the Logon Trigger it does not matter if it is executed in a autonoums trans or not ...

Since ur setting it for the session it will be active till the session logsoff the system.

HTH On 19 Feb 2002 14:21:33 -0800, andrew01_at_xs4all.nl (Andre van Winssen) wrote:

>.
>I want to make sure that NLS_DATE_FORMAT is set to "yyyy-mm-dd hh24:mi:ss"
>whenever a thin JDBC client session executes DML.
>At first I thought that an ON LOGON database trigger could do
>this for me, but the doc. sais that SQL fired in a database event
>trigger is executed in an autonomous transaction, so it won't
>help me much.
>I also don't want to execute the "alter session set nls_date_format.."
>prior to each time I execute my application sql statement because of the
>overhead involved. I know that my session is pooled (by websphere
>in this case), which means that it would be sufficient to set
>the NLS variable to the required value at session creation time as
>the SID and SERIAL# will not change (unless the pooled connection
>gets a timeout or something).
>Is there any way, besides client side programming, to accomplish this?
>Note that the JDBC thin client doesn't check client side environment
>variables, like NLS_DATE_FORMAT in the registry or as a UNIX env.
>variable.
>
>Any hints appreciated.
>
>
>
>Best regards,
>Andre van Winssen

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Wed Feb 20 2002 - 03:08:09 CST