When I open a not-yet-existing database in an existing directory
jdbc:h2:file:d:\osm\streets;shutdown=true
I keep getting a "Wrong database fle version".
any ideas as to the possible reason?
I know my code worked before.
Marcus
--
You received this message because you are subscribed to the
I'm running H2 (v1.1.118 and I tried v1.2.125) as an embedded database
in a Java application and the current size is about 24GB. I've
installed our application onto 10 HP laptops and 6 of the 10 get the
following error during establishing a JDBC connection to this
database:
org.h2.jdbc.JdbcSQLExce
Thomas,
I love the H2 documentation. What tools do you use?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr..
Do you mean like a clustered index? Is that what it is called?. Like in
MS SQL doesn't it return result sets in the order specified by the
clustered index?
Ryan
Serg wrote:
> I've noticed that H2 manipulates positions of records after executing
> UPDATE and INSERToperations.
>
> In other words
Hi all,
I found one case where H2 query optimizer does not work. I created
patch which solve it
My application is using this type of query:
create table star (
starId int primary key AUTO_INCREMENT,
ipix long );
create index star_ipix on star(ipix);
//insert 100 000 records
/
On Tue, Dec 15, 2009 at 7:46 AM, Sam Van Oort wrote:
> On Dec 10, 6:26 pm, Tatu Saloranta wrote:
...
>> Also: using chunk identifiers like command-line tools has one nice
>> benefit; that is, you can just sequence blocks without restrictions as
>> there is no initial header (which can be downside
Hi,
>> I think it'd be nice to be compatible, especially if a separate
>> library was carved out.
> I'm talking with Mr. Mueller about this, but it could take some time
> to work out. We'll see where it goes?
I have no problem if you create a special project for the LZF tool.
Apache license if f
Hi,
This is a bug in version 1.2.x. I will fix in in the next release.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email
Hi,
Please don't post the same message twice.
> java -cp h2*.jar org.h2.tools.ChangeFileEncryption -cipher "XTEA" -dir "~"
> -db "test"
Are you sure? If I run that, I get the following exception:
"Encryption or decryption password not set, or cipher not set"
Do you already know about the "Error
Hi,
> java -cp h2*.jar org.h2.tools.ChangeFileEncryption -cipher "XTEA" -dir "~"
> -db "test"
Are you sure? If I run that, I get the following exception:
"Encryption or decryption password not set, or cipher not set"
Do you already know about the "Error Analyzer"? The link is on the H2
main page
Some just have to pay homage more than others; the windows filesystems
are *dreadfully* slow at times, especially NTFS.
Y'know, I don't think anyone has done a comparison of H2 performance b/
w the different filesystems. I also wouldn't be surprised to find that
the right filesystem block size mak
On Dec 10, 6:26 pm, Tatu Saloranta wrote:
> On Thu, Dec 10, 2009 at 1:34 PM, Sam Van Oort wrote:
>
> > Hi,
> > I can add this to a list of extensions to theLZFcode. It's not a
> > bad idea to have a version which is fully binary compatible, which can
> > be used as a compatibility option in the
yes it is a new database it is called .h2.db
and I am sure to use the latest one...
don't know what happens.
Is there something I could test?
On Mon, Dec 14, 2009 at 8:52 PM, Thomas Mueller <
thomas.tom.muel...@gmail.com> wrote:
> Hi,
>
> > now I am sure I am using the latest version, and it
There is no such ability because in cases when you need to get a query
result in some specific order the right solution is to use ORDER BY
clause. You are looking for a some kind of hack instead. AFAIK most of
databases (if not all) do not guarantee the order of records too.
--
You received this
I've noticed that H2 manipulates positions of records after executing
UPDATE and INSERToperations.
In other words after executing the script
CREATE TABLE INVOICE(ID INT PRIMARY KEY, AMOUNT DECIMAL);
INSERT INTO INVOICE VALUES(1, 10.0);
INSERT INTO INVOICE VALUES(2, 19.95);
INSERT INTO INVOICE VAL
15 matches
Mail list logo