JDBC Driver Class setup

Discuss the database features
Post Reply
ckdoublenecks
Posts: 1
Joined: Thu Jun 17, 2010 8:47 pm

JDBC Driver Class setup

Post by ckdoublenecks »

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
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: JDBC Driver Class setup

Post by Hagar Delest »

Moved to the Base forum.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Greengiant224
Posts: 282
Joined: Wed Jun 09, 2010 3:50 pm
Location: All Over The World

Re: JDBC Driver Class setup

Post by Greengiant224 »

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

jdbc:oracle:thin:[user/password]@[host][:port]:SID
jdbc:oracle:thin:[user/password]@//[host][:port]/SID

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 127.0.0.1 - 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)

jdbc:oracle:thin:user/password@localhost:1521:XE
jdbc:oracle:thin:user/password@:1521:XE

jdbc:oracle:thin:user/password@//localhost:1521/XE
jdbc:oracle:thin:user/password@//:1521/XE
jdbc:oracle:thin:user/password@//localhost/XE
jdbc:oracle:thin:user/password@///XE



Good luck.......

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

Win 7, Portable AOO 4.1.14, LibreOffice 6.2, 7.4.5 & 7.6.1 (Java 1.7.81 & 1.8.0_281) utilising HSQL 1.8.10 & 2.4.*, MySQL, PostgreSQL, SQLite
+ Blood, Sweat and Tears (Application, Determination and Perseverance)
Post Reply