Re: Dropbox and H2

2013-05-09 Thread Noel Grandin
For starters, if two different machines try and update the same database file at the same time, something is going to go wrong. The sync process will not know how to merge the files and something will get lost. On 2013-05-08 23:42, JohanBerg wrote: Hi! I wonder if anyone has experience with

Re: java-level deadlock

2013-05-09 Thread Noel Grandin
Thanks, I can reproduce this now. It's going to take me a while to work out a fix though. On 2013-05-09 06:01, Ainimyoung wrote: Hi Noel, We found that the deadlock can be duplicated with MULTI_THREADED=TRUE much more easily. The following three statements got no response from H2 while we

Connecting to a remote H2 PgServer (Postgres) mode doesn't work, but to a remote TcpServer does work and a local PG Server also works, why?

2013-05-09 Thread hammpaul
Hi, I've been able to set up a TcpServer and connect to it remotely (when I say remotely, I still mean on the same machine, but using tcp://localhost:port etc from a different thread) no problem at all. Where I have difficulty is connecting to a PgServer remotely. I can connect to it locally

Re: Connecting to a remote H2 PgServer (Postgres) mode doesn't work, but to a remote TcpServer does work and a local PG Server also works, why?

2013-05-09 Thread Thomas Mueller
Hi, What problem do you want to solve by using the PgServer? The PgServer is not needed if you have Java on the client side. If you have Java on the client side, just use the TcpServer and (database URL jdbc:h2:tcp://localhost/~/test). If you really, really want to connect to the PgServer using

H2 Database Recovery

2013-05-09 Thread soumya sengupta
I have got a SpringMVC application which runs on Apache Tomcat and uses H2 database. The infrastructure contains two application servers (lets name them A B) running their own Tomcat Servers. I also have a H2 database clustering in place. On one system (A) I ran the following command java

Re: H2 Database Recovery

2013-05-09 Thread Thomas Mueller
Hi, You have posted the same question at http://stackoverflow.com/questions/16464936/h2-database-cluster-recovery See my answer there. Regards, Thomas On Thu, May 9, 2013 at 5:05 PM, soumya sengupta maverick.sou...@gmail.comwrote: I have got a SpringMVC application which runs on Apache

Re: Dropbox and H2

2013-05-09 Thread JohanBerg
Thanks for the replies! The possibility of file-conflicts is a problem for dropbox, not for H2, I think. If a file is changed from two computers at a time, dropbox will catch this, and H2 will still use the local copies. Or? I'm more worried if the database-files would be corrupted if for

Re: Dropbox and H2

2013-05-09 Thread Ryan How
I'm not sure how dropbox handles open files, but regarding multiple files h2 should be fine as everything is in 1 file. If you have separate lobs or fulltext index that might be a problem. You could regenerate full text index, but if lobs are out of sync I don't know how it would handle it. So

[no subject]

2013-05-09 Thread RJ
Hi, I am moving an H2 based project to Android, and have found that the DB is working fine. However, I have a need to connect the database to an Adapter, which means that I need a Cursor. So, I was looking again at the H2 to Android database port, and found Javadoc and source for org.h2.android