Apache OpenOffice (AOO) Bugzilla – Issue 13753
Cannot connect with JDBC
Last modified: 2007-02-05 04:33:50 UTC
I am trying to create a JDBC connection to a mysql database. I have been able to make the connection using both the mysql command line tool and a simple java program which uses jdbc. Whenever I attempt a connection OO complains that no connection could be established, please check the username and password. The more button reveals information that the connection could not be established and an error with message 'No Java installed!' and a SQL Status : S1000. This is with JDBC driver class = "com.mysql.jdbc.Driver" URL = "jdbc:mysql://127.0.0.1:3306/mysql" I have double checked Java is enabled in the Options and that the classpath points to the jar containing the driver. If I rerun the installer, it acts like nothing needs to be added for the JVM (presumably because the OS already has it?) thanks, Peter
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