Hi,
I think the problem is not the database, but how you use the JDBC API. If
you share a connection and run this in parallel, then the following
sequence may occur:
insertTree executeUpdate
insertTree executeUpdate
keys = insertTree.getGeneratedKeys
keys = insertTree.getGeneratedKeys
Hi,
This is a bug. The problem is that internally, the result of the first
query is re-used, and at the same time, a SimpleResultSet is used, which is
automatic closed when displaying the result of the first query. So it is
closed the second time. The SimpleResultSet shouldn't be auto-closed. I
Hi,
I'm not using temporary tables
I think there are some cases where Hibernate creates temporary tables, and
for some queries (those that return many rows) the database itself creates
temporary tables.
If you still have the database file, could you send it to me please? I
would like to
Hi,
You are adding -SNAPSHOT to the version. Was there any other change? I
will try to change the build so that all h2-latest are automatically
snapshot versions.
Regards,
Thomas
On Friday, March 14, 2014, Nicolas Fortin (OrbisGIS) nico.de...@gmail.com
wrote:
Hi,
I work on how to define a
There is no way to do that, but another way to access the MySQL table would be
to define a resultset-returning function:
http://h2database.com/html/features.html#user_defined_functions
On 2014-03-19 19:29, Vishwanatha Sundarappa wrote:
Hi All,
I need to create Linked table to my mysql view
Hi,
Great ! Only Implementation-Version support the - character. Other
attributes must use dot instead 1.3.176.SNAPSHOT
I don't know if it is complicated to deploy snapshot on maven central. I
follow this file to do release for h2gis but I do not automated the
process.
Hi,
I changed my MySQL database to H2 on a Ubuntu 12.04.1 LTS server.
I noticed that H2 runs 6 to 8 times longer than MySQL during my
applications login, where I perform numerous selects and one or two inserts
statements.
Do you know why this would be and is there anything I can change in my
Is this only on the first connection, or on every connection?
Why are you encrypting the H2 database, since you can't be encrypting the MySQL
database?
On 2014-03-20 10:03, ryan Povey wrote:
I changed my MySQL database to H2 on a Ubuntu 12.04.1 LTS server.
I noticed that H2 runs 6 to 8 times
In the meantime I found out that the MAX_MEMORY_ROWS setting is accepted by
the database (I've looked up the setting in the SETTINGS table of the
information_schema).
So it seems that the behaviour described in this thread is not affected by
the MAX_MEMORY_ROWS settings and therefore the
For reasons unknown to me, we appear to have a second setting that takes affect
when we are issuing DISTINCT queries.
This setting is called MAX_MEMORY_ROWS_DISTINCT.
Personally I should we should can this setting, and just use MAX_MEMORY_ROWS,
but I'll let Thomas weigh in here.
Anyhow, for
My psychic powers appear to be faulty today, how about you help us out and post
the actual exception trace you are getting?
On 2014-03-20 13:48, Vonmist wrote:
I am currently using h2 version 1.3.174 and faced this error when i am working
on Trigger class whereby a UPDATE
statement is at the
On Thursday, March 20, 2014 7:48:12 PM UTC+8, Vonmist wrote:
Hi all,
I am currently using h2 version 1.3.174 and faced this error when i am
working on Trigger class whereby a UPDATE statement is at the fire() method.
I have searched the net and was told h2 v1.3.174 shouldnt have this
Hi Noel
The exception trace is as shown from previous post.
Thanks
On Thursday, March 20, 2014 8:06:25 PM UTC+8, Vonmist wrote:
On Thursday, March 20, 2014 7:48:12 PM UTC+8, Vonmist wrote:
Hi all,
I am currently using h2 version 1.3.174 and faced this error when i am
working on
that exception is in your code:
at com.auctorizium.database.server.TestTrigger.fire(TestTrigger.java:41)
--
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
This setting is called MAX_MEMORY_ROWS_DISTINCT.
Thanks it works.
I was confused because MAX_MEMORY_ROWS_DISTINCT is not documented.
I don't mind if there are one or two settings (if two settings make sense).
Thanks!
Uli
--
You received this message because you are subscribed to the
Inside my fire() method, there is a preparedStatement that execute a update
statement to the database.
On Thursday, March 20, 2014 8:09:46 PM UTC+8, Noel Grandin wrote:
that exception is in your code:
at
com.auctorizium.database.server.TestTrigger.fire(TestTrigger.java:41)
--
You
The update statement have been tested and was working outside of the
Trigger Class but when it was run at the fire() method inside the Trigger,
the error appear.
Thanks
On Thursday, March 20, 2014 8:12:40 PM UTC+8, Vonmist wrote:
Inside my fire() method, there is a preparedStatement that
Hello all.
I'm currently running H2 1.3.174 and get the following error when I try to
connect the web console to my H2 server running in Postgresql mode. The web
console still connects but this error is still displayed in the left-hand
panel after I connect. Any ideas?
Thanks for your time!
On Friday, November 30, 2012 1:49:57 PM UTC+1, Thomas Mueller wrote:
Hi,
I think it's worth to revive it once Java 8 is available, using closures
for conditions. So instead of:
Now that Java 8 is out, is it time to resurect?
Product p = new Product();
ListProduct restock = db.from(p).
19 matches
Mail list logo