OpenOffice 3 BASE

[travismc1]

The last two downloads of OOo 3 have given me problems connecting to my MySQL database.

Error1 The connection to the data source "officeDB" could not be established.

Error2 Error code: 1000

The driver class 'com.mysql.jdbc.Driver' could not be loaded.

Error3 Error code: -1

com/mysql/jdbc/Driver

I created this BASE file with version 2.2. I have upgraded at each interval and have had luck with most of the development builds for Version 3. However, 3 release candidate 3 and 3rc4 have given me these errors. The file opens but when I click on a form, I'm asked for my username and password. I type it in, the errors come out. I reinstalled 2.4 back to my machine and I can log in and edit just fine. I have gone into the Tools> Options> OpenOffice.org> Java and made certain that Jave was "seen" by the system. Any thoughts would be helpful.

My machine:
WindowsXP sp3
3.0ghz Pentium D
1gb of ram
MySQL 5.0.45 Locally on my "D" drive
JDBC DRIVER - mysql-connector-java-5.1.6-bin

[r4zoli]

Added JDBC driver to classpath under Tools>Options>OpenOffice.org>Java?

[travismc1]

Yes, my JDBC driver is in the C:\program files\Java.

I went back to Tools>Options>OpenOffice.org>Java
I clicked on Class Path which was showing : C:\program files\Java
This time I decided to click on the ADD ARCHIVE button: this took me to Java file and I saw the JDBC driver as a choice to be clicked on...

Now my database is letting me input data through my form. BUT, my database had a report that in the previous versions was a "phone book." Very little information is shown. I thought it was lost. I went back to the tables and my information is there. The query that I pull the report from is there. It just does not bring the information to the report.

Since this is not the final version, should I leave my reports alone and see if this is fixed?
Has anyone else reported this type of problem?

By the way, thank you, r4zoli!

[cogre]

Hi,

just want to inform, that i have the same problem than you (error 2) and that i did not find any solution up until now. If anybody has an answer i would be very interested in getting it too.

Regards
Corinne

[vlmp]

Same problem here. I upgraded to OO 3 and lost the connection to my networked mysql server. Reset the java class path and still no go.

Jim

[Dyrcona]

I have the full path to the jar file in my Classpath in OO.o and don't have a problem. Have you included the jar file in th classpath?

[cogre]

Hi,
Some more information:

I am using following JRE and Classpath:

JRE: Sun Microsystem 1.6.0-02
Classpath: mysql-connector-java-3.1.12-bin.jar

This was working under Openoffice 2.x

Since i ve changed to Openoffice 3.0: it does not work anymore...
is anyone using some other versions of JRE/Classpath and having no problem?

Corinne

[vlmp]

I found a fix for my situation: more updates were needed

I updated my computers Java and set OOBase to JRE 1.6.0_10
and the class path is now updated to mysql-connector-java-5.1.6-bin.jar

That seemed to do the trick.

[randomname]

Using JRE 1.6.0_07, updating the classpath and restarting did not work until I realized the "quick start" in the system tray kept it alive.

Killed it and it worked upon restart.