Re: [h2] H2 is not choosing best available Index

Hello, The reason I want to use idx_type is based on some articles about indexing group by. Here's one of them: http://use-the-index-luke.com/sql/sorting-grouping/indexed-group-by And it does seems to increase the performance on my experiment in H2 web console with 1 million records. Please try

Re: [h2] H2 is not choosing best available Index

Hi, I currently don't understand the problem, and I also don't understand the patch. I think I will need a test case. The test case I have so far is: private void testIndexUsage() throws Exception { Connection conn = getConnection("optimizations"); Statement stat = conn.create

Re: [h2] AUTO_RECONNECT timeout setting?

Hi, > Can someone please explain why it's longer to get the error if AUTO_RECONNECT is set to true? Well, I guess it is trying to reconnect. But why it should take so long to find out it can't, this I don't know. Could you get a few full thread dumps to find out what is happening during those 18

[h2] Question on H2 Trigger

Hi, i have created a Trigger on a specific database and it will insert data into another database once a trigger is invoked. This is working fine using java but if i were to delete the record at that database with the trigger manually, the trigger was not invoked. Is there any ways i can make it

Re: [h2] Clarification on h2.lobInDatabase deprecation

On 28/01/2014 3:41 AM, forkj...@gmail.com wrote: # Storing the content yourself on the filesystem and link the content to a path column on a database table? I do the latter in my project. But you lose any transactional consistency unless you create a complex mechanism. So I'm sure I have a fe

[h2] Clarification on h2.lobInDatabase deprecation

It looks like the the feature for storing files outside of the database is going away (i.e. h2.lobInDatabase=false). Assuming that feature goes away, if one plans to store a lot of BLOBs (several gigabytes t

Re: [h2] how to compile source

Hi, Yes, please send the patch. (I'm currently not interested to "Mavenize" H2 for multiple reasons, but let's see, maybe later) Regards, Thomas On Mon, Jan 27, 2014 at 10:21 AM, wrote: > Hi, I have no response from you ??? Are you interested by our > modifications or not ? > > Regards, > >

Re: [h2] Re: Encoding to use in the src/main/org/h2/res/_messages_*.prop files.

Hi, Fixed translations are very welcome! > What encoding should I use? The file seems to be saved in ANSI. You should use UTF-8. The file is saved in UTF-8 encoding. The Polish translation currently doesn't use any characters beyond character code 127 I guess, and UTF-8 and ANSI are the same for

Re: [h2] how to compile source

Hi, I have no response from you ??? Are you interested by our modifications or not ? Regards, JPG -- 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+

[h2] Re: Encoding to use in the src/main/org/h2/res/_messages_*.prop files.

Hi WJ, Almost unbelievably, the default encoding for properties files is ISO 8859-1. From the JavaDoc : The load(Reader) / store(Writer,