BoneCP, other connection pools and the ability to switch Schemas -

BoneCP, other connection pools and the ability to switch Schemas -

i laying ground work multi-tennant application. our strategy on database side have schemas shared (properties, persmissions , other non-tenant data) , have each tenant have own schema. (this not question on merits of decision).

i looking connection pool oracles universal connection (ucp) pool allows me set schema on connection retrieve. sake of discussion, lets assume have schemas stored on 1 database cluster , accessible same user context. not want utilize oracle's ucp. has concurrency issues wanting avoid , not using oracle (but postgresql instead).

ideally want 'pool.getconnection(forschema);'.

i can build wrapper in front end of bonecp accomplish this, hoping avoid that.

bonecp selected me because performance particular concern endeavor, @ time still open alter decision if other connection pool natively allows behavior.

if can accomplish bonecp much improve - please illuminate me.

thank in advance.

i abondoned bonecp hikaricp. needs met.

connection-pooling database-schema multi-tenant bonecp