![[en]](../inc/lang/en.gif)
Sujet n°225 -
Issue while opening file on version 5.05.04
- par Jacx le 25/10/2021 14:24
Hi, I have encountered issues while trying to open my saved file after upgrading to the latest version. The file would not open, and the following error messages appeared in a pop-up:
Code : xhtmlException Message:
Cannot open connection
Stack Trace:
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345)
at com.sun.proxy.$Proxy0.beginTransaction(Unknown Source)
at storybook.model.AbstractModel.beginTransaction(AbstractModel.java:50)
at storybook.model.book.Book.getNbChapters(Book.java:546)
at storybook.ui.StatusBarPanel.refreshStat(StatusBarPanel.java:153)
at storybook.ui.StatusBarPanel.initUi(StatusBarPanel.java:105)
at storybook.ui.panel.AbstractPanel.initAll(AbstractPanel.java:76)
at storybook.ui.StatusBarPanel.(StatusBarPanel.java:59)
at storybook.ui.MainFrame.initUi(MainFrame.java:196)
at storybook.ui.MainFrame.(MainFrame.java:141)
at storybook.App.lambda$openFile$1(App.java:372)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.IllegalStateException: Unable to read the page at position 62122407073483 [1.4.200/6]" [50000-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:194)
at org.h2.message.DbException.convert(DbException.java:347)
at org.h2.engine.Database.openDatabase(Database.java:333)
at org.h2.engine.Database.(Database.java:301)
at org.h2.engine.Engine.openSession(Engine.java:74)
at org.h2.engine.Engine.openSession(Engine.java:192)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:171)
at org.h2.engine.Engine.createSession(Engine.java:166)
at org.h2.engine.Engine.createSession(Engine.java:29)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:340)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:173)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:152)
at org.h2.Driver.connect(Driver.java:69)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 33 more
Caused by: java.lang.IllegalStateException: Unable to read the page at position 62122407073483 [1.4.200/6]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:950)
at org.h2.mvstore.MVStore.readPage(MVStore.java:2213)
at org.h2.mvstore.MVMap.readPage(MVMap.java:672)
at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:688)
at org.h2.mvstore.MVMap.setRootPos(MVMap.java:682)
at org.h2.mvstore.MVStore.openMap(MVStore.java:576)
at org.h2.mvstore.MVStore.openMap(MVStore.java:535)
at
Réponse n° 1
- par favdb le 25/10/2021 15:46
Your file may have been corrupted. Could you send it to me?
Réponse n° 2
- par Jacx le 25/10/2021 16:38
Thanks for the quick reply. I will send it to your email shortly
Réponse n° 3
- par Jacx le 26/10/2021 17:24
I have sent it to your email(dev@ostorybook.eu)
Réponse n° 4
- par favdb le 27/10/2021 11:27
Hello,
Well, I found the source of the error, finally it was not your file which was corrupted but the API of access to it. I wanted to anticipate the evolution of this API by using the last available version without realizing that it was not finalized. So we have to go back to the last stable version. The incriminated file is the h2-1.4.200.jar located in the "lib" sub-folder of your installation. There are two methods to make the modification.
a) manual method :
1- download the h2-1.4.199.jar file from the following address https://framagit.org/ostorybook/mainApp/-/raw/master/lib/h2-1.4.199.jar
2- locate the oStorybook installation folder and the subfolder "lib" and save the downloaded file there
3- delete the file h2-1.4.200.jar from the subfolder "lib".
Depending on your operating system (Windows, Linux or MacOS) you will have to perform these operations with administrator rights.
b) "automatic" method ( more simple)
1- remove the installation of oStorybook
2- download the version under development at the following address
http://download.tuxfamily.org/ostorybook/next/
(take the file that corresponds to your system)
3- install oStorybook
Sorry for the disturbance.
Translated with www.DeepL.com/Translator (free version)
Réponse n° 5
- par Jacx le 27/10/2021 21:53
Hello, I used method b, and it worked. I can open the file without any problems. Thank you very much.
Réponse n° 6
- par favdb le 28/10/2021 17:25
You are welcome.
© 2004-2015 
