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.

Thanks

Pu

Options: ReplyQuote


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


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.