File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Connection to MySQL in OOo

 
Landon Blake
Ranch Hand
Posts: 44
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Landon Blake
Ranch Hand
Posts: 44
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic