Re: [h2] H2 1.4.181 system column _ROWID_ slow with MVSTORE

2014-09-02 Thread Thomas Mueller
Hi, Yes, this is possible. It looks like there is no special test case for this feature, that's why it's not yet implemented for the MVStore. I will fix that. Regards, Thomas On Tuesday, September 2, 2014, Nicolas Fortin (OrbisGIS) < nico.de...@gmail.com> wrote: > Hi, > > Using H2 1.4.181 (20

Re: [h2] H2 db getting corrupt on mac

2014-09-02 Thread Thomas Mueller
Hi, If you copy the file while the database is open, then the backup can be corrupt in some cases (it's not so easy to reproduce it). Online backup is supported, but you have to use the "backup" SQL statement (see the documentation for details). In theory the corruption can have other reasons. Wi

Re: [h2] H2 db getting corrupt on mac

2014-09-02 Thread Ryan How
It isn't safe to backup the file that way. You need to use the inbuilt backup command if the database is in use. http://h2database.com/html/grammar.html#backup http://h2database.com/javadoc/org/h2/tools/Backup.html On 3/09/2014 6:27 AM, Kam wrote: I don't know what's causing it. We have a

[h2] H2 db getting corrupt on mac

2014-09-02 Thread Kam
I don't know what's causing it. We have a feature that backs up the H2 DB file and zips it via java. the DB is in use when we back it up (all it does is copy the h2 file) When we tried to use it, it's corrupted. This is the stack trace when I try to open it ZipOutputStream append = new ZipOutput

Re: [h2] Does H2 support Postgresql HStore data type?

2014-09-02 Thread Noel Grandin
No, but if you feel like writing the necessary support :-) -- 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

[h2] Re: java.net.UnknownHostException on OSX and Java 7

2014-09-02 Thread Jonathan Shuali
Thank you Oliver so much. I had this problem and could not figure out why. Jonathan. On Friday, December 21, 2012 6:04:36 AM UTC-5, Oliver Schrenk wrote: > > Hi, > > Just and FYI for all users on OSX using Java 7. I was trying to start a > TCP Server from within an application using > > Server.

[h2] H2 1.4.181 system column _ROWID_ slow with MVSTORE

2014-09-02 Thread Nicolas Fortin (OrbisGIS)
Hi, Using H2 1.4.181 (2014-08-06): Creating a huge table (118mb): create table mytable as select REPEAT(hash('SHA256',STRINGTOUTF8((rand()+X)::varchar),1),2) field from SYSTEM_RANGE(1, 40); Then request only one row using _ROWID_ select * from MYTABLE where _ROWID_ = 1 It took 437 ms