Problem with PreparedStatement in version 4.1.x???

[Pu Chen]

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