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#4197001

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4197001
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to