set schema for new connections (oracle)

[cheer]

Hello,

We're using spring + dbcp + jdbc + oracle (no hibernate!) now and trying to switch to another connection pool. Is there any possibility to set oracle schema for new connections? In DBCP the schema could be set by overriding getConnection() method which is not good, because the 'alter session ...' query is issued every time the connection is retrieved. It'd be really great to have some property for setting schema in application context. However, I did find nothing about setting schema in BoneCP.

Thanks.

[wwadge]

One way you could do this is to setup a connection hook, specifically the onAquire() hook:


/** Called upon getting a new connection from the JDBC driver (and prior to
* inserting into the pool). You may call connection.getInternalConnection() to obtain
* a handle to the actual (unwrapped) connection obtained from the driver.
* @param connection Handle to the new connection
*/
void onAcquire(ConnectionHandle connection);

This hook will be called just once per connection (i.e. the first time the connection is retrieved and placed into the pool ready for use).

Wallace

[cheer]

Thanks, Wallace!

I was successfully able to set schema for the new connections. If someone else is interested, I extended the AbstractConnectionHook class and set the hook in the applicationContext file.

[wwadge]

Just make sure that the hook is thread-safe and re-entrant since it can be called concurrently in different threads.



Wallace