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
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
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);
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,
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
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
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
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
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
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
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
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
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. ).
@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
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
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
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,
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.
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
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
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
21 matches
Mail list logo