I am modelling my H2 database (23 tables at the moment) with MySQL
Workbench. While that application generates MySQL-specific syntax, it is
not very hard to replace that with something ANSI-like that H2 understands.
Obviously, this does not work for roundtrip-style development, but it is
suffic
Hello,
We get the following exception when stressing a database from two
different processes with FILE_LOCK=SERIALIZED
Exception in thread "main" javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: could not get next sequence
value
at
org.hibernate
On Tue, Dec 13, 2011 at 6:18 PM, Marco Biancini wrote:
> In order to be more protected against a file system full condition, is
> it possible to pre-alloc the db file at specific size ?
>
>
My guess that this is impossible, if H2 is using the standard file API. A
workaround would be to create a di
H2 does not support index only scans yet
On Tuesday, 13 December 2011, Michael wrote:
> Hi,
>
> I have the following table with index on 'resource_id':
>
> CREATE TABLE IF NOT EXISTS sw_stream_resource_assoc(
>data_id INT NOT NULL,
>resource_id VARCHAR NOT NULL,
>FOREIGN K
In order to be more protected against a file system full condition, is
it possible to pre-alloc the db file at specific size ?
Thanks regard,
Marco
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database
Hi Thomas -
I will reply with some more detail but briefly,
- No DEFRAG or SHUTDOWN flags are set
- The error appears usually after "javaw" (used to spawn H2) is forcefully
terminated (Windows Task Manager -> End process)
- We start the server like this:
-Xmx512m -Xrs -cp h2-1.3.158.jar;ikfx.ja
I do not think there is a bug in the code.
Either it is an H2 issue or some H2 configuration.
On Dec 12, 12:15 pm, Noel Grandin wrote:
> Since it happens with both imdb and h2, it is most likely a bug in your code
>
>
>
>
>
>
>
>
>
> On Monday, 12 December 2011, Vinod wrote:
> > I wonder why nob
Hi,
I have the following table with index on 'resource_id':
CREATE TABLE IF NOT EXISTS sw_stream_resource_assoc(
data_id INT NOT NULL,
resource_id VARCHAR NOT NULL,
FOREIGN KEY(data_id) REFERENCES sw_stream_data(id) ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY(
Hello,
When I run the H2 unit tests TestFileLockSerialized with property
h2.ModifyOnWrite set to true, the testTwoWriters test takes quite a lot of
time (I killed it after about two hours). I'm wondering if there might not
be an interlock. The main thread is hung on the "drop table test" statem
