Hi,
I'm getting an ArrayIndexOutOfBoundsException in both 1.3.162 and 1.3.164:
03-17 19:33:32 jdbc[2]: exception
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
SELECT * FROM "SYS_2003652629_mc" ORDER BY "p_T1_ORG_NAME_edi" DESC [5-16
I find the method.
When I use H2 in console mode, I click on "tools" (outils in french)
then in "repair" (réparation in french). This create a sql file :
histoire.h2.sql (the name of my base is histoire). In this file I
search the failing constraint (I use notepad++ for this) and I change
it (usual
When I rename a column, the constraints are not updated. For example I
have this constraint
CHECK ((AFFICHAGE = 0)OR ((AFFICHAGE >= 1.00)AND (AFFICHAGE <=
25.00)))
I rename the column AFFICHAGE in NEW_NAME. I close the connection.
When I try to reconnect to my base I have this error :
C
Hi,
Sorry for the delay. I see the problem now. The error code was changed
because originally H2 didn't use the "correct" (as defined by the SQL
standard) value. There are multiple solutions:
- move the ErrorCode class to org.h2.api
- use SQLIntegrityConstraintViolationException instead of SQLEx
Hi,
I don't know why it is slow. Could you use the built-in profiling tool
to find out details? See also
http://h2database.com/html/performance.html#application_profiling
Regards,
Thomas
On Tue, Feb 21, 2012 at 10:13 AM, Kasja wrote:
> Hello, i'm using h2 with hibernate, database file ~ 570 m
Hi,
> Any thoughts on why the group sorted has a poorer performance?
No.
> Is there a way to override the choices?
No, currently not.
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-dat
Until today I used
java -jar ~/java/jars/h2-jdbc.jar &
to start the server.
This also started a new browser instance and I do not want this. I
found and use now:
java -cp ~/java/jars/h2-jdbc.jar org.h2.tools.Server -tcp -web &
This does not start a new browser instance, but it also does n