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.