You are here :   Home » Forum » General discussion » Issue while opening file on version 5.05.04
 
Forum - General discussion - Issue while opening file on version 5.05.04

Count of members 210 members
Connected : (nobody)
Snif !!!
 

Forum - Forum
General discussion - General discussion


25/10/2021 14:24
by Jacx

Jacx



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
Post an answer Top  

Answer n° 1
--------
25/10/2021 15:46
by favdb

favdb



Your file may have been corrupted. Could you send it to me?
Post an answer Top  
Answer n° 2
--------
25/10/2021 16:38
by Jacx

Jacx



Thanks for the quick reply. I will send it to your email shortly
Post an answer Top  
Answer n° 3
--------
26/10/2021 17:24
by Jacx

Jacx



I have sent it to your email(dev@ostorybook.eu)
Post an answer Top  
Answer n° 4
--------
27/10/2021 11:27
by favdb

favdb



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)
Post an answer Top  
Answer n° 5
--------
27/10/2021 21:53
by Jacx

Jacx



Hello, I used method b, and it worked. I can open the file without any problems. Thank you very much.
Post an answer Top  
Answer n° 6
--------
28/10/2021 17:25
by favdb

favdb



You are welcome.
Post an answer Top  
active topic active   closed topic closed   Important! Important!   New New message
Correct Correct message   Close Close topic   Make sticky Make sticky  
Forum Topic  Forum 



You are here :   Home » Forum » General discussion » Issue while opening file on version 5.05.04
 
 
 
Webmaster - Infos
Preferences

Connect again :
Your user name :
Your password