Apache OpenOffice (AOO) Bugzilla – Issue 82222
Can not connect to embedded Base fle and HSQLdb server w/ same configuration
Last modified: 2009-05-05 05:11:02 UTC
The problem has been reported on a number of different XP machines and one user on Suse 10, also. To reproduce the problem. Setup a HSQLdb server. Create a Base file, using JDBC to connect to this server. Attempt to connect and you are told that the driver can not be loaded. Go to the Java section of the program options and add the hsqldb.jar, found in the program/classes directory of the OO.org install into the Class path. The connection to the HSQLdb server will not work. Now open any Base file with an embedded HSQLdb database and attempt to open the tables. Error; java.lang.NullPointerException Turning JDBC logging on to FINER yields this in the log: event no thread date time (class/method:) message 1 00005904 2007-10-02 19:59:52.75 jdbcBridge: connecting to URL 'jdbc:hsqldb:C:\Documents and Settings\HP_Owner\My Documents\swarup_base.odb' 2 00005904 2007-10-02 19:59:52.75 c1: attempting to load driver class org.hsqldb.jdbcDriver 3 00005904 2007-10-02 19:59:52.76 c1: success 4 00005904 2007-10-02 19:59:52.84 c1: JDBC driver did not provide a JDBC connection 5 00005904 2007-10-02 19:59:52.84 SQLException to be thrown: message: 'General error: java.lang.NullPointerException', SQLState: S1000, ErrorCode: -40 6 00005904 2007-10-02 19:59:53.87 c1: shutting down connection
i couldn't access to any embeded HSQL database anymore ... i removed the hsqldb.jar achive from the class path in Options > Java and everything seems to work fine until now (i have access to regular embeded HSQL database)
can reproduce this.
*** Issue 82303 has been marked as a duplicate of this issue. ***
@fs: As discussed offline, committed connectivity/source/drivers/jdbc/JConnection.cxx:1.6.2.1 on CWS dba24c, which pushes the JavaDriverClassPath class loader as context class loader around the JavaDriverClass instance creation. (Prematurely did a cwsadd jvmaccess on that CWS, but in the end had no actual need to commit anything to that module.)
fixed in CWS dba24c 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=SRC680%2Fdba24c
fs-> msc: please verify in CWS dba24c
verified in CWS dba24c 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=SRC680%2Fdba24c
Not fixed in OOo 3.0 RC1. Please re-open.
It works for me on OOO300m6
Okay...that's weird. I tried this a hundred times over the last two days and it never worked; I kept getting errors. Suddenly today it worked. So, I would have to say it's fixed, after all. So, sorry! Keep it closed for now! :-)
tested w/3.1 Rc2 & Dev3.2_m47 closing