Java Database Connectivity (JDBC)

Hi!

In our application running with oc4j we configured datasources in data-sources.xml. We configured them as connection pools. Since we need to change the NLS_Date_Format for a connection every time we retrieve a connection from the datasource we execute the statement:

sqlCon.createStatement().execute("alter session set nls_date_format='YYYY-MM-DD-HH24.MI.SS'");

Since we don't want this statement to be executed every time a connection is retrieved from the connection pool but only when the connection is physically established we are wondering if there is a chance to configure this statement or the NSL_Date_Format by setting a property in data-sources.xml.

Thanks in advance!
thomas