JPA2 and CloudBees

Besides its “Tomcat-as-a-Service”, the CloudBees service is also offering a hosted MySQL (5.0.51) database. This “database-as-a-service” can be used in various ways. Once you’ve created your database, you can get detailed informations about it in the management console. This console includes a few code samples on how-to configure the hosted database, e.g to be used in JSP or ColdFusion.

Of course, you can also use JPA inside of the CloudBees offer. I’ve tested it with EclipseLink and OpenJPA.

In order to use JPA with the hosted database, you need to include something like below, in your persistence.xml file:

<persistence-unit
  name="myUnit"
  transaction-type="RESOURCE_LOCAL">

<class>my.PersistentObject</class>
...

 <properties>
<!-- JPA standard properties -->
<property
   name="javax.persistence.jdbc.driver"
   value="com.cloudbees.jdbc.Driver"/>
<property
   name="javax.persistence.jdbc.url"
   value="jdbc:cloudbees://YOURSCHEMA"/>
<property
   name="javax.persistence.jdbc.user"
   value="USER"/>
<property
   name="javax.persistence.jdbc.password"
   value="PASSWORD"/>
....

That’s all you need! Now you are able to use the database!

Note: For your local development you can also access the DB via a real URL and the regular MySQL driver. The management console does show the remote connection details as well.

About these ads

Howdy!

Posted in Uncategorized
2 comments on “JPA2 and CloudBees
  1. [...] This post was mentioned on Twitter by Matthias Wessendorf and teamblog, Planet Apache. Planet Apache said: Matthias Wessendorf: JPA2 and CloudBees http://bit.ly/gevuXn [...]

  2. [...] Installer Glassfish v3 sous Ubuntu Lucid 10.04 LTS avec modjk (Fabrice Bourqui) • JPA2 and CloudBees (Matthias Wessendorf) • Updating Weld in Glassfish 3.1 (Brian Leathem) • GlassFish 3.1: [...]

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 33 other followers

%d bloggers like this: