Re: [h2] some data size increase tests

Hi, Did you try with the latest version of H2 (1.4.x)? Please note you will need to compact the database using shutdown defrag after you finished. And apppend ;compress=true to the database URL, as Noel wrote. Regards, Thomas On Saturday, June 21, 2014, Noel Grandin noelgran...@gmail.com

Re: [h2] h2 console usability

Hi, It doesn't do that for me. What version of H2, and which browser do you use? Regards, Thomas On Saturday, June 21, 2014, Silvio sbier...@jambo-software.com wrote: My number one irrittion whith the console is that it resets the database path to the pointless default whenever Test

Re: [h2] How do you do a point query with a TIMESTAMP ? Cannot find anything senerio that works.

Hi, How do you format the output (Results: name=...)? I guess you don't print the nanoseconds part. Yes, you can't use SimpleDateFormat as it doesn't support nanoseconds, but toString() and cast(.. as varchar) should work, see below. What version of H2 do you use? Class.forName(org.h2.Driver);

Re: [h2] error [90112-178] when executing delete statements

Hi, I think the problem was Issue 566: MVStore: unique indexes that were created later on did not work correctly if there were over 5000 rows in the table.. This is fixed with version 1.4.179. But you will need to re-create the database I'm afraid (via export to SQL script for example). Regards,

[h2] jdbc 4.1 and java 8

Hi, That's one issue I have with Maven: it doesn't use content hashes by default. In theory, a mirror of the Maven repo could even inject a virus into a library. See also http://stackoverflow.com/questions/7094035/how-secure-is-using-maven The H2 build contains the content hashes of all

Re: [h2] exporting SQL script for creating tables and inserting data

Hi, Use script (see the documentation). Regards, Thomas On Monday, June 23, 2014, waseem salmankhan0...@gmail.com wrote: How can we export SQL script in H2 Database ? Thanks. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe

Re: [h2] Running H2 in mixed mode with a connection pool

Hi, All connections to the same database within the same process are either open in embedded mode, or in server mode. Regards, Thomas On Sunday, June 22, 2014, Kenton Garner kenton.gar...@gmail.com wrote: Simple question... I am Running H2 in mixed mode: when using a connection pool does

Re: [h2] how to create and access database using h2 via cfml ?

Hi, What did you try exactly? Regards, Thomas On Monday, June 23, 2014, waseem salmankhan0...@gmail.com wrote: hi, I am having MySQL database with several tables already now i want to have same tables in the h2 database, i have tried creating the database with same name as of MySQL

Re: [h2] error [90112-178] when executing delete statements

Thanks Thomas. the index was not used really in the app so we can live without it for now. ,, but good to know about the fix! On Tuesday, 24 June 2014 07:09:16 UTC+1, Thomas Mueller wrote: Hi, I think the problem was Issue 566: MVStore: unique indexes that were created later on did not

Re: [h2] How do you do a point query with a TIMESTAMP ? Cannot find anything senerio that works.

Hi, The discussion was moved to http://stackoverflow.com/questions/24377271/h2-database-how-can-you-do-a-point-query-with-a-timestamp-cannot-find-anythin/24379760#24379760 Please don't use StackOverflow AND the Google Group. Use one or the other. Regards, Thomas On Tue, Jun 24, 2014 at 8:09

Re: [h2] h2 console usability

Hi Thomas, I use h2-1.3.175 with Chromium 34.0.1847.116-0ubuntu2. Cheers, Silvio On Tuesday, June 24, 2014 8:09:19 AM UTC+2, Thomas Mueller wrote: Hi, It doesn't do that for me. What version of H2, and which browser do you use? Regards, Thomas On Saturday, June 21, 2014, Silvio

[h2] patch: getClientInfo to get server list in clustered configuration

Hi I am using H2 in a clustered configuration where we need some control/detection of which servers are currently in the cluster. I have added functionality to the jdbc connection to get the number of servers currently in the cluster and which servers that are available. Have a look at my

Re: [h2] Is multithreading safe or not? ... IndexOutOfBoundsException

Thomas, Thanks for your quick reply. I am not 100% certain that I could reproduce my first issue, However, I downloaded and tested 1.4.179 under the same conditions. One connection, multiple threads updating rows ( currently my methods are all synchronized, but they were before as well. ).

Re: [h2] how to create and access database using h2 via cfml ?

@Thomas i have successfully created database using H2 console, now I got the problem errors while retrieving data. I am having a users table when i have tried to retrieve it cfquery name=q datasource=mydb SELECT first_name, last_name, email FROM users /cfquery cfdump var=#q# getting

Re: [h2] some data size increase tests

Quick question... I cannot find the ;compress=true URL option in the documentation. Are there levels of compression that can be specified on the URL or simply true/false? On Tuesday, June 24, 2014 2:09:20 AM UTC-4, Thomas Mueller wrote: Hi, Did you try with the latest version of H2

Re: [h2] some data size increase tests

Hi, This feature is a bit hidden (right now; once we find it's really useful it will be better documented). See http://h2database.com/javadoc/org/h2/engine/DbSettings.html#COMPRESS Are there levels of compression that can be specified on the URL or simply true/false? Internally, yes, but you

Re: [h2] Problem with JDBC Url (h2 server mode)

Hi, Could you try again with the very latest version? There was a change in this area (even thought, this was for Windows), maybe it works now. If not, do you use any system properties (for example the h2.baseDir)? Could you post the complete stack trace(es)? Regards, Thomas On Tue, Jun 24,

Re: [h2] using h2 servlet console with embedded derby

Thomas, I am using h2/derby (both embedded) within a tomcat app. The H2 console is exposed via the WebServlet. The h2 and derby jars are placed in tomcat's lib directory. I know derby.jar is loaded because the web app works fine with derby - except derby does not work with the H2 console.

[h2] Looking for best practices to control DB File size - indexes seem to be an issue...

Looking for best practices to control DB File size - indexes seem to be an issue... Had a DB file nearing 6.5GB. Deleted all but 7 rows and size remained constant. Not surprised documents indicate that space is reused. However, closing the connection is supposed to run some minimal cleanup

Re: [h2] Looking for best practices to control DB File size - indexes seem to be an issue...

Thanks Thomas. On Tuesday, June 24, 2014 3:04:21 PM UTC-4, Thomas Mueller wrote: Hi, The MVStore doesn't re-use the disk space as efficiently as the PageStore. Version 1.4.x uses the MVStore by default. To shrink a database with version 1.4.x, you need to run shutdown defrag. What you

Re: [h2] I've got something wrong h2 index.

I have got cause. H2 create index on large table results in incomplete index when using mvstore database pattern. Thanks a lot,Thomas Mueller ! By the way, what version will solve this bug? On Thursday, June 19, 2014 1:42:32 PM UTC+8, Thomas Mueller wrote: Hi, Could you post or send