Another problem now :
org.h2.jdbc.JdbcSQLException: Unsupported database file version or invalid
file header in file /blablabla/database_name.h2.db [90048-122]
at org.h2.message.Message.getSQLException(Message.java:106)
at org.h2.message.Message.getSQLException(Message.java:117)
at org.h2.message.Message.getSQLException(Message.java:76)
at org.h2.store.PageStore.readStaticHeader(PageStore.java:563)
erreur : java.lang.NullPointerException
at org.h2.store.PageStore.openExisting(PageStore.java:284)
at org.h2.store.PageStore.open(PageStore.java:254)
at org.h2.engine.Database.getPageStore(Database.java:2294)
at org.h2.engine.Database.open(Database.java:625)
at org.h2.engine.Database.openDatabase(Database.java:228)
at org.h2.engine.Database.<init>(Database.java:222)
at org.h2.engine.Engine.openSession(Engine.java:58)
at org.h2.engine.Engine.openSession(Engine.java:142)
at org.h2.engine.Engine.getSession(Engine.java:122)
at
org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at controleur.ConnectionH2.<init>(ConnectionH2.java:31)
at modele.Projet.<init>(Projet.java:62)
at
controleur.RestaurationProjet.restaureProjet(RestaurationProjet.java:39)
at vue.FenetrePrincipale.actionPerformed(FenetrePrincipale.java:2404)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:389)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
at com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137)
at
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
at java.awt.Component.processMouseEvent(Component.java:6374)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6139)
at java.awt.Container.processEvent(Container.java:2085)
at java.awt.Component.dispatchEventImpl(Component.java:4736)
at java.awt.Container.dispatchEventImpl(Container.java:2143)
at java.awt.Component.dispatchEvent(Component.java:4566)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4621)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4282)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212)
at java.awt.Container.dispatchEventImpl(Container.java:2129)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4566)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:680)
at java.awt.EventQueue.access$000(EventQueue.java:86)
at java.awt.EventQueue$1.run(EventQueue.java:639)
at java.awt.EventQueue$1.run(EventQueue.java:637)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at
java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue$2.run(EventQueue.java:653)
at java.awt.EventQueue$2.run(EventQueue.java:651)
at java.security.AccessController.doPrivileged(Native Method)
at
java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:650)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
2011/4/7 frederic.vergnaud <[email protected]>
> Hi Thomas,
> I have a very big problem with my database. When I try to connect ti
> one of my tables called Message, I've the following error :
>
> org.h2.jdbc.JdbcSQLException: General error:
> java.lang.RuntimeException: parent not found:20 [50000-122]
> at org.h2.message.Message.getSQLException(Message.java:106)
> at org.h2.message.Message.convert(Message.java:283)
> at org.h2.engine.Database.openDatabase(Database.java:262)
> at org.h2.engine.Database.<init>(Database.java:222)
> at org.h2.engine.Engine.openSession(Engine.java:58)
> at org.h2.engine.Engine.openSession(Engine.java:142)
> at org.h2.engine.Engine.getSession(Engine.java:122)
> at
>
> org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:
> 17)
> at
> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:
> 245)
> at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
> at org.h2.Driver.connect(Driver.java:58)
> at java.sql.DriverManager.getConnection(DriverManager.java:582)
> at java.sql.DriverManager.getConnection(DriverManager.java:207)
> at controleur.ConnectionH2.<init>(ConnectionH2.java:31)
> at modele.Projet.<init>(Projet.java:62)
> at
> controleur.RestaurationProjet.restaureProjet(RestaurationProjet.java:
> 39)
> at
> vue.FenetrePrincipale.actionPerformed(FenetrePrincipale.java:2404)
> at
> javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:
> 2028)
> at javax.swing.AbstractButton
> $Handler.actionPerformed(AbstractButton.java:2351)
> at
> javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
> 387)
> at
> javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:
> 242)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:389)
> at
> javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:
> 809)
> at com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137)
> at javax.swing.plaf.basic.BasicMenuItemUI
> $Handler.mouseReleased(BasicMenuItemUI.java:850)
> at java.awt.Component.processMouseEvent(Component.java:6374)
> at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
> at java.awt.Component.processEvent(Component.java:6139)
> at java.awt.Container.processEvent(Container.java:2085)
> at java.awt.Component.dispatchEventImpl(Component.java:4736)
> at java.awt.Container.dispatchEventImpl(Container.java:2143)
> at java.awt.Component.dispatchEvent(Component.java:4566)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:
> 4621)
> at java.awt.LightweightDispatcher.processMouseEvent(Container.java:
> 4282)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212)
> at java.awt.Container.dispatchEventImpl(Container.java:2129)
> at java.awt.Window.dispatchEventImpl(Window.java:2478)
> at java.awt.Component.dispatchEvent(Component.java:4566)
> at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:680)
> at java.awt.EventQueue.access$000(EventQueue.java:86)
> at java.awt.EventQueue$1.run(EventQueue.java:639)
> at java.awt.EventQueue$1.run(EventQueue.java:637)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.security.AccessControlContext
> $1.doIntersectionPrivilege(AccessControlContext.java:87)
> at java.security.AccessControlContext
> $1.doIntersectionPrivilege(AccessControlContext.java:98)
> at java.awt.EventQueue$2.run(EventQueue.java:653)
> at java.awt.EventQueue$2.run(EventQueue.java:651)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.security.AccessControlContext
> $1.doIntersectionPrivilege(AccessControlContext.java:87)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:650)
> at
>
> java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:
> 296)
> at
> java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:
> 211)
> at
>
> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:
> 201)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:
> 196)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:
> 188)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
> Caused by: java.lang.RuntimeException: parent not found:20
> at org.h2.message.Message.throwInternalError(Message.java:186)
> at org.h2.store.PageStore.addMeta(PageStore.java:1274)
> at org.h2.store.PageStore.readMetaData(PageStore.java:1205)
> at org.h2.store.PageStore.recover(PageStore.java:1014)
> at org.h2.store.PageStore.openExisting(PageStore.java:296)
> at org.h2.store.PageStore.open(PageStore.java:254)
> at org.h2.engine.Database.getPageStore(Database.java:2294)
> at org.h2.engine.Database.open(Database.java:625)
> at org.h2.engine.Database.openDatabase(Database.java:228)
> ... 55 more
>
> And in the H2 console, I success connect the database, but when I'm
> trying to make a SELECT on my table Message, I've this error
> message :
>
> File not found: "/blablabla/database_name.lobs.db/
> 10.t20.lob.db" [90124-154] 90124/90124
>
> I think it's a problem with a clob column. I've made some ALTER TABLE
> MESSAGE ALTER COLUMN column_name CLOB, then ALTER TABLE MESSAGE ALTER
> COLUMN column_name VARCHAR because finally I didn't need such a large
> type of data.
> I can't come back to the exact changes I've made on my software
> because I don't use this table very often, but I suspect it happened
> after an update from the 1.2.122 version to the 1.3.153 version (then
> 1.3.154 I actually use)
>
> Thanks for your fast answer and sorry for my bad english ;)
>
> --
> 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.
>
>
--
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.
