Re: inconsistent use of newlines in script tool generated file

Hi, Thanks! You are right. This will be fixed in the next release. Regards, Thomas On Wednesday, January 9, 2013, Hüseyin Kartal wrote: > > The single LF chars occurs in > ... > create cached table zsv.anr(*LF* > g4 varchar,*LF* > key varchar,*LF* > bez varchar*LF* > ); *CR LF*

Re: H2 (as used by Eclipse EMF CDO) performance problem.

Hi Carel, I am currently investigating whether or now we want to take the EMF+CDO+H2 approach considering our highly scalable performance requirements. Did you experience similar problem with the latest version of H2? I found Stefan Winkler's slides from Eclipsecon last year on CDO Performance

Re: Reading the transaction log of a database

Have you looked at SymmetricDs, it has support for H2. It uses triggers. http://www.symmetricds.org/doc/3.2/html-single/user-guide.html#ap02-h2 On 9/01/2013 9:38 PM, Lutz wrote: I am trying to implement replication with the H2 DB. Changes to the master database are supposed to be send to a sl

Re: java.lang.NullPointerException when deleting a record

No worries. Thanks!. Not too much point in fixing an "experimental" feature when it is going to be superseded soon with the MV Store. Which if I understand correctly will by nature work in MVCC mode? Thanks, Ryan On 10/01/2013 12:29 AM, Noel Grandin wrote: Sorry, but Thomas is busy working

Re: inconsistent use of newlines in script tool generated file

The single LF chars occurs in ... create cached table zsv.anr(*LF* g4 varchar,*LF* key varchar,*LF* bez varchar*LF* ); *CR LF* .. insert into zsv.anr(g4, key, bez) values*LF* ('1', 'hr.', 'hrr'),*LF* ('0', ' ', 'null'),*LF* ('', 'ehel.', 'ehel');*CR LF* ... On Wednesday,

Re: java.lang.NullPointerException when deleting a record

Hi, I guess the "select ... for update" will internally delete the old clob first. Then when you try to access it, it is already too late. It's very similar to a known issue. I'm not sure yet what is the best solution to fix the problem. I agree it's a bug, but unfortunately I don't know yet how t

Re: java.lang.NullPointerException when deleting a record

Sorry, but Thomas is busy working on his next-gen storage engine, and I'm not interested in MVCC, so unless you feel like debugging this yourself.. :-( -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-d

Re: java.lang.NullPointerException when deleting a record

Can you confirm this? It doesn't do it without MVCC, so it would seem there is an error with MVCC and lobs with a "for update" on the select? Thanks, Ryan On 5/01/2013 7:33 AM, Ryan How wrote: Test Case public static void main(String... args) throws Exception { Class.forName(

Re: Problem opening H2

Ok, I get it, then LOG=0 is not recommended for productive system. Sorry about this, I already had problems because I used LOCK_MODE=0. But it was not clear for me that these parameters also destabilize the database. But what about UNDO_LOG, if I do not have roll_back operation in the code, is it s

Re: Problem opening H2

This is the second time in the last 3 months we've had this option abused and people reporting bugs because of it. Maybe we should disable those options unless enabled via a static boolean flag from inside the unit-test code? On 2013-01-09 16:37, Thomas Mueller wrote: Hi, > LOG=0;UNDO_LOG=0

Re: Problem opening H2

Hi, > LOG=0;UNDO_LOG=0 Well that explains why the database is corrupt. 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

Re: Problem opening H2

what does your database URL look like? On 2013-01-09 16:08, Kais Haddadin wrote: the stacktrace is attached On Wed, Jan 9, 2013 at 2:13 PM, Noel Grandin > wrote: Can you please post the entire stacktrace? On 2013-01-09 15:03, kais haddadin wrote:

Re: Problem opening H2

the stacktrace is attached On Wed, Jan 9, 2013 at 2:13 PM, Noel Grandin wrote: > Can you please post the entire stacktrace? > > > On 2013-01-09 15:03, kais haddadin wrote: > > Hello, > > I try to open the H2 database version (1.3.168) and am getting this > error: > > "Sequenz "SYSTEM_SEQUENC

Re: Reading the transaction log of a database

I am trying to implement replication with the H2 DB. Changes to the master database are supposed to be send to a slave database so it is kept up to date. At least, this is what should be happening :) I am going to read into the EventListener and Trigger and try to figure out a way to do it with

Re: Reading the transaction log of a database

Hi, Currently this is not supported. Would it be possible to use the DatabaseEventListener or the Trigger interface instead? What is your use case? Regards, Thomas On Wed, Jan 9, 2013 at 12:14 PM, Lutz wrote: > Hi there, > > I am currently experimenting with implementing a method for suppo

Re: Problem opening H2

Can you please post the entire stacktrace? On 2013-01-09 15:03, kais haddadin wrote: Hello, I try to open the H2 database version (1.3.168) and am getting this error: "Sequenz "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" nicht gefunden Sequence "SYSTEM_SEQUENCE_A5042270_9313_42F1_B5

Problem opening H2

Hello, I try to open the H2 database version (1.3.168) and am getting this error: "Sequenz "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" nicht gefunden Sequence "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" not found; SQL statement: CREATE CACHED TABLE FCM.LAGERBESTÄNDE( "

Reading the transaction log of a database

Hi there, I am currently experimenting with implementing a method for supporting replication for the H2 DB and I was wondering: Is it possible to read out the transactionlog of the database continuously? I already looked at the method in the Recover-tool that already exists but I can't seem to

Re: Adding a column to the lucene fulltext index?

Ah, that makes more sense. I have implemented this and checked it into SVN. You need to drop the index and then re-create it. Be warned that it rebuilds all of the lucene full-text indices when you drop the index for a column. (yeah, I know, not ideal, but I don't know the code that well, and