Hello,
thanks for all your
help.
So far I figured out
the following problem with connection pooling with Castor JDO (please correct me
if I'm wrong):
- Castor does
neither get the connection from the pool when you call db.getConnection() or
db.begin()
- nor does it close
the connection on db.close()
- instead it seems
to be getting the connection when the actual execute command is
called
I found the solution
to that problem in the newsgroups:
- To close the
connection properly, i.e. to hand it back to the pool you need to close the
ResultSet, too.
I do not reckon that
that is the way it should work, though.
Anyway, I am looking
for a code snippet which demonstrates a better way of doing
it.
(Mark, can you
elaborate on the mail you sent to my earlier email and show me how to implement
that factory object, please)
Regards,
Steffen
