Apache OpenOffice (AOO) Bugzilla – Issue 74732
cannot access any HSQLDB data when connection pooling is enabled
Last modified: 2007-05-22 23:34:10 UTC
- open the attached database - open the form therein by double-clicking it - wait about 10 seconds or so while OOo seems to be frozen => crash
Created attachment 43237 [details] document to reproduce the bug case
This is a regression relative to OOo 2.1. Further tests seem to reveal that you cannot open any database forms anymore - at least none of the ones I tried were successful. Investigating.
Further tests: affects all HSQL databases (which I tried), does not affect the Bibliography (a dBase database). For HSQL, not even opening a table succeeeds.
further investigations reveal that this happens only when connection pooling is enable for the HSQLDB driver. This is bad enough, but since the default for this option is OFF ...
fixed in CWS dba23a: connectivity/source/commontools/dbtools2.cxx 1.21.6.1
Patch fixed the issue for me. Thanks fs.
Testing under 2.2RC2 I find that even with pooling disabled I am unable to open a table using JDBC:hsqldb:file: I can create the HSQL files, I can create tables I just cannot open these tables. This is true for both a data view and attempting to issue a select statement from the SQL window. Checking the location of the data files I find the log file, with an entry for the connection and nothing further. If I try to open a table the CPU pegs at 100% for a while then OO.o crashes. Upon restart file recovery runs, but there is no offer from the application to send a crash report. Further, I can use the HSQL database manager to open the file created by OO.o and populate the tables.
that's the same issue, and is fixed in the CWS (dba23a) where this issue here is fixed.
targeting to 2.3, since the fix is part of a CWS aiming for this release
*** Issue 75343 has been marked as a duplicate of this issue. ***
fs-> msc: please verify in CWS dba23a
fs->msc: note: the attached bug doc is broken, don't know why (try unzipping it, there will be complaints from your zip tool). However, reproduction is easy with any HSQLDB database, andy table, any form ..
*** Issue 75872 has been marked as a duplicate of this issue. ***
*** Issue 75444 has been marked as a duplicate of this issue. ***
I believe I have the same problem listed. I run OOo 2.2 and MySQL 5.0 with JDBC on XP. I can link up the database to OOo and see tables etc, but when I open a table, it crashes. I am a complete novice, so I am going to ask a stupid question: This issue is reported as "fixed" - something to do with source code jadajada... Is this fix accessible to me and if so, how do I go about it or do I have to wait for 2.2.1? Thanks for the information so far.
To verify you have the same problem, try the (non-official) fix at http://dba.openoffice.org/servlets/ProjectDocumentList?folderID=547&expandFolder=547&folderID=0., if you're brave :). Beware, don't use this in a production environment. The issue is targeted for 2.3, but I'm currently lobbying to get the approval for 2.2.1, so for an official fix you'll have to wait 'til 2.2.1, at least.
Hey presto! I copied the .dll into my OOo programs directory after defeating the Windows "idiot" minder crap that wanted to prevent me from replacing the official dll file and now I can update tables in MySQL just fine! Thank you very much.
*** Issue 75852 has been marked as a duplicate of this issue. ***
got release status meeting's approval for 2.2.1
copied fix into CWS dba221a: connectivity/source/commontools/dbtools2.cxx, 1.20.12.1.4.1
fs-> msc: please verify in CWS dba221a
*** Issue 76487 has been marked as a duplicate of this issue. ***
*** Issue 76528 has been marked as a duplicate of this issue. ***
*** Issue 76555 has been marked as a duplicate of this issue. ***
verified in CWS dba221a find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=OOF680%2Fdba221a
The fix works for me (OOo 2.2, both Win2K with jre 1.6 and Linux with jre 1.5, connecting to Oracle 10g XE with ojdbc14.jar). Thnx, Rainer
Tested with 2.2.1 RC1 and 2.3m_212.