Re: [h2] Recovery tool does not handle LOBs correctly (explanation and fix is proposed)

Hi, It would be great if version 1.4.194 could be released in order to integrate the patch. (We have corrupted customer databases and cannot use the latest official h2 jar to recover these databases) Thanks -- You received this message because you are subscribed to the Google Groups "H2 Data

Re: [h2] java.sql.Connection.commit() freezes after LOB modification with EXCLUSIVE connection

Thanks to you. That was very reactive. :) Le vendredi 25 octobre 2013 10:28:25 UTC+2, Noel Grandin a écrit : > > Thanks for the test case. > > Fixed in revision 5268 > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this gr

[h2] java.sql.Connection.commit() freezes after LOB modification with EXCLUSIVE connection

Hi, I just entered a new issue 518. It would be great if it could be corrected on a version to come. I'm fully prepared to help on its resolution if needed. Thanks -- You received this message because you are subscribed to the Google G

Maven central publication

Hi there, Thanks for this new version. Will it be published on maven central this time ? Regards, Laurent R Le vendredi 30 novembre 2012 07:45:35 UTC+1, Thomas Mueller a écrit : > > *Hello, > > A new version of H2 is available at http://www.h2database.com > (you may have to click 'Refresh'). >

Re: H2 Database Engine: New version 1.3.170 available

Hi there, Thanks for this new version. Will it be published on maven central this time ? Regards, Laurent R -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-

Re: [AUTO_SERVER] Connection takes 2 minutes

Thank you Noel We will investigate this and check if all names in the proxy exclusion list (or even the proxy name itself) are OK on the system with the issue. Regards Laurent -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discus

Re: [AUTO_SERVER] Connection takes 2 minutes

Hi, We had to set the system java property *java.net.useSystemProxies* to *false *to get rid of this 2 minutes connection delay in AUTO_SERVER mode. However, I don't understand why this setting led to this delay. After waiting 2 minutes, the connection was OK. Moreover, our customer gave his

Re: [AUTO_SERVER] Connection takes 2 minutes

Hi, I joined the results of jstack (stack.txt) and testNetwork (network.txt) from the system. I don't feel able to conclude anything from this... I'll ask our customer to do one more test because I wonder if the cause could not be the definition of proxies on the system (by default, our applica

Re: [AUTO_SERVER] Connection takes 2 minutes

OK. Found the code of testNetwork in Build.java. I will package it in a standalone jar in order to help our customer executing it. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.co

Re: [AUTO_SERVER] Connection takes 2 minutes

Thanks a lot for your answer Thomas. I'll do my best to get the information you mention but I don't have access to the system encountering the problem and I don't know if a JDK can easily be installed on it. Is there a way to execute something equivalent to "build testNetwork" without the whole

[AUTO_SERVER] Connection takes 2 minutes

We're using H2 to embed a database with our product for some months now and we really appreciate the functionalities of H2. We're using the auto-mixed (AUTO_SERVER) mode in order to allow concurrent access from several processes without imposing our customers to set up a H2 server. This works fi

Re: Corrupted database with serialized lock mode on a network database

Hi, At work, when using a NTFS shared folder instead of a netware shared folder, the tests run fine in SERIALIZED mode. However, we will certainly move to AUTO_SERVER mode instead of SERIALIZED file_lockbecause the former sho

Re: Concurrent access with FILE_LOCK=SERIALIZED

Hi, We didn't manage to reproduce with some simple code yet. I think we'll give up this search since we'll focus our attention on the mixed modenow. Regards, Laurent -- You received this message because you are subscribed t

Re: FILE_LOCK=SERIALIZED versus AUTO_SERVER=TRUE

So we tested what happens in auto mixed mode when the server shutdowns. It's finally the same logical behavior as with a standard server : the client whose transaction is not closed receives a dedicated "session closed" exception at the next statement : Exception in thread "main" org.h2.jdbc.Jdb

FILE_LOCK=SERIALIZED versus AUTO_SERVER=TRUE

Since we're experiencingseveral problemswith the SERIALIZED lock mode, we look at alternatives and the AUTO_SERVER mode strikes back. The* *nice explanat

Re: h2.ModifyOnWrite and TestFileLockSerialized

The previous test was done on Windows 7 (on a recent workstation). The same test on MacOsX is faster : testTwoWriters is still much slower with h2.ModifyOnWrite set to true than with h2.ModifyOnWrite set to false but it ends after a few minutes (on a MacPro 2006 with MacOSX 10.6). -- You recei

Re: Corrupted database with serialized lock mode on a network database

Thank you for your help Thomas I don't encounter any problems with my home network (my NAS has NFS) but the errors appear on our network at work. It is *Novell Netware* but I don't know much more (I should have more information soon). I tried different values for RECONNECT_CHECK_DELAY. It chang

Re: Corrupted database with serialized lock mode on a network database

I realized that some of my first description is wrong. 1. The WRITE_DELAY=0 doesn't seem to change anything. 2. The testBigDatabase with cache enabled works most of the time on our networked database. It is when the cache is deactivated that the test fails as shown in previous messag

Re: Corrupted database with serialized lock mode on a network database

No answer. Does it mean that nobody reproduces ? I indeed tested on a completely different configuration (MacOSX) without reproducing any error but at work, on our Novell network, the unit tests never pass. I typically get the following output : 00:11:35 23:11:35.266 org.h2.test.unit.TestFileLoc

Re: H2 in Servermode Url,File,Port,Parameters Question

Ok, help me out. I want a server running a database named "prod" > running on port which uses DEFAULT_CONNECTION. The File > containing the data should be in C:\H2\Databases\ > > For now I can start a server like this: > java -cp h2-1.3.162.jar org.h2.tools.Server -web -tcp -tcpPort - >

Re: H2 in Servermode Url,File,Port,Parameters Question

Have a look at http://www.h2database.com/html/tutorial.html#using_server. The org.h2.tools.Server class is in charge of exposing the server. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.

Concurrent access with FILE_LOCK=SERIALIZED

Hello, We get the following exception when stressing a database from two different processes with FILE_LOCK=SERIALIZED Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not get next sequence value at org.hibernate

h2.ModifyOnWrite and TestFileLockSerialized

Hello, When I run the H2 unit tests TestFileLockSerialized with property h2.ModifyOnWrite set to true, the testTwoWriters test takes quite a lot of time (I killed it after about two hours). I'm wondering if there might not be an interlock. The main thread is hung on the "drop table test" statem

Corrupted database with serialized lock mode on a network database

Hello there, We're facing troubles (exceptions during treatment, corrupted databases, ...) when using the SERIALIZED file_lock mode on databases that reside on a network shared folder. The issue happens randomly. We excluded the concurrent access reason because we got some corrupted database

Re : Re: Re : blocked with issue 311

Hi, As I commented it in the issue, I tested your solution in my application and it works fine. I thank you very much for this. Sincerely yours, Laurent -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit

Re : blocked with issue 311

Hello, I didn't get any feedback to my code proposition. Did I do something wrong ? Maybe my request isn't clear enough ? If it is the case, please tell me. I would really be grateful if the patch could be committed or if I could get any explanation telling me why it can't be (or just get an ans

Re : blocked with issue 311

Hi again, I began to modify some H2 code in order to make my use case work. The attached file is a patch file for org.h2.expression.SequenceValue. It seems to solve my problem fine but I don't know enough the architecture of the H2 engine to be sure it won't fail in some other situations. I ran

blocked with issue 311

Hello, I am stuck with issue 311 (cf http://code.google.com/p/h2database/issues/detail?id=311#c4). Does anyone know a way to get around it when you don't access the database directly through JDBC but with hibernate instead ? Any help will be greatly appreciated. Regards Laurent R -- You recei