MySQL Forums :: Transactions :: empty ResultSet after connection commit
Re: empty ResultSet after connection commit
Posted by: Rick James ()
Date: October 18, 2011 08:58AM
Let's review things.
* You have made 5 separate connections?
* You are using different threads? Or different Tomcat children?
* Each connection is USEing a different database? Or are you specifying the database during the connect call?
* You are doing BEGIN...COMMIT?
* You are checking for errors after _each_ statement, not just the COMMIT?
Connector/J will (if I am not mistaken) use the _same_ connection if _all_ the parameters are identical. So, if you are using threads and USE, this could be the issue.
("5" does not seem like much stress.)
* You have made 5 separate connections?
* You are using different threads? Or different Tomcat children?
* Each connection is USEing a different database? Or are you specifying the database during the connect call?
* You are doing BEGIN...COMMIT?
* You are checking for errors after _each_ statement, not just the COMMIT?
Connector/J will (if I am not mistaken) use the _same_ connection if _all_ the parameters are identical. So, if you are using threads and USE, this could be the issue.
("5" does not seem like much stress.)
| Subject | Views | Written By | Posted |
|---|---|---|---|
| empty ResultSet after connection commit | 1868 | Raed W. | 10/16/2011 05:57AM |
| Re: empty ResultSet after connection commit | 677 | Rick James | 10/17/2011 08:27AM |
| Re: empty ResultSet after connection commit | 654 | Raed W. | 10/17/2011 10:11AM |
| Re: empty ResultSet after connection commit | 809 | Rick James | 10/18/2011 08:58AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates