aspose file tools*
The moose likes JDBC and the fly likes JDBC  Connection to MySQL in OOo Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC  Connection to MySQL in OOo" Watch "JDBC  Connection to MySQL in OOo" New topic
Author

JDBC Connection to MySQL in OOo

Landon Blake
Ranch Hand

Joined: Oct 15, 2004
Posts: 43
I'm having a heck of a time hooking OpenOffice Org to MySQL.

I have the 1.4.2 JRE installed and enabled in OOo.
I have downloaded the latest JDBC driver for MySQL.
I have added the Driver Directories to my Classpath Varaible.
I have downloaded the latest snapshot of OpenOffice Org, 1.9.60.

No matter what I try, I get the "The JBDC Driver Could Not Be Loaded"
error dialog when I test the connection class.

Could I be completely missing a step?

Any suggestions on what I need to tweak?

Thanks,

The Sunburned Surveyor
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30352
    
150

Landon,
I'm just curious, but what is "OpenOffice Org" ? My first thought was that it was a competitor to MS Office, but I don't see how that would relate to connecting to a database.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Landon Blake
Ranch Hand

Joined: Oct 15, 2004
Posts: 43
OpenOffice Org is an open source alternative to Microsoft Office developed by Sun Microsystems.

It can be used to connect to databases.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30352
    
150

Originally posted by Landon Blake:

It can be used to connect to databases.

Interesting!

Does Open Office have it's own classpath? Maybe it is overwriting the operating system one?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JDBC Connection to MySQL in OOo