Google Cloud SQL with Hibernate and ... c3p0

[Roland Beuker]

I want to use Hibernate with Google Cloud SQL. With one connection its working, but when i try to use c3p0 for connection pooling i get a java.security.AccessControlException. The Hibernate documentation states it is important to use connection in a production environment. Is Google going to enable this connection pooling option on Google Cloud SQL?

Regards,

Roland Beuker

[Joe Faith]

Hope this helps:

https://developers.google.com/cloud-sql/faq#connections

How should I manage connections?

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Joe Faith | Product Manager | Google Cloud

[Roland Beuker]

Hello Joe,

I really hope this is an temporary/intermediate situation... A new connection for each request is very disadvantageous. What about a 'Google connection poo'l in the AppEngineDriver towards Google Cloud SQL? This connection pool is particular needed in the situations when we are using long (application wide) sessions... 

This Google connection pool could be an easy port from existing available implementations...

Kind regards,

Roland Beuker

Arcus Solutions

06-33974573

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/Xi6yrn0L1C0/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-d...@googlegroups.com.