search

jmac11 / googlecloudsql

Automatically exported from code.google.com/p/googlecloudsql
0 stars 0 forks source link

Setting setQueryTimeout pushes App Engine request to hang and exceed the runtime limit #104

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Setting setQueryTimeout for a query statement while trying to connect to Cloud 
SQL from Java App Engine will make the request hang and eventually reach App 
Engine's runtime limits (hitting DeadlineExceededException)

Sample Java code:

Connection conn = DriverManager.getConnection(url);
PreparedStatement statement = conn.prepareStatement("SELECT STATEMENT");
statement.setQueryTimeout(25);
ResultSet rs = statement.executeQuery();

Workaround: Remove the use of setQueryTimeout until the issue is resolved

Original issue reported on code.google.com by jfmontes...@google.com on 28 Jan 2015 at 10:27

GoogleCodeExporter commented 9 years ago

Original comment by jsche...@google.com on 24 Apr 2015 at 3:32