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).
JDBC Driver Class setup
-
- Posts: 1
- Joined: Thu Jun 17, 2010 8:47 pm
JDBC Driver Class setup
OpenOffice 3.2 on windows 2000
- Hagar Delest
- Moderator
- Posts: 32594
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: JDBC Driver Class setup
Moved to the Base forum.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
- Greengiant224
- Posts: 282
- Joined: Wed Jun 09, 2010 3:50 pm
- Location: All Over The World
Re: JDBC Driver Class setup
Try the following examples:
Good luck.......
Please mark this thread as solved.... If you are happy.
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@localhostXE
jdbc:oracle:thin:user/password@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)