HI


On 2013-08-22 19:45, Daniel Stone wrote:

My connection URL is essentially this: "jdbc:h2:tcp://server1:9092,server2:9092/./folder/dbName"

OK, so you're not exploring the weirder options, which reduces the problem space considerably.


Please note that 2 applications are accessing the cluster. I have now started to look at the H2 source code and from what I can see our system is experiencing transient problems when running updates on server1 which then results in the updates only making it to server2. I then think that another connection (as we use a pool) attempts to read the data from server1 but it doesn't exist. It looks like the cluster list is held per connection, is this correct?

Yes, your analysis looks pretty correct.
Yes, I suspect that transient failures on one server would cause data out of sync issues.

Regards, Noel.

--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to