1 Reply Latest reply on Nov 20, 2006 5:24 PM by Weston M. Price

    Connection Pooling with Alter session

    Nirmal S Arri Newbie

      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

        • 1. Re: Connection Pooling with Alter session
          Weston M. Price Master

          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.