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

Hi, Nice thank you ! We will give you more feedback later about the beta version of h2. Regards, Nicolas Fortin Atelier SIG, IRSTV FR CNRS 2488 http://github.com/nicolas-f Le mercredi 3 septembre 2014 07:44:58 UTC+2, Thomas Mueller a écrit : Hi, Yes, this is possible. It looks like there

Re: [h2] Roadmap for clustering support

On Tue, Sep 2, 2014 at 8:50 AM, cowwoc cow...@bbs.darktech.org wrote: I wasn't looking for a fixed timeline so much as a commitment to make this the next priority after MVCC support. I think it's unlikely that we can commit to that given the list of worthwhile features to work on (lots) and

[h2] Offset reserved word

It looks like offset is a reserved word in version 1.4.181, where it wasn't in 1.3.176. In particular, you can't create a table with a column called offset unless you quote it. Offset is not currently listed as a reserved word here:

[h2] Support for BigDecimal extensions

Hi, With revision 4028 the system property h2.allowBigDecimalExtensions has been removed without providing any alternative for BigDecimal subclasses. Can you merge the following patch: Index: h2/src/main/org/h2/value/ValueDecimal.java

Re: [h2] Offset reserved word

We added support for the OFFSET keyword in the SELECT statement, see here: http://h2database.com/html/grammar.html#select You can work around this by quoting your column name. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from

Re: [h2] Offset reserved word

So the website needs an update then, here: http://www.h2database.com/html/advanced.html?highlight=reservedsearch=reserved#firstFound Paul On Wed, Sep 3, 2014 at 4:02 PM, Noel Grandin noelgran...@gmail.com wrote: We added support for the OFFSET keyword in the SELECT statement, see here:

Re: [h2] Offset reserved word

Oh yes, I see what you mean. Thanks for reporting this, the website should update in a day or so. -- 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

Re: [h2] H2 db getting corrupt on mac

CREATE_BUILD | 173 (h2-1.3.173.jar) Using a ConnectionPool. We are using the BACKUP nativeH2 Query command. We're not using 'MULTI_THREADED' property either so everything defaultCIPHER=AES;TRACE_LEVEL_SYSTEM_OUT=0;ALLOW_LITERALS=NUMBERS On Tuesday, September 2, 2014 10:42:05 PM UTC-7,

Re: [h2] Support for BigDecimal extensions

Hi, Could you tell me more about your use case? Why do you want to use a subclass of BigDecimal, and why can't you use the default BigDecimal? Regards, Thomas On Wednesday, September 3, 2014, Andrea Panattoni panattoni.and...@gmail.com wrote: Hi, With revision 4028 the system property

Re: [h2] Offset reserved word

Hi, You are right, this is not well documented yet, I will fix that. The reason for the change is added support for select ... fetch first 1 row only in the regular mode. In version 1.3.x, this was only supported in the DB2, Derby, and PostgreSQL mode. Actually this also applies to fetch. At

Re: [h2] H2 db getting corrupt on mac

Here's the code: String sqlStatement = BACKUP TO ?; try (Connection connection = getConnection()) { try (PreparedStatement preparedStatement = connection.prepareStatement(sqlStatement)) { preparedStatement.setString(1, fileName);

Re: [h2] Offset reserved word

Hi, I see Noel already replied, sorry for sending (at least partially) the same info. The reason is that I sometimes prepare send mails offline, which are then sent later on... so I didn't see Noels email. Regards, Thomas On Wednesday, September 3, 2014, Thomas Mueller

Re: [h2] H2 db getting corrupt on mac

I have an application that uses BACKUP to copy the database to tablets for offline use. It fails and produces a corrupt database about once a year. It probably does 3000 or so copies a year. But like you, I'm not sure if it is in the backup code or the copy code and I can't reproduce it in a