Is there a way to timeout active connections (instead of jus

[alchemista]

Is there any configuration either through JBoss or for a JBoss Oracle connection property to set a timeout for active connections?

I know there is the idle-timeout-minutes parameter, but that appears to only timeout connections which are idle. If I have a connection that's taking 2 hours with the database, is there a way to cap that off to only 30 minutes for example before it's forced rollback?

[kalyan120]

Did you mean to timeout on a statement execution (within a connection)?

If so, you can use Statement.setQueryTimeOut(int seconds). I don't think there is any configurable way to set it on a statement via the -ds.xml or any other way.

Thanks,
Kalyan.

[reidmp]

If you use the connector within the context of a transaction, you should be able to use the transaction timeout to do what you want.