[jboss-user] [JCA/JBoss] - Connection Pooling with Alter session

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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987417#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...