i am trying to undeploy a oracle xadatasource by JBoss CLI, because i need to drop the tablespace and db user.
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.
I'll take a look at this.