Bug 58147

Summary: FILEOPEN connection could not be established
Product: LibreOffice Reporter: Helmut Leininger <hlein>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: robert
Priority: medium    
Version: 3.6.4.3 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Database
Database

Description Helmut Leininger 2012-12-11 16:34:14 UTC
Created attachment 71342 [details]
Database

I started to create a very small database in Libreoffice 3.6.4.3 and closed it.

When I reopen it later, I get the error "The connection could not be established. The database was created by a newer version of LibreOffice." whatever I try to do with the database. It does not show the tables either.
Comment 1 Helmut Leininger 2012-12-11 16:36:12 UTC
Created attachment 71343 [details]
Database
Comment 2 Robert Großkopf 2012-12-11 19:33:10 UTC
When I extract the database the properties show:

#HSQL Database Engine 2.2.9
#Tue Dec 11 11:41:52 CET 2012
version=2.2.9
modified=no

This isn't the version included in LO.

In LO there must be the following content in /database/properties:
#HSQL Database Engine 1.8.0.10
#Fri Nov 30 19:58:32 CET 2012
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=true
hsqldb.cache_size_scale=8
readonly=false
hsqldb.nio_data_file=false
hsqldb.cache_scale=13
version=1.8.0
hsqldb.default_table_type=cached
hsqldb.cache_file_scale=1
hsqldb.lock_file=true
hsqldb.log_size=10
modified=no
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0

Did you connect with LO to an external version of HSQLDB? If you have connected to an external version and this external version is already installed in the classpath of Java, Lo tries to use this external version of the HSQLDB.
Comment 3 Helmut Leininger 2012-12-11 20:01:56 UTC
@Robert

you are right, I had set an additional CLASSPATH and did not rembmber it.

Prblem solved !
Comment 4 Robert Großkopf 2012-12-11 20:27:22 UTC
So I set this report to "Resolved" and "Notabug".