Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 03-14-2009, 07:05 AM   #1
Registered: Oct 2006
Posts: 302

Rep: Reputation: 32
How can I connect OpenOffice 3 to Oracle Database?


I'm using Kubuntu 8.04 and now I've installed OpenOffice 3, both in Spanish.

I have oracle client installed and can connect to Oracle databases with clients like tora.

What I try:
- Open Database and select connect to an existing database.
- Select Oracle JDBC.
- Next
- DatabaseName: I put the sid of the database of oracle. (orcl)
Server URL: The name of the server containing the database. It's resolved by a ping. (
Port: 1521
- Oracle JDBC Driver:
But I press the test button, I receive an error: JDBC Driver can't be loaded (really, the message is in spanish).

Whats wrong?

Old 03-15-2009, 02:17 AM   #2
LQ Guru
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

It sounds like it's not finding your Oracle JDBC .jar file(s). Please make sure your Open Office CLASSPATH is set correctly:

'Hope that helps .. PSM
Old 03-16-2009, 05:17 AM   #3
Registered: Oct 2006
Posts: 302

Original Poster
Rep: Reputation: 32

Sorry, I'd selected a wrong which didn't have the oracle jdbc driver.

Now, I've added classes12.jar which has the driver (opened the .jar and looked for the oracle.jdbc.driver.OracleDriver.class) and it works fine.


Last edited by Felipe; 03-16-2009 at 05:19 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Oracle(R) Database Standard Edition One and Oracle Enterprise Linux on HP Set New World Record for Price Performance with TPC-C Benchmark LXer Syndicated Linux News 0 06-12-2007 05:01 PM
Difference between Oracle Server and Oracle Database ganninu Programming 3 02-27-2007 01:06 AM
cannot connect to oracle 10g xe database admin page sparrott Linux - Networking 4 03-20-2006 02:46 PM
connect to Windows Oracle database turbo_acura Linux - Software 1 11-03-2005 12:35 AM
COnnect Oracle Database in Linux by C++ program!! nelnel Linux - Software 4 05-24-2005 10:13 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:48 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration