Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases 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 Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 44
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31634
    
189

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.


[OCA 8 book] [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: 44
OpenOffice Org is an open source alternative to Microsoft Office developed by Sun Microsystems.

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

Joined: May 26, 2003
Posts: 31634
    
189

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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Connection to MySQL in OOo