Issue 124817 - Does not recognize the mysql-connector-x.x.x-java-bin.jar file
Summary: Does not recognize the mysql-connector-x.x.x-java-bin.jar file
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.1.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2014-05-04 21:38 UTC by OOProbs
Modified: 2014-05-11 05:41 UTC (History)
1 user (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 OOProbs 2014-05-04 21:38:18 UTC 
The mysql-connector-x.x.x-java-bin.jar file is not being recognized.  Using Tools > Options > OpenOffice > Java > Add, and navigating to the folder where the file exists, it does not recognize that it is there and, thus, will not allow for a JDBC connection to occur (since it is requesting the javaruntime environment -- which it doesn't recognize).

Unable to find literature in this regard.

The closest thing was "The mysql-connector-x.x.x-java-bin.jar file should then appear in the list of Assigned folders and Archives. Click on OK to close the dialog."  But, when it doesn't (though it's there), what should be done?

The file was downloaded from <http://dev.mysql.com/downloads/connector/j/>.  Only one option for download is available.
Comment 1 Edwin Sharp 2014-05-05 06:24:51 UTC 
What is your operating system?
What is the folder where the file exists?
Comment 2 OOProbs 2014-05-08 23:46:14 UTC 
(In reply to Edwin Sharp from comment #1)
> What is your operating system?
> What is the folder where the file exists?

OS: Win 8.1
Folder: Program Files (x86) > MySQL > MySQL Connector J
Comment 3 Ariel Constenla-Haile 2014-05-11 05:41:12 UTC 
(In reply to OOProbs from comment #0)
> The mysql-connector-x.x.x-java-bin.jar file is not being recognized.  Using
> Tools > Options > OpenOffice > Java > Add, and navigating to the folder
> where the file exists, it does not recognize that it is there and, thus,
> will not allow for a JDBC connection to occur (since it is requesting the
> javaruntime environment -- which it doesn't recognize).

If there is no JRE selected on Tools - Options - OpenOffice - Java, then the application may not allow you to add the MySQL Connector J.

Is there a JRE selected?
Note that OpenOffice is a 32 bit application on Windows, it needs a 32 bit JRE.

And by the way, did you try the Native connector? (no Java needed), see 
http://extensions.openoffice.org/en/project/mysql-driver-apache-openoffice
https://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/wiki/Downloads