[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

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

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 examp

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 wrote: > I have got a SpringMVC application which runs on Apache Tomcat and uses H2 > database

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: 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 a

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: 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 w