Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Cannot connect with JDBC | ||||||
---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | peternsteinmetz <peter> | ||||
Component: | code | Assignee: | issues@porting <issues> | ||||
Status: | CLOSED NOT_AN_OOO_ISSUE | QA Contact: | issues@dba <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | haxwell, issues, shaunmcdonald131 | ||||
Version: | OOo 1.0.1 | Keywords: | oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | Mac | ||||||
OS: | Mac OS X, all | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
peternsteinmetz
2003-04-23 18:29:05 UTC
change subcomponent to 'none' I have even tried downloading and installing the JDBC module for MySQL from http://dev.mysql.com/ downloads/connector/j/3.0.html But still have th mentioned problem with OOo 1.1.0, sometimes OOo crashes, with an irrecoverable error. assigning to QA reassign to issues@porting.openoffice.org because it's a Mac issue. Added oooqa keyword. Quite frankly I didn't look at this issue when it was first written, because I know nothing about JDBC, and not much about MySQL. Peter, could you please provide very simple and complete step by step instructions, assuming I know nothing, so I can at least verify the problem. It might be helpful to attach a sample MySQL database, and any other required pieces. When using the JDBC module for MySQL from http://dev.mysql.com/downloads/connector/j/3.0.html what should the JDBC class be. I think it should be different from "com.mysql.jdbc.Driver" I have tried to access the MySQL database on my iBook from OOo 1.1.2 on Windows XP, I get the same error messages as mentioned before. Java is installed. This is no longer an issue. I will attach the steps of how to do this in the near future. OK, thanks. Created attachment 18490 [details]
How to connect to MySQL database server from OOo
As this is no longer an issue, should it be closed? Perhaps the attached document needs to be put somewhere on the website, or checked into CVS, so it doesn't get lost. I haven't read the document yet. Can we leave this issue open for the moment? If you wish. As this is no longer an issue, it should be removed from the Unconfirmed list. The attached documents will still be in place if anyone needs to access them, and the issue will still be able to be searched on once it is closed. No real purpose is served leaving it Unconfirmed. To that end, Resolving this issue Fixed. There are still issues with using JDBC to connect to MySQL remote databases. Will connect other issues to this one. James Mckenzie Correction: This issue is resolved as it is possible to connect to a local MySQL database using JDBC. The problem only affects remoted connections. Closing issue as resolved by vendor. James McKenzie Problem was with the JDBC driver supplied by MySQL and OpenOffice.org interaction. MySQL JDBC 3.1.12 or 5.x works. James McKenzie Closing issue. James McKenzie |