Re: Using AUTO_SERVER=TRUE

2009-04-05 Thread Thomas Mueller
Hi, > I still have to > think (guess) that remote connection is not possible in auto_server=true > mode since in your last sentence is says that the process needs to have > access to the database file, which is not the case from a remote network. If you use file sharing (any kind, for example NF

Re: JdbcConnectionPool

2009-04-05 Thread Thomas Mueller
Hi, > I always commit/rollback transactions, but adding autoCommit=true > before the connection close did the trick. All of the tests now pass > without any locking problems. I'm sure now it's a bug in the connection pool class, I will fix it in the next release. > I have a utility Jdbc.closeSa

Re: NIO storage

2009-04-05 Thread Thomas Mueller
Hi, > There is a problem though: I could not connect to a previous database > created with jdbc:h2:..  using jdbc:h2:nioMapped:... Is it normal? Is > so, do you think that a future version will take care to make the > database compatible? No, it's not normal. Is there an exception? Could you pos

Re: JdbcConnectionPool

2009-04-05 Thread Stephen Haberman
> > I always commit/rollback transactions, but adding autoCommit=true > > before the connection close did the trick. All of the tests now pass > > without any locking problems. > > I'm sure now it's a bug in the connection pool class, I will fix it in > the next release. Cool, thanks. > > I ha

Re: test database setup/flushing

2009-04-05 Thread Stephen Haberman
> 1) Re-playing the 10+ Rails-style migrations that issue CREATE TABLE >commands to create foo's schema. Doing this once at the start takes >~1/4th of the test runtime. Applying 10 migrations is not a big deal right now, but on my last project, we had ~1,200 after a few years of being in

Problem with SELECT ... ORDER BY no data!

2009-04-05 Thread fed
Hi, i have a strange problem with H2 (Version 1.1.110), i have this table: create table dipendenti_stampa( id identity not null primary key, id_dipendente bigint not null, nome longvarchar not null, cognome longvarchar not null, matricola varchar(10) not null, badge varchar(10) not null, profil

Re: Problem with SELECT ... ORDER BY no data!

2009-04-05 Thread Thomas Mueller
Hi, Could you send me the content of the table as well, and the index definitions? Probably the simples way is to run SCRIPT in the H2 Console and then send the result set. You can send it to the group or to the support address 'db support at h2database dot com'. Or paste it to http://www.h2datab