I am using Gwt + gae + cloud sql + data nucleus, can anybody shed some light on how to do connection pool and how to monitor in-flight stats.
Thanks -Gana On Feb 14, 6:36 pm, lisandrodc <[email protected]> wrote: > Thanks Ikai! > Has it some simple example with GAE and Cloud SQL? > I did not find in Internet. > Thanks and regards > Lisandro > > On 14 feb, 15:15, "Ikai Lan (Google)" <[email protected]> wrote: > > > > > That's right. When working with the datastore, it's probably best to > > understand it first by learning the low-level API. There's a trap when you > > start trying to think of the datastore relationally - do not do this. > > > -- > > Ikai Lan > > Developer Programs Engineer, Google App Engine > > plus.ikailan.com > > > On Tue, Feb 14, 2012 at 10:12 AM, Paul Ford <[email protected]> wrote: > > > Ikai, > > > > This is great so Hibernate on GAE works for Cloud SQL but not Datastore. I > > > understand. > > > > Thanks > > > > paul > > > > On Tue, Feb 14, 2012 at 11:57 AM, Ikai Lan (Google) > > > <[email protected]>wrote: > > > >> Hibernate works. I've gotten Cloud SQL to work with Hibernate ... the > > >> article has just been pending for some time now. You just want to turn > > >> off > > >> connection pooling and use AppEngineDriver where a SQL Driver is > > >> expected. > > >> Example configuration XML: > > > >> *<?xml version='1.0' encoding='utf-8'?> > > >> <!DOCTYPE hibernate-configuration PUBLIC > > >> "-//Hibernate/Hibernate Configuration DTD 3.0//EN" > > >> "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd";> > > > >> <hibernate-configuration> > > > >> <session-factory> > > > >> <!-- Database connection settings --> > > >> <property > > >> name="connection.driver_class">com.google.appengine.api.rdbms.AppEngineDriv > > >> er</property> > > >> <property name="connection.url">jdbc:google:rdbms:// > > >> YOUR_CLOUD_SQL_INSTANCE_ID/guestbook</property> > > > >> <!-- JDBC connection pool (use the built-in) --> > > >> <property name="connection.pool_size">1</property> > > > >> <!-- SQL dialect --> > > >> <property > > >> name="dialect">org.hibernate.dialect.MySQLDialect</property> > > > >> <!-- Disable the second-level cache --> > > >> <property > > >> name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> > > > >> <!-- Echo all executed SQL to stdout --> > > >> <property name="show_sql">true</property> > > > >> <!-- Drop and re-create the database schema on startup --> > > >> <property name="hbm2ddl.auto">update</property> > > > >> <mapping resource="BLAH"/> > > > >> </session-factory> > > > >> </hibernate-configuration>* > > > >> -- > > >> Ikai Lan > > >> Developer Programs Engineer, Google App Engine > > >> plus.ikailan.com > > > >> On Tue, Feb 14, 2012 at 9:08 AM, Paul Ford > > >> <[email protected]>wrote: > > > >>> Hey Lisa as far as I can tell Hibernate is not supported by GAE. This is > > >>> documented on the GAE Java Whitelist. > > > >>> Furthermore, JPA and JDO are supported so this should provide all the > > >>> ORM you need. > > > >>> regards > > > >>> paul > > > >>> On Tue, Feb 14, 2012 at 5:33 AM, lisandrodc <[email protected]>wrote: > > > >>>> Does someone know a simple example application GAE with > > >>>> Hibernate and Cloud SQL? > > >>>> Supposedly Cloud SQL support. > > >>>> (Forming:hibernate.cfg.xml, working with MySQL locally or Cloud SQL > > >>>> in > > >>>> Server) > > >>>> The link: > > >>>>https://developers.google.com/cloud-sql/ > > >>>> It does not mention anything with regard to Hibernate. > > >>>> Thanks and regards > > > >>>> -- > > >>>> You received this message because you are subscribed to the Google > > >>>> Groups "Google App Engine for Java" group. > > >>>> To post to this group, send email to > > >>>> [email protected]. > > >>>> To unsubscribe from this group, send email to > > >>>> [email protected]. > > >>>> For more options, visit this group at > > >>>>http://groups.google.com/group/google-appengine-java?hl=en. > > > >>> -- > > >>> Regards > > > >>> Paul > > > >>> *Paul W. Ford │ Principal* > > >>> Maven Wave Partners LLC > > >>> GTalk +1.312.884.1051 M:+1.312.953.1664 > > >>> [email protected] > > > >>> Please check out our Fusion > > >>> Blog<http://www.mavenwave.com/news-and-views-mavenwave-blog/> for > > >>> more insights > > > >>> -- > > >>> You received this message because you are subscribed to the Google > > >>> Groups "Google App Engine for Java" group. > > >>> To post to this group, send email to > > >>> [email protected]. > > >>> To unsubscribe from this group, send email to > > >>> [email protected]. > > >>> For more options, visit this group at > > >>>http://groups.google.com/group/google-appengine-java?hl=en. > > > >> -- > > >> You received this message because you are subscribed to the Google Groups > > >> "Google App Engine for Java" group. > > >> To post to this group, send email to > > >> [email protected]. > > >> To unsubscribe from this group, send email to > > >> [email protected]. > > >> For more options, visit this group at > > >>http://groups.google.com/group/google-appengine-java?hl=en. > > > > -- > > > Regards > > > > Paul > > > > *Paul W. Ford │ Principal* > > > Maven Wave Partners LLC > > > GTalk +1.312.884.1051 M:+1.312.953.1664 > > > [email protected] > > > > Please check out our Fusion > > > Blog<http://www.mavenwave.com/news-and-views-mavenwave-blog/> for > > > more insights > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Google App Engine for Java" group. > > > To post to this group, send email to > > > [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]. > > > For more options, visit this group at > > >http://groups.google.com/group/google-appengine-java?hl=en. -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
