jOOQ and Google Cloud SQL Example


This is all too simple. Here’s how you can create an easy jOOQ / Google Cloud SQL integration example:

  1. Sign up with Google App Engine
  2. Sign up with Google Cloud SQL
  3. Create a Google App Engine project (preferably with Eclipse)
  4. Add jOOQ to your project
  5. Add your generated schema to your project
  6. Done

Google Cloud SQL is actually a MySQL database, which you can also install locally on your machine for development purposes. For your jOOQ integration, this means that you will set up the code generation and execution just as if you were using a plain MySQL database. Simple, huh?

See a simple example in action, here:
http://jooq-test.appspot.com/jooq-test

Check out the source code here (libs not included):
https://github.com/lukaseder/jOOQ/blob/master/jOOQ-google-cloud-sql/src/org/jooq/test/JOOQTest.java

And some instructions about Google Cloud SQL:
https://code.google.com/apis/sql/docs/developers_guide_java.html

Tags: , , , , ,

3 responses to “jOOQ and Google Cloud SQL Example”

  1. Murray Cumming says :

    Thanks, bu that github link is broken. Where is that example code now?

    • lukaseder says :

      As Google Cloud SQL is no longer available for free (even for developers), I’m no longer maintaining this example. In principle, it’s just a regular MySQL integration, though…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,616 other followers

%d bloggers like this: