Hi,
H2 call the function multiple times on order to retrieve column list.
There is a way to detect when only column list is necessary:
https://github.com/irstv/H2GIS/blob/master/h2spatial/src/main/java/org/h2gis/h2spatial/TableFunctionUtil.java#L67
See:
Check this out: http://www.jetbrains.com/dbe
Works with H2!
--
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+unsubscr...@googlegroups.com.
To post to
Hmmm. I can't see how that can be happening either.
RegularTable doesn't have a tryLock method - perhaps you meant lock?
Either way, could you post the complete stack trace of the exception?
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To
Hi,
What is your database URL?
The lock timeout is probably set later on, not in the constructor. So just
looking at the constructor is not enough.
Regards,
Thomas
On Tuesday, June 17, 2014, Steve Ash stevem...@gmail.com wrote:
I am using H2 1.3.170 and am getting lock timeout errors while
Hi,
I am using h2 version 1.4.178,
and get below error from the application which uses H2:
Row not found when trying to delete from index
PUBLIC.CONSTRAINT_2_INDEX_2: 12273; SQL statement:
*delete from XXX WHERE A = ? and B in ( NULL , 'a' ) and C=3*[90112-178]
when trying to run the
The complete connection URL I am using is:
I'm guessing that it's the multi-threaded option that is causing trouble.
Something somewhere is not synchronized and it's using a stale value for
the lock timeout.
Also turning off the log and then also turning on multithreaded is pretty
much asking for a corrupt db at some point.
If you are
This is a temporary-ish database that we just use once and throw away
inside of a tool. So I'm ok-ish with some risk... though I would like to
understand more if there are specific areas of H2 to avoid under MT mode.
Would MVStore be more stable to use in MT mode?
On Wednesday, June 18, 2014
Hi,
(I'm sure you know what you are doing, but I need to write that for others
reading this). You are using dangerous features (file_lock=no, log=0), and
if the process crashes, then the database is most likely in an unusable
state. By the way this is no longer the case with H2 version 1.4.x.
Hi,
If the Derby JDBC driver is in the classpath, then I'm afraid I don't know
what the problem could be.
Should the h2 console work with derby?
Sure.
Am I doing something wrong?
I would double check if the Derby JDBC driver is really in the classpath.
Where exactly did you put the
Hi,
in hsqldb, a servlet-based http transport can be used to communicate
between server and client.
Yes, I know. I think I originally wrote that feature :-)
when migrate to h2, i don't find any information about it. is H2 provides
one?
I'm afraid not. There are no plans to add this feature
Hi,
Could you post or send me the database file please?
Regards,
Thomas
On Tuesday, June 17, 2014, Frank Liu liusheng112...@gmail.com wrote:
select * from TSV_LTE_CAUSE where protocolid=14
when i do not create index on tsv_lte_cause(protocolid) ,i can get a 14
data.
but i create index,i
Hi,
With version 1.4, you can use both MVCC and multi-threaded at the same time
(as documented).
In version 1.4, the MVCC behavior is the same as with PostgreSQL, as far as
I can tell (or as far as my randomized tests can tell).
Regards,
Thomas
On Sunday, June 15, 2014, Wen Bob
13 matches
Mail list logo
