Sample Application with Google Cloud SQL

Three months ago I was able to participate in one of the Google App Engine based task management project.  However, in that project, I had to face some critical issues in searching as Google Datastore did not support many search options including LIKE search. It is known that searching is one of the essential parts of the enterprise applications.


However, Google introduced Cloud SQL last week and they approved my "Google Cloud SQL" request today (they took 5 days to approve it.:D ). Once they approved, I decided to develop a sample application with Cloud SQL. Gogole Cloud SQL database engine is MySql Version 5.1.59 and database size must be no larger than 10GB. Here I have added option to Test LIKE search. If you need more clarification, feel free to contact me.

Test Application http://securezilla.appspot.com/

PS: Added Source Code
Sample Project : http://code.google.com/p/cloudsql/ 
    Backup Link: https://github.com/cnapagoda/cloudsql


Added on 2011-10-20:

Some people have issue when developing their application because Google currently doesn't support access Google Cloud SQL from outside Google App Engine. there for your local development you need to test with local DataBase(EX: Mysql). After that you when code release to Google App engine it's work fine.

For you local development no need to change the connection URLs.Just need to pass the VM arguments . I think you are using Eclipse IDE.


Go to Run --> Run Configurations
Add the following lines into the your project VM Arguments section.


-Drdbms.server=local
-Drdbms.driver=com.mysql.jdbc.Driver
-Drdbms.url=jdbc:mysql://localhost:3306/database?user=dbuser&password=dbpass

After that add MySql JDBC driver in to your App Engine SDK/lib/impl folder. Then create DataBase and tables for according to requirement.

Comments

libregeek said…
Can you please share the source code of the sample application you developed.
October 13, 2011 8:42 PM
Chandana Napagoda said…
Sample Project code : http://code.google.com/p/cloudsql/
October 14, 2011 9:09 PM
Saqib Ali said…
oh only if Google had provided a way to connect to the Google Cloud SQL from outside of the GAE....... i could have used it in my current project :)

i hope Google allows external connections soon.
October 21, 2011 9:39 AM
Chandana Napagoda said…
Check out my example application for Spring Hibernate on Google App Engine with Google Cloud SQL.

New Post
November 06, 2011 3:47 AM
Anonymous said…
Dear Chandana!
I am doing the same thing but i am stuck here to do so.. i want to access my DB instance(created with sql prompt , google cloud sql) via android app. How can i do so please help me.
Your attentions will be highly appreciated as i want to go away this hurdle as soon as possible..
November 28, 2011 1:27 AM
Anonymous said…
I followed that example but when i click on submit button it gives an error as follows :

ERROR : Server Error
The server encountered an error and could not complete your request.
If the problem persist, please report your problem and mention this error message and the query that caused it.

and after this i clicked to report error to the GAE community but i didn't get any suitable answer from that side.
Please help me to solve this problem.
November 28, 2011 2:26 AM
Chandana Napagoda said…
@Nauman Zubair

Can you able to share your App Engine hosted Application.
November 28, 2011 1:48 PM
Anonymous said…
I am doing exactly the same thing as in Documentation please mention your email id here so that i can share it with you..
If you have some free time i wanna chat with you so that we can fix this problem via teamviewer..
November 28, 2011 5:34 PM
"Smiley" KHAN said…
Pls,Give the code of this "Sample Application with Google Cloud SQL"
May 17, 2012 3:57 PM
Anonymous said…
Thanks for mentioning that we have to add the MySQL jar to App Engine SDK/lib/impl. Couldn't find this info anywhere else...
January 30, 2013 5:31 AM
Anonymous said…
Thanks for mentioning that we have to add the MySQL jar to App Engine SDK/lib/impl. Couldn't find this info anywhere else...
January 30, 2013 5:31 AM
Raj said…
good work.. dude..

i am doing a project on cloud outsourcing.. for that i need a cloud database. like cloudsql. so, how can i get that database access permissions for my project?

please tell any solution.
i want to store files, images, text data in that database. and my front end is java(JSP).
February 14, 2013 6:05 AM
Chandana Napagoda said…
@Raja Sekhar A

First You have to create Google Cloud SQl instance using https://code.google.com/apis/console/.

Then yu can use is an MySQL Database.
March 03, 2013 2:47 PM
Post a Comment

Popular posts from this blog

XSLT - Modify Date and DateTime value

If you want to perform date and time related opertions with XSLT 'date' or 'dateTime' values, you can use 'xs:yearMonthDuration' or 'xs:dayTimeDuration' function to achieve this. You can add or reduce years, months, date, hours or even minutes through those functions.  xs:yearMonthDuration For this function input value is year month duration and it should be passed in  ISO_8601 format n- the [n] is replaced by the value for each of the date and time elements P - The duration designator(for period). nY- the number of years. nM- the number of months. ex: xs:yearMonthDuration('P1Y2M') - 1 Year and 2 Months ex:  xs:yearMonthDuration('-P1Y2M')  - Negative 1 Year and 2 Months xs:dayTimeDuration For this function input value is day time duration and it also needs to be passed in  ISO_8601 format n- the [n] is replaced by the value for each of the date and time elements P - The duration designator(for period). nD- the
Read more

Integrate With Mutual Certificate Authentication based Service

There are many ways to secure a Service/API using different Authentication mechanisms. Mutual Certificate authentication(AKA: Client Certificate Authentication) is one of the ways to secure Service or API. Recently I was trying to integrate with an API which is secured using Mutual Certificate Authentication. In this scenario, the backend service team gave me their certificate-based on PKCS#12. When integrating this backend system with WSO2 Platform, we have to use 'Multi-HTTPS transport'. With this 'Multi-HTTPS transport', it will grant great flexibility to define different SSL profiles with separate trust stores and key stores for different IPs or hosts. This custom SSL profile can be implemented for Client to Synapse Runtime(Client --> ESB) or Synapse Runtime to Backend(ESB --> Backend). If it is Client to ESB, then you have to define custom SSL Profiles in the transportReceiver section. In my use-case, it was for ESB to Backend. So I had to add custom SSL prof
Read more

Yield Price Sri Lanka - Android Application

Image
" Yield Price Sri Lanka " is an Android based application which helps users to check Market Price Information using their mobile devices. This application concept is based on person X( will update his name after approvals) and I did slight modifications on the application to support in a low cost infrastructure. Using this " Yield Price Sri Lanka " application, you can check prices of various goods instantly, without going to the market. I am updating price information in Daily & Weekly basis according to the Colombo Manning Market prices. Initial application was developed to support English language only. With current latest version we are supporting English, Tamil and Sinhalese languages. This application will update price information in real time and when describing the application's back-end(server) architecture, it has developed to serve JSON based output with many concurrent requests without blocking any request. Within the mobile Application wh
Read more