Issue 82222 - Can not connect to embedded Base fle and HSQLdb server w/ same configuration
Summary: Can not connect to embedded Base fle and HSQLdb server w/ same configuration
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: regression
: 82303 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-10-03 16:18 UTC by drewjensen.inbox
Modified: 2009-05-05 05:11 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description drewjensen.inbox 2007-10-03 16:18:26 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
Comment 1 ooofficieux 2007-10-08 15:42:26 UTC
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)
Comment 2 Frank Schönheit 2007-10-09 08:22:36 UTC
can reproduce this.
Comment 3 Frank Schönheit 2007-10-09 08:26:40 UTC
*** Issue 82303 has been marked as a duplicate of this issue. ***
Comment 4 Stephan Bergmann 2007-10-10 15:45:30 UTC
@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.)
Comment 5 Frank Schönheit 2007-10-16 09:15:43 UTC
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
Comment 6 Frank Schönheit 2007-11-05 13:09:28 UTC
fs-> msc: please verify in CWS dba24c
Comment 7 marc.neumann 2007-11-13 08:22:48 UTC
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
Comment 8 steven 2008-09-16 13:15:49 UTC
Not fixed in OOo 3.0 RC1. Please re-open.
Comment 9 r4zoli 2008-09-17 10:21:18 UTC
It works for me on OOO300m6
Comment 10 steven 2008-09-17 14:54:05 UTC
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!  :-)
Comment 11 drewjensen.inbox 2009-05-05 05:11:02 UTC
tested w/3.1 Rc2 & Dev3.2_m47

closing