hi,
Just few tips
- what error is in OpenConcerto.trace.db?
- try to create some table using the console. does that work? error?
- what happens if you move the DB to location without spaces?
- have you experimented with permissions to the DB file?
Tono
On Tuesday, May 20, 2014
Hi,
in H2 1.3.173 the meta data for the ResultSet of query
SELECT 0.02
tells that the precision of the numeric column is 1 (but obviously it
should be = 2 (scale)).
For
SELECT 1.02
the precision is returned as 3 (as expected). It seems to me that this is
a bug for numeric literals in
Have you tried testing on the latest version?
On 2014-05-21 10:37, christoff.schm...@finaris.de wrote:
in H2 1.3.173 the meta data for the ResultSet of query
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from this group and
Hi,
one of our customers is facing the following problem while using our
product, which uses an embedded H2 database (v. 1.3.173).
The query looks like this:
SELECT INITIAL_FIXED_VOL, FIXED_YIELD_4AVG, FIXED_ORIGMAT_4AVG,
INITIAL_FLOAT_VOL, FLOAT_YIELD_4AVG, FLOAT_ORIGMAT_4AVG
FROM
Hi,
The main problem is found. the '\ ' character in the path is not recognized.
I created a db in ~ and connected to it, create a table, disconnect.
I move the db in ~/Library and connect to it: the table is displayed.
I move the db in ~/Library/Application\ Support and connect to it: the
table
The result is the same for 1.3.176
Kind regards
Christoff Schmitz
F I N A R I S
Financial Software Partner GmbH
Sömmerringstrasse 23
60322 Frankfurt am Main
Fon: +49 (0)69 / 254 98 - 24
Mobile: +49 (0)176 / 206 34 186
Fax: +49 (0)69 / 254 98 - 50
eMail:
I have no idea what the underlying problem is.
But if you could create a standalone test case for it I could probably track it
down.
In the meantime you could probably work around it by bumping up your cache size.
Append something like this to your URL
;CACHE_SIZE=1024
where the size is in
Le mercredi 21 mai 2014 10:55:55 UTC+2, Ospeleo a écrit :
Hi,
The main problem is found. the '\ ' character in the path is not
recognized.
I created a db in ~ and connected to it, create a table, disconnect.
I move the db in ~/Library and connect to it: the table is displayed.
I move
On 2014-05-21 10:37, christoff.schm...@finaris.de wrote:
*SELECT**0.02*
tells that the precision of the numeric column is 1 (but obviously it should be
= 2 (scale)).
No, the precision is the number of significant digits in a number.
In this case the precision is 1 since there is only one
Hi,
so this is basically a known issue? And as I understand from your context,
you are currently lacking a test case that would reproduce the issue? I
can't provide one at the moment either, as I can't acquire the customer's
database that reproduces this (and it doesn't occur in our own
I have not realized this right away but backward slash is not URI
replacement for space. it is %20 . The slash is usually used in file paths
but not in the URI. JDBC connection string is URI hence you need to make
sure it is valid. Try the %20 perhaps that will work for you. Maybe
malformed
I have the same blank database If I use %20 or '\ '
But when I move the database (temporarily) to another location, without a
space in the path, I get the error message cited below
Le mercredi 21 mai 2014 13:44:01 UTC+2, too a écrit :
I have not realized this right away but backward slash is
I'm using H2 console to open a database.
When opening the first time the database, I'm able to see the different
tables of the database and execute SQL scripts.
When I try to open it a second time, I always have the following error :
Unique index or primary key violation: PRIMARY KEY ON
hi,
it is the same error message I have reported on this subject, posted today:
https://groups.google.com/d/msg/h2-database/iPAECUAML4Y/70PkSslWInQJ
I access my database via my application/ Works great. I want to manipulate
the table. The same error than yours.
Le mercredi 21 mai 2014
when I upgrade to 1.3.176,I have the same problem. the old version h2 is
works fine with the db file
On Tuesday, May 6, 2014 5:00:52 PM UTC+8, Germano Rizzo wrote:
Hi Thomas,
so your opinion is that all the db's are corrupted? The strange
thing is, they fail to open only with the
15 matches
Mail list logo