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
ckdoublenecks
 
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.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25071
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:

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.

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
Greengiant224
 
Posts: 185
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 2 guests