Re: mysql pool problem (again)

2006-08-08 Thread Martin Kalén
Dennis Bekkering skrev: A validation query doesn't help in the MySQL scenario: The driver will automatically reconnect and successfully execute the query, but the Connection still has a chance of remaining in an inconsistent state. This won't happen on every reconnect, just on some. You are

Re: mysql pool problem (again)

2006-08-08 Thread Dennis Bekkering
Martin, Thanks for the help. As usual i was to fast with conclusions, my problems at the time originated from a connection leak. Thanks, Dennis 2006/8/8, Martin Kalén [EMAIL PROTECTED]: Dennis Bekkering skrev: A validation query doesn't help in the MySQL scenario: The driver will

Methods of calling stored procedures in OJB

2006-08-08 Thread Wright, Jim \(NIH/CIT\) [C]
Does one have to use database triggers in order to run stored procedures in OJB? The Apache documentation seems to imply that: http://db.apache.org/ojb/docu/howtos/howto-work-with-stored-procedures.h tml#A+simple+example I need a way to run them that does not involve triggers. Jim Wright

Re: Methods of calling stored procedures in OJB

2006-08-08 Thread Ron Gallagher
Jim -- OJB supports the use of stored procedures to handle all persistence operations (insert, update and delete). The stored procedures that are configured in the repository are used in place of standard insert, update and delete SQL commands. You do not need to use any sort of database