Hi,

> I try connect in h2 database using parameters RECOVER=1 in url,but i
> gain the error bellow. Someone could help me solve this error?
>
> Exception in thread "main" org.h2.jdbc.JdbcSQLException: Unique index
> or primary key violation: PRIMARY_KEY_0  ON ST.VERTICE(ID_FATOR_RISCO,
> DATA) [23001-46]

>From the stack trace, you are using version 1.0, build 46, from
2007-04-29. I suggest to upgrade to a more recent version, as some
important bugs have been fixed since then.

> I can“t recovery my database because this error. My recovery never
> finished.

Could you use the recovery tool of the newest version to create a SQL
script from the database? You can start the H2 Console and then click
on Tools, Recover. A recovery tool is included in the version you
have, but you can only run it from command line (java -cp h2.jar
org.h2.tools.Recover -?).

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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to