Re: Recovery failed with 1.3.159

2011-08-16 Thread Thomas Mueller
Hi, There were problems with this LOB table in previous versions of H2. Could you check which version of H2 was used to create the database? What is the value of the CREATE_BUILD line in the script? Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2

Re: org.h2.jdbc.JdbcPreparedStatement.setTimestamp() not handling utc dates correctly?

2011-08-16 Thread Jamie Clark
Sorry for the delay in getting back to - was pulled in another direction for a while. Of course I am not using ValueTimestamp directly, was just trying to cut to the chase, but clearly did not give you enough context to work with. Here is the problem I am currently encountering, and a very simple

Re: Small bug (?) with WITH RECURSIVE query feature

2011-08-16 Thread xonix
On 16 авг, 22:31, Thomas Mueller wrote: > Hi, > > > Please note heading N that should be N1. > Beg pardon for reporting this. This is a bug of Execute Query client program. In H2 browser client it works correctly. -- You received this message because you are subscribed to the Google Groups "H

AW: backup

2011-08-16 Thread Peter Dahm
Hi, do I understand it right that "backupto" and "script" are two completely different ways to backup the database ? Does the file location for the runscript (to restore the script result) has to be placed on the server or on the client side ? Wich kind of backup is the best and safest way to do

Re: backup

2011-08-16 Thread Thomas Mueller
Hi, 'Script' returns a result set, so that would be a solution as well. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send emai

AW: backup

2011-08-16 Thread Peter Dahm
I found the solution for my problem: SELECT FILE_READ('filename') MYBACKUP; Peter Von: h2-database@googlegroups.com [mailto:h2-database@googlegroups.com] Im Auftrag von Peter Dahm Gesendet: Dienstag, 16. August 2011 17:07 An: h2-database@googlegroups.com Betreff: backup

Re: Small bug (?) with WITH RECURSIVE query feature

2011-08-16 Thread Thomas Mueller
Hi, > Please note heading N that should be N1. If you mean 'column label' with 'heading', then it is already N1. If you mean 'column name', then it is N, as the name of the column is N. This is not a bug, see the FAQ. > Feature not supported: "VARCHAR +" Yes, this is a known and documented limi

backup

2011-08-16 Thread Peter Dahm
Hi, is there any way to transfer a H2 backup file via sql protocol to the client which started it ? The client triggers the backup via sql command 'backup to '" + pDestination + "'"' Peter -- You received this message because you are subscribed to the Google Groups "H2 Database" g

Optimize joins ?

2011-08-16 Thread Rinse Lemstra
In our application we have defined skeleton query's where we add/ replace some clauses when the query is executed. Example: Select [fields] from MasterTable left join detail1 as Stem1 on MasterTable.id1 = Stem1.id left join detail2 as Stem2 on MasterTable.id2 = Stem2.id left join detail

Re: Recovery failed with 1.3.159

2011-08-16 Thread Uli
Although the error was thrown during recovery the database seems to be well recovered. I don't miss any tables. I don't miss any data and/or LOBs. Strange... I can provide the recovery script or parts of the recovery script if necessary. Uli -- You received this message because you are subscri

Recovery failed with 1.3.159

2011-08-16 Thread Uli
I started testing the 1.3.159 release of H2. After one day (using MULTI_THREADED=TRUE) the db crashed. I already reported that failure for older releases of H2 but I was not able to reproduce it in a simple test case up to now. So I tried to recover the database using the recover tool. This worked