MySQL Forums
Forum List  »  InnoDB

Problem with PreparedStatement in version 4.1.x???
Posted by: Pu Chen
Date: May 10, 2005 08:40AM

Hi there,
I have just upgraded Mysql for HP from 4.0.8 (Connector/J 3.0.11) to 4.1.11 (Copnnector/J 3.1.7) and realized that my old code did not work anymore. Be specific, the ResultSet that was obtained from executing a PreparedStatement was empty. In the process of figuring what went wrong, I replaced the PreparedStatement with non-prepared statement and it works:

String query = "SELECT xxxxxxxxx";
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(query);

Just wondering if anyone has experienced the same issue? The query string is pretty long and have couple of inner joins and outer joins and plus order by clause. I don't know if that also contribute to the problem.



Options: ReplyQuote

Written By
Problem with PreparedStatement in version 4.1.x???
May 10, 2005 08:40AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.