File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 29233
    
138

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: 29233
    
138

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
 
Similar Threads
MySQL Beginner Has Problem With Loading JDBC Driver
How to make money from OpenOffice.org plugin ?
Where to start? Web, data & Java
StarOffice or OpenOffice vs MS Office XP
PostgreSQL 8.0?