Connection Pooling with Alter session

[nsingh49]

I have a question about connection pooling
using Oracle DB. The issue is that with 10g date
format. It has changed from timestamp to date only
something like:
10/10/2006 10:10:10.00 in 9i, to 10/10/2006 in 10g,
which is an issue with our application.

My question is, is there a way I can set the
connection pool in the JBoss, say some properities file to
say that, when you make a connect for the connection
pool, run an alter session statement to change the
data format for that session.

Thanks in advance.

Nirmal

[weston.price]

This is a JDBC level operation and as such is generally the client responsiblity. This might be something to consider for JBoss5.x when we move over to using interceptors and Microcontainer in the JCA implementation.

Easiest thing to do at this point would be to write a ServiceLocator like thing that makes the changes prior to handing out the connection to the client.