Wednesday, October 12, 2011

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.
Posted by at
Labels: ,

13 comments:

  1. libregeekOctober 13, 2011 8:42 PM

    Can you please share the source code of the sample application you developed.

    ReplyDelete
  2. Chandana NapagodaOctober 14, 2011 9:09 PM

    Sample Project code : http://code.google.com/p/cloudsql/

    ReplyDelete
  3. Saqib AliOctober 21, 2011 9:39 AM

    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.

    ReplyDelete
  4. Chandana NapagodaNovember 06, 2011 3:47 AM

    Check out my example application for Spring Hibernate on Google App Engine with Google Cloud SQL.

    New Post

    ReplyDelete
  5. AnonymousNovember 28, 2011 1:27 AM

    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..

    ReplyDelete
  6. AnonymousNovember 28, 2011 2:26 AM

    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.

    ReplyDelete
  7. Chandana NapagodaNovember 28, 2011 1:48 PM

    @Nauman Zubair

    Can you able to share your App Engine hosted Application.

    ReplyDelete
  8. AnonymousNovember 28, 2011 5:34 PM

    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..

    ReplyDelete
  9. "Smiley" KHANMay 17, 2012 3:57 PM

    Pls,Give the code of this "Sample Application with Google Cloud SQL"

    ReplyDelete
  10. AnonymousJanuary 30, 2013 5:31 AM

    Thanks for mentioning that we have to add the MySQL jar to App Engine SDK/lib/impl. Couldn't find this info anywhere else...

    ReplyDelete
  11. AnonymousJanuary 30, 2013 5:31 AM

    Thanks for mentioning that we have to add the MySQL jar to App Engine SDK/lib/impl. Couldn't find this info anywhere else...

    ReplyDelete
  12. RajFebruary 14, 2013 6:05 AM

    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).

    ReplyDelete
  13. Chandana NapagodaMarch 03, 2013 2:47 PM

    @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.

    ReplyDelete

Subscribe to: Post Comments (Atom)

View Counts

Followers