Issue 77767 - RPT: JDBC driver class fails to load
Summary: RPT: JDBC driver class fails to load
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords: new_implementation, oooqa
Depends on:
Blocks:
 
Reported: 2007-05-24 18:57 UTC by toiler
Modified: 2013-08-07 15:45 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description toiler 2007-05-24 18:57:57 UTC 
OOoVersion: 0.2.0.20070524 Reporting Pre-release
JRE: Sun v. 1.6.0_01
JDBC driver class: com.mysql.jdbc.Driver

The previous snapshot build using the report designer (which installed as 2.3.0)
worked fine with my existing JDBC driver, which connects to a MYSQL database
over an ethernet LAN. This snapshot build fails to connect.  

Attempts to connect to the db result in this error: "The connection to the
datasource 'MyDatasource' could not be established." Testing the class results
in this error: "JDBC Driver Test. The JDBC driver could not be loaded." 

I see that two versions of the JRE are now available on my system, JRE 1.6.0 and
JRE 1.6.0_01. The previous snapshot build (2.3.0) was assigned to 1.6.0, but I
tested it and it works fine using either that JRE or the new one (1.6.0_01).
This new snapshot build (0.2.0.2.0070524) is assigned to JRE 1.6.0_01, but I
tested it and it doesn't work with either the new JRE or the previous one. 

Note: Copying the mysql.jdbc driver to the extension folder within the
installation directory of JRE 1.6.0_01 and/or adding it to a classpath statement
for JRE 1.6.0_01 did not solve the problem.
Comment 1 Frank Schönheit 2007-05-29 19:44:21 UTC 
fs->toiler: can you please test whether the problem is really specific to the
Reporting Pre-Release build? That is, does it also happen in the latest
developer snapshots (http://download.openoffice.org/SRC680/index.html)?
Comment 2 Mechtilde 2007-06-15 12:15:26 UTC 
I think this happens because this version create an own user space.

So you have to look unter "tools -> Options -> OpenOffice.org -> Java -> Class
Path -> Archive add"

There you have to add the path to your java driver version.
Comment 3 ocke.janssen 2007-11-07 08:19:16 UTC 
@toiler: Does it sove your problem when you add the jdbc driver to the classpath
inside OOo as Mechtilde mentioned?
Comment 4 Mechtilde 2008-01-07 22:17:05 UTC 
no response for long time

worksforme since 2.3
Comment 5 Mechtilde 2008-01-07 22:17:33 UTC 
-> closed