I have just added support (revision 4861) for passing additional
arguments into custom TableEngine implementations.
You can try it out in tonight's nightly build.
The syntax looks like
CREATE TABLE t1(id int, name varchar) ENGINE com.acme.MyEngine WITH
param1, param2
And the parameters
I'm getting the following error:
org.h2.jdbc.JdbcSQLException: IO Exception: java.io.IOException:
org.h2.message.DbException: IO Exception: java.io.IOException:
org.h2.jdbc.JdbcSQLException: IO Exception: Missing lob: 7
[90028-170] [90028-168]; lob: null table: -1 id: 7 [90031-168]
When I do
Hi,
Yeah this doesn't work. And nobody is currently supporting MVCC until
the new Storage engine is out. So options are: Don't use MVCC. Don't use
For Update with LOBS. Try and fix H2 code.
Also, Other people have noted problems with lots of LOBS and MVCC when
not using for update.
Ryan
Sounds good Noel.
I'd mocked up a similar patch, which I hadn't yet submitted. Instead of
using a list of strings, I stored the params as a Properties object called
storageParams attached to the CreateTableData object. In the case where
the string is just on its own (no equal sign), I'd set
You're more than welcome to make your strings look like
key1=val, key2=val2
I did the simplest thing that could possibly work.
I don't see any reason to add additional complexity for things like this.
I must admit, I am partly motivated by the fact that people seem to be
developing additional
Thanks a lot for the caveat on LOBS and MVCC. I will consider other
alternatives for the moment.
(reference to new storage engine:
MVStorehttp://www.h2database.com/html/mvstore.html
)
Am Montag, 24. Juni 2013 11:29:12 UTC+2 schrieb Kartweel:
Hi,
Yeah this doesn't work. And nobody is