[jboss-user] [IronJacamar] - HttpSession -> Database connection

Nicklas Karlsson [http://community.jboss.org/people/nickarls] created the discussion "HttpSession -> Database connection" To view the discussion, visit: http://community.jboss.org/message/597123#597123 -------------------------------------------------------------- Hi,   I have to work with an Oracle Database and the PL/SQL uses a lot of temporary tables (per database connection) so having connections handed to you randomly from a connection pool will probably be an issue. Is it possible to write some sort of connector that would a) always give the same database connection to the same http session id client? or b) connect with a DB username/password and stick to that connection or c) some other solution that would fix a web client to a database connection Help is appreciated,   - Nik -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/597123#597123] Start a new discussion in IronJacamar at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]