H2 is cooooooooooool..... it has an oracle and postgress compatible mode.... If you use
it's own H2 driver, but point to a Oracle dialect and state in the connect string the
mode is oracle, like:
| <!-- hibernate dialect -->
|
| <property
name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
|
|
| <!-- JDBC connection properties (begin) -->
| <property
name="hibernate.connection.driver_class">org.h2.Driver</property>
| <property
name="hibernate.connection.url">jdbc:h2:~/jbpm;MVCC=TRUE;MODE=Oracle
| </property>
| <property
name="hibernate.connection.username">sa</property>
| <property name="hibernate.connection.password"></property>
| <!-- JDBC connection properties (end) -->
|
|
I get a StaleObjectException..... now is that cool or what.... and even better... it has
PostgreSQL, mysql, mssql, derby, mysql, hsqldb compatible modes. PostgreSQL also gives me
a SOE!!! wow....
It does not support the dialects fully, but a real large part.... nice....
No more HSQLDB for me...
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4197001#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...