On Thu, May 31, 2012 at 10:22 PM, elmor <eric@ejahn.net> wrote:
When using the latest Appengine/Google plugin for Eclipse, I'm seeing a difference in how my local MySQL dev database and Google Cloud SQL behave.I'm doing:String stmt = "SELECT somefield FROM sometable WHERE somekey=?";PreparedStatement pstmt = (PreparedStatement)conn.prepareStatement(stmt);pstmt.setString(1, someid);ResultSet rs = pstmt.executeQuery();It runs locally, but the query returns no results when run from the cloud. The databases are exactly the same and the query works when I use a static SQL statement in the code, instead of one that uses the setString() symbol replacement as above. Has anyone seen this before, and if so, how should I change my code, so that it works on Google Cloud SQL as well as MySQL? Thanks in advance!
--
Regards & Thanks
Shilendra Sharma
+919891343808
shilendra.bk@gmail.com
No comments:
Post a Comment