JDBC Driver Class setup

Discuss the database features

JDBC Driver Class setup

Postby ckdoublenecks » Thu Jun 17, 2010 9:06 pm

I just downloaded OpenOffice 3.2 and in setting up connections:

Data source URL - I have xxxx (my computer's name)\My Documents\h o files(the folder where my database is)

JDBC Driver Class - Oracle:thin:localhost:port:mydatabase_name
( I guess localhost is right,
(port - I haven't a clue)
(I'm pretty sure on this one)

Are these right - and what about the port? Where do I find documentation re. setup?

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
OpenOffice 3.2 on windows 2000
Posts: 1
Joined: Thu Jun 17, 2010 8:47 pm

Re: JDBC Driver Class setup

Postby Hagar Delest » Thu Jul 22, 2010 11:15 pm

Moved to the Base forum.
AOO 4.1.5 on Xubuntu 17.10 (Artful Aardvark) and on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Posts: 27994
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: JDBC Driver Class setup

Postby Greengiant224 » Fri Jul 23, 2010 3:03 pm

Try the following examples:

The Oracle connection URL for the thin client-side driver has the following format:


user - The login user name defined in the Oracle server.

password - The password for the login user.

host - The host name where Oracle server is running.
Default is - the IP address of localhost.

port - The port number where Oracle is listening for connection.
Default is 1521.

SID - System ID of the Oracle server database instance.
SID is a required value. By default, Oracle Database 10g Express
Edition creates one database instance called XE.

JDBC Connection examples: (change details to suit)



Good luck.......

Please mark this thread as solved.... If you are happy.

Linux 2.6.38, KDE 4.9.2, LibreOffice 3.5.* (Java 1.6.0_35) utilising HSQL 1.8.10 & 2.3.*, MySQL, PostgreSQL, SQLite
+ Blood, Sweat and Tears (Application, Determination and Perseverance)
User avatar
Posts: 276
Joined: Wed Jun 09, 2010 3:50 pm
Location: All Over The World

Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests