Bug 215554 – Can't connect to MySQL using JDBC

Bugzilla will be upgraded to version 5.0 on a still to be determined date in the near future. The original upgrade date has been delayed.

Bug 215554 - Can't connect to MySQL using JDBC

Summary:	Can't connect to MySQL using JDBC

Status:	CLOSED NOTABUG

Aliases:	None

Product:	Fedora
Classification:	Fedora
Component:	openoffice.org (Show other bugs)
Sub Component:
Version:	6
Hardware:	x86_64 Linux

Priority	medium Severity medium
Target Milestone:	---
Target Release:	---
Assigned To:	Caolan McNamara
QA Contact:
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2006-11-14 12:07 EST by Victor Lorenz
Modified:	2007-11-30 17:11 EST (History)
CC List:	0 users

See Also:
Fixed In Version:
Doc Type:	Bug Fix
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2006-11-16 10:54:35 EST
Type:	---
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

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

Groups: None (edit)

Description Victor Lorenz 2006-11-14 12:07:39 EST

Description of problem:
Can't connect to MySQL databases

Version-Release number of selected component (if applicable):

2.0.4 -
How reproducible:

always
Steps to Reproduce:
1.Open openoffice
2.Tools/java
3.set class path to usr/lib64/gcj/mysql-connector-java
4.Open Openoffice database 
5. Attempt connection for MySQL using JDBC
  
Actual results:
test connection fails


Expected results:
Connection


Additional info:
New install of Linux x86_64.  Switched to "Native" version of OpenOffice.
Downloaded latest Java (i386 version) from Sun site. (Note: Openoffice didn't
accept AMD 64 version). Downloaded connector from MySQL site and stuck it in
/usr/java/jrexxx.xx/lib/ext. Connected the first time and I am back in business.
Not sure if this bug or I am doing something wrong with FC 6 version.  Thx

Comment 1 Caolan McNamara 2006-11-14 13:16:15 EST

What do you mean by a "Native" version of OOo ? I'm trying to figure what you
changed between "not working" and "working". 

Do you do all three of...
a) replace the x86_64 64bit OOo with a 32bit OOo (the upstream one, or the 32bit
fedora one) ? 
b) additionally install sun java ?
c) replace mysql-connector-java with one directly downloaded from upstream ?
or just some/none of those changes ?

Comment 2 Victor Lorenz 2006-11-14 14:43:56 EST

Yes, I did all three

a. Removed the openoffice that came with the FC 6 distribution
b. Then, installed the openooffice downloaded from the openoffice site (they
refer to it as "Native" i.e not linked to any particular distribution);  I don't
think they have a x86_64 version.
c. Then, downloaded Java JRE from Sun's site. At first tried the x86_64 version
but it was not accepted by Openoffice (msg. "not a valid JRE").  Then removed
that version and downloaded and installed the i386 Java JRE and it was accepted
by Openoffice as a valid JRE.
d. Downloaded the mysql-connector-java directly from MySQL
e. Did not replace existing mysql-connector-java but added the one I downloaded
as it went into a different directory as per my original comment.
Hope this helps

Comment 3 Caolan McNamara 2006-11-15 04:18:43 EST

So a 32bit OOo with sun java worked, while the x86_64 one with gcj didn't
might be a bit of time until I'm able to set up a mysql server and get this
reproduced

Comment 4 Caolan McNamara 2006-11-16 10:54:35 EST

The correct classpath to use for the bundled fedora (extras) connector should
have been through Select Archive and choose
"/usr/share/java/mysql-connector-java.jar",
not the directory /usr/lib64/gcj/mysql-connector-java

Comment 5 Victor Lorenz 2006-11-17 12:23:29 EST

Made sure the mysql-connector-java was installed and in the dir as noted in Com.
#4. Made the change and still get "The JDBC driver could not be loaded". Note
tried on both FC 6 1386 and FC 6 x86_64 with the same result.

Comment 6 Victor Lorenz 2006-11-17 12:54:18 EST

Ok success. Didn't realize that when I made the class path changes (add new /
delete old) they were not being accepted. As soon as closed calc it reverted to
old (wrong settings) Didn't know that you had to "archive" the class path for it
to be available.  Thx for your help.

Note You need to log in before you can comment on or make changes to this bug.