Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question

gigaspaces hibernate dialect ?

Hi all,

I was looking at gigaspaces and I wonder where to find the jdbc driver com.j_spaces.jdbc.driver.GDriver as shown at the end of the page http://www.gigaspaces.com/wiki/displa... . also is there something that could be used as a hibernate dialect for gigaspaces?

As I would like that an existing application using hibernate gets the power of gigaspaces and that by not changing its code. Does it make sens and would the cache replacement have a similar effect if there is no such dialects?

And I wonder, if there is no such dialects, what is the reason not to have it?

Edited by: Daniel Gradecak on Jul 24, 2009 12:25 PM

{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=3189]{quote}

asked 2009-07-24 12:22:14 -0500

dgradecak's avatar

updated 2013-08-08 09:52:00 -0500

jaissefsfex's avatar
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

The main reason is that GigaSpaces JDBC driver does not support all SQL 92.

It would be simpler to change application data access layer to use the native object based data grid API (aka openspaces GigaSpace interface) rather than dealing with the relevant hibernate mapping.

Remember the native data grid api support SQL and POJO to the transition would be straight forward. More than this - it will give u much more capabilities such as moving some of the business logic to run within the data grid in parallel manner. Something that will give your application better performance and scalability (aka Task Executors).

The bottom line is simple: instead is being database centric application you will get the freedom to have in memory data grid that will be the application system of record while data will be persist into the database in async manner (aka Mirror service). This will make sure you will have real de-coupling between the application and the database. The actual database access will be done via Hibernate. This will allow you to enjoy both worlds.

Make sense?


answered 2009-07-24 13:26:35 -0500

shay hassidim's avatar
edit flag offensive delete link more


sure it makes sense. However the application is a thid party app (Alfresco CMS) with its own datalayer, where the main component is hibernate. Therefore it is not that straight forward and would take more energy in maintaining that from release to release than reusing the existing ORM configuration and simply configure the JDBC settings for hibernate.

Doesn't this make sense either? what is the difference in being database centric or space centreic, if the underlying system is a data grid and is doing the async persistence?

I also asked that question to your comment on my blog a while ago ... http://gradecak.blogspot.com/2009/01/...

Edited by: Daniel Gradecak on Jul 24, 2009 4:30 PM

dgradecak's avatar dgradecak  ( 2009-07-24 16:28:59 -0500 )edit

Let's take this offline - please contact me via: shay at gigaspaces.com


shay hassidim's avatar shay hassidim  ( 2009-07-24 17:02:00 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2009-07-24 12:22:14 -0500

Seen: 105 times

Last updated: Jul 24 '09