Geronimo does not use dbcp, could you explain why you think it does?
Could you explain what proxy sessions do? There might be a simple
solution, but I have no idea what you are trying to achieve. For
instance if you are trying to change the authentication information
on an existing connection this can be achieved by adding a bit of
code to the tranql oracle wrapper.
thanks
david jencks
On Feb 10, 2008, at 6:52 PM, Brian Gregory wrote:
I'm attempting to use proxy session w/ oracle and the built-in dbcp
+ openjpa
in geronimo but I'm hung up at the start. I've done this before
with c3p0 +
hibernate but c3p0 has a ConnectionCustomizer class that allows you to
register for checkout and checkin events from the connection pool,
thus
allowing the proxy user to be modified prior to connections being
used.
Unfortunately I can't find a way to do this with dbcp, but I have a
few
ideas:
1. Subclass the dbcp PoolingDataSource such that proxy users are
set up in
the getConnection() method - Although I would have to define a
database pool
w/ that would use the new class (no idea) and setup openjpa to use
this
database pool (not sure either)
2. Use c3p0 w/ openjpa instead of the built-in dbcp. Is there a way to
deploy a database pool in geronimo w/ a 3rd party pooling library?
Is there
a good way to set up a 3rd party db pool if not?
Any other ideas are appreciated.
--
View this message in context: http://www.nabble.com/proxy-session-
w--built-in-dbcp-%2B-openjpa-tp15404731s134p15404731.html
Sent from the Apache Geronimo - Users mailing list archive at
Nabble.com.
