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 :
two changes for one problem). After I use execute the
script with the good parameters.
On 17 mar, 18:00, Patrice patrice.henrio1...@gmail.com wrote:
When I rename a column, the constraints are not updated. For example I
have this constraint
CHECK ((AFFICHAGE = 0) OR ((AFFICHAGE = 1.00
My table is Points(id,Lg,La) with 5 rows
I do this SQL request
CREATE TABLE correspondances AS
SELECT reference.id1, toreplace.id
FROM (SELECT MIN(id) AS id1, lg, la FROM points GROUP BY lg, La) AS
reference
INNER JOIN points AS toreplace
ON reference.lg=toreplace.lg AND
Sorry for my english.
I integrate H2 in a program.
I use this command
*SELECT id FROM limes WHERE *
*id NOT IN (SELECT id_limes FROM pourtours_limes) AND*
*id NOT IN (SELECT id_limes FROM dessins_fleuves);*
In console mode the result is obtained in 470 ms
When I use in a program by these line
data (1 to 48601).
My answer is why i have this error and how i can resolve that.
Thanks and sorry for my very poor english.
PATRICE
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from this group and stop receiving emails from
data (1 to 48601).
My answer is why i have this error and how i can resolve that.
Thanks and sorry for my very poor english.
PATRICE
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from this group and stop receiving emails from
Hello
I recently migrated to H2 1.4.199.
I can connect to my database without any problem and modify it. However
when I click on Options or Tools I am asked for a password. I have not
defined because I only work locally. Is there a default password?
Patrice
--
You received this message
Thank you so much. It's working now.
I think I need the 1.4.199 version because in my user program h2 I have
several threads that concurently access the database to modify it.
Le mercredi 17 juillet 2019 13:38:29 UTC+2, Patrice a écrit :
>
> I have a database managed under h2 1.3.172. I
In a database managed via H2 (version 1.4.199), any request of the type
"select" seems to increase the size of the base (8 KO each time) which I
can possibly understand to keep a trace of the transactions. Is there a way
however to return to the original size if we did not change anything in
My request does not return "LOBs" and does not include an "UPDATE".
However, I can't reproduce the problem so I consider it solved.
Le mercredi 17 juillet 2019 15:51:36 UTC+2, Evgenij Ryazanov a écrit :
>
> Maybe your SELECT statement returns some LOBs or it has FOR UPDATE clause?
> Otherwise
I have a database managed under h2 1.3.172. I wanted to update with version
1.4.199.
I make a simple SELECT on a table, I disconnect and when reconnecting I get
the following error:
*Single index violation or primary key: "PRIMARY KEY ON" "" ".PAGE_INDEX"*
*Unique index or primary key violation:
Hi,
I do the same procedure (but before I do a backup).
I rename a column with a constraint. All seem good. When I deconnect and
reconnect I have an error. I give you the message entirely.
*Column VAL_LOUPE_LIMITE_AFFICHAGE not found; SQL statement:*
CREATE CACHED TABLE
OK. I don't know this (the non standard unsigned and the place of a BigInt
and an Integer)
Thanks.
2012/5/23 Thomas Mueller thomas.tom.muel...@gmail.com
Hi
Why unsigned is not supported with H2 ?
Because it's non-standard. What SQL type (java.sql.Types) and Java
type would it be?
I can give my experience (not big, 2 or 3 M) with à complex
request sorting on a column : without index more than 15 minutes, with
index 7 seconds.
2012/6/8 Noel Grandin noelgran...@gmail.com
H2 doesn't support stepping through an index backwards, you would need to
create a reverse index to
I have this message when i try to edit a row of a table (on others tables,
editing is correct).
Row not found when trying to delete from index
PUBLIC.CONSTRAINT_FC0B_INDEX_F: ( /* key:7504 */ 396, 961, 10, TRUE); SQL
statement: UPDATE PUBLIC.POURTOURS_LIMES SET ID_POURTOUR=?
,ID_LIMES=? ,RANG=?
i do'nt know how to do that.
2013/1/4 Thomas Mueller thomas.tom.muel...@gmail.com
Hi,
If it's blocked, could you get a full thread dump to find out what it's
doing?
Regards,
Thomas
On Fri, Jan 4, 2013 at 3:15 PM, Patrice patrice.henrio1...@gmail.comwrote:
Sorry for my english.
I
Grandin noelgran...@gmail.com
Google it.
java thread dump
On Fri, Jan 4, 2013 at 5:49 PM, Patrice Henrio
patrice.henrio1...@gmail.com wrote:
i do'nt know how to do that.
2013/1/4 Thomas Mueller thomas.tom.muel...@gmail.com
Hi,
If it's blocked, could you get a full thread dump
version of H2, that is, version 1.3.160 from 2011-09-11. Since then, quite
a few problems have been fixed. Could you try again with a more recent
version?
Regards,
Thomas
On Tue, Nov 26, 2013 at 4:26 PM, Patrice patrice.henrio1...@gmail.comwrote:
Hi !
I use H2 in a Java Program
I have a new version as Thomas advise me.
For the corrupt data base : in console the database looks good.
I try to run the recover tool.
Thanks
2013/11/27 Noel Grandin noelgran...@gmail.com
On 2013-11-26 17:26, Patrice wrote:
I use H2 in a Java Program.
This SQL order give an error
Thank you so much. It's working now.
I think I need the 1.4.199 version because in my user program h2 I have
several threads that concurently access the database to modify it.
Le mer. 17 juil. 2019 à 15:03, Evgenij Ryazanov a écrit :
> Hello.
>
> Your version is very old. Automatic upgrade is
20 matches
Mail list logo