[h2] Re: unable to write: the database is read only after system crash

2013-10-02 Thread Dieter Cailliau
Yes I'm using 2-phase-commit because I use xa-datasource (this is an xml 
element in jboss' standalone-full-ha.xml), but I never really found out how 
to configure the thing (jboss as 7.2.0.Final with h2) to perform recovery. 
I've pasted the config xml below.

Note: having recovery is also not 'a must' for me actually, so would there 
be a way to proceed from this situation, somehow skipping recovery?

Note: i'm using xa because i need to send/rollback JMS messages 
transactionally along with the db transaction.

subsystem xmlns=urn:jboss:domain:datasources:1.1
datasources
xa-datasource jndi-name=java:jboss/datasources/H2-bms-DS 
pool-name=H2-bms-DS enabled=true use-java-context=true
xa-datasource-property name=URL

jdbc:h2:${jboss.server.data.dir:/tmp}/bms;DB_CLOSE_DELAY=-1;LOCK_TIMEOUT=${com.x.lock.timeout.ms:5000}
/xa-datasource-property
driverh2/driver
security
user-namebms/user-name
/security
recovery
recover-credential
user-namebms/user-name
/recover-credential
/recovery
/xa-datasource
drivers
driver name=h2 module=com.h2database.h2

xa-datasource-classorg.h2.jdbcx.JdbcDataSource/xa-datasource-class
/driver
/drivers
/datasources
/subsystem

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.


[h2] Re: unable to write: the database is read only after system crash

2013-09-30 Thread Dieter Cailliau
I'm using h2-1.3.168 in jboss 7.2.0.Final on a Win7.

-- 
You received this message because you are subscribed to the Google Groups H2 
Database group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.