Google App Engine Cloud SQL Exception: Invalid connection id. Error Code: 1007 -


i have exception being thrown intermittently, when cron task have set tries access google app engine's cloud sql instance:

: [el info]: 2013-10-07 07:30:17.111--unitofwork(26414416)--communication failure detected when attempting perform read query outside of transaction. attempting retry query. error was: exception [eclipselink-4002] (eclipse persistence services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.databaseexception internal exception: com.google.cloud.sql.jdbc.internal.sqlunknownconnectionidexception: invalid connection id. error code: 1007

this not seem happen when call same controller address bar, intermittently cron task.

any ideas?

thank you.

com.google.cloud.sql.jdbc.internal.sqlunknownconnectionidexception: invalid connection id.

if using connection pool, default cloud sql connections gets purged after 15 minutes. decided away connection pooling.

in hibernate did following config , no longer have issue.

property name = "hibernate.connection.pool_size" value = "0"


Comments

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -