1 Reply Latest reply on Feb 27, 2014 8:20 AM by Jesper Pedersen

    Undeploy xadatasource do not close recovery connection

    s.horn Newbie

      Hello,

       

      i am trying to undeploy a oracle xadatasource by JBoss CLI, because i need to drop the tablespace and db user.

      JBoss 7.3.0.

       

      This seem to work (datasource undeployed in server.log), but when i try to drop the database user it tells me User in use

      And in fact the jboss has an open connection to the Oracle DB.

       

      I figured out, the periodic recovery opens the connection on first run (after two minutes) and never closes it again, until jboss is stopped.

       

      Is there any way to close this connection by CLI?

      The connection is not handled by connection pool.

      Is this a correct behavior?

       

      Thanks in advance.

       

      Sascha