Google Cloud SQL with Struts, Spring and Hibernate
With Google App engine SDK 1.5.5, Google have introduced Google Cloud SQL for GAE (Currently we can't connect any other external application with Google Cloud SQL. This can be only with Google App Engine Apps).
It's faster than connecting with Amazon RDS and other Cloud based Data solutions. No need to worry about load balancing as well. Cloud SQL supports 5 QPS read/write rate, so as long as you don't go over that, you can use cloud SQL. If you are going over this read/write rate limit, datastore might become a much more effective approach to you.If you are storing large blobs data(images, attchments and sound files, it's better storing them in the datastore or blobstore.
When Google App Engine became populer in late 2009 many people asked about Hibernate support. But with their datasore people were unable to develop Hibernate support applications with GAE. But with Google Cloud SQL developers can use Hibernate supported applications as well.
Last week I shared my first application which was developed with Google Cloud SQL. It was only a JSP and Servlet based web application. Afterwards I mainly focused on developing a Struts, Spring & Hibernate based application and deploying it to Google App Engine where the data source is Cloud SQL.
In Last weekend I got a time to focus on this idea. So finally I have deployed my Struts, Spring and Hibernate based application in to GAE and it's data source( Database) is Google Cloud SQL. If you are migrating your existing Spring Hibernate based application in to GAE and Cloud SQL, there is not much to do.
Only need to change data source and driver name. If you need more clarification, feel free to contact me.
Try out my application http://mycloudsql.appspot.com
Source Code(CloudSQLSample2) : http://code.google.com/p/cloudsql/
Backup Link : https://github.com/cnapagoda/cloudsql
My Previous Post: http://cnapagoda.blogspot.com/2011/10/sample-application-with-google-cloud.html
Cloud SQL Doc: https://code.google.com/apis/sql/
Google App Engine and Cloud SQL will be revolutions of Cloud Computing. (updated 01-11-2011)
It's faster than connecting with Amazon RDS and other Cloud based Data solutions. No need to worry about load balancing as well. Cloud SQL supports 5 QPS read/write rate, so as long as you don't go over that, you can use cloud SQL. If you are going over this read/write rate limit, datastore might become a much more effective approach to you.If you are storing large blobs data(images, attchments and sound files, it's better storing them in the datastore or blobstore.
When Google App Engine became populer in late 2009 many people asked about Hibernate support. But with their datasore people were unable to develop Hibernate support applications with GAE. But with Google Cloud SQL developers can use Hibernate supported applications as well.
Last week I shared my first application which was developed with Google Cloud SQL. It was only a JSP and Servlet based web application. Afterwards I mainly focused on developing a Struts, Spring & Hibernate based application and deploying it to Google App Engine where the data source is Cloud SQL.
In Last weekend I got a time to focus on this idea. So finally I have deployed my Struts, Spring and Hibernate based application in to GAE and it's data source( Database) is Google Cloud SQL. If you are migrating your existing Spring Hibernate based application in to GAE and Cloud SQL, there is not much to do.
Only need to change data source and driver name. If you need more clarification, feel free to contact me.
Try out my application http://mycloudsql.appspot.com
Source Code(CloudSQLSample2) : http://code.google.com/p/cloudsql/
Backup Link : https://github.com/cnapagoda/cloudsql
My Previous Post: http://cnapagoda.blogspot.com/2011/10/sample-application-with-google-cloud.html
Cloud SQL Doc: https://code.google.com/apis/sql/
Google App Engine and Cloud SQL will be revolutions of Cloud Computing. (updated 01-11-2011)
Comments
Searching the web for fresh examples!
Suppose you are the first! :)
Can u add your's spring & hibernate source code to google.code trunk?
Thx
Searching web for fresh cloud sql examples :) suppose u are the first!
Can u please commit your spring&hibernate source code to google.code trunk?
Thx
Can you help me?
Is it possible for you to post you pom.xml or in any other way specify which dependencies you use?
Best regards
I will fixed it very soon(I have very limited internet access now)
But Google App Engine only support JPA 1.0 specification. That why you got that "such method error".
For solve this issue used "Spring ORM Hibernate support"
If you using Hibernate JPA support, Please look at my previous comment also.
I've my final project developed in GAE so please help me out
All source code available in Google Project http://code.google.com/p/cloudsql/
It sticks in all the appengine jars which I assume I do not need.
Please help.
Thanks.
If it's not a GWT based project, no need to follow GWT enable step. you can skip it.
Is it a Web Project or Maven project?
So my mistake.
I did need to make two changes to your code base.
1) add the jar appengine-api-1.0-sdk-1.5.5.jar for the AppEngineDriver class
2) In appengine-web.xml, uncomment the line:
true
Thx for your post though. Great help.