The drop is always movingYou know that saying about standing on the shoulders of giants? Drupal is standing on a huge pile of midgetsAll content management systems suck, Drupal just happens to suck less.Popular open source software is more secure than unpopular open source software, because insecure software becomes unpopular fast. [That doesn't happen for proprietary software.]Drupal makes sandwiches happen.There is a module for that

Drupal and Java (we want to be friends with Enterprise, right?)

Submitted by nk on Mon, 2010-08-16 23:57

Drupal 7 might work with Java databases. Eventually, we might even be able to run Drupal 7 on Google App Engine.
Yesterday I was writing a patch for better support of the ANSI SQL MERGE command in Drupal and stumbled upon HyperSQL -- a Java database -- which is supposedly the most ANSI SQL compatible DB. Then I tried to find out how we could use it (there are only JDBC drivers) and I have found that Quercus which is known to run Drupal, now uses PDO to expose JDBC drivers. Great, Drupal 7 database layer is built on PDO. Furthermore, I have found a database called H2 -- another Java database -- which says it can pretend to be PostgreSQL. While previous Drupals pretend to support PostgreSQL, with Drupal 7 it's serious. So what we need is someone to run all core tests in Quercus for Drupal 7 first, maybe with MySQL just to verify it's working well. Then comes the fun: connect to H2 using the PostgreSQL driver. If it works, awesome. If not, then check whether the same test fails with PostgreSQL. If this does not work out, then try writing a DBTNG writer on top of the PDO exposed JDBC drivers to either HyperSQL or H2 or both. Finally, deploy on GAE. Who's interested? I am willing to help in writing a DBTNG driver.

Edit: it seems that for GAE we want jiql not H2 / HyperSQL but that changes little in the general approach.

Commenting on this Story is closed.

Submitted by VasanthKaje on Mon, 2010-09-13 06:30.

I am trying hard to get drupal 6.x working on appengine using quercus and jiql, but currently failing due to db errors.

Even the sample php page with mysql statements is giving trouble since it is not handling db statements properly. I am afraid the last chance I am left with is to change the db statenemts in drupal to JPA.

However, after seeing your blog I am interested to try out what you have suggested.

Any suggestions are welcome at vasantha{dot}keshava{at}gmail{dot}com

Submitted by jack116 on Tue, 2010-10-12 11:21.

Thank you so much for sharing your opinion.Industrial Flooring

Submitted by chanel (not verified) on Thu, 2010-09-16 08:19.

I like this article very much. Thanks for your share!

Submitted by 640-802 (not verified) on Tue, 2010-10-26 03:55.

yes,i agree with you.I have bookmarked it.