Setting NLS_DATE_FORMAT using JDBC thin driver

.
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 Received on Tue Feb 19 2002 - 16:21:33 CST