OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

OO 3.2.1 Base, Windows, Oracle, JDBC

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
schusr
Newbie
Newbie


Joined: 08 Mar 2006
Posts: 4

PostPosted: Wed Jul 28, 2010 2:21 pm    Post subject: OO 3.2.1 Base, Windows, Oracle, JDBC Reply with quote

Installed OpenOffice 3.2.1 on a Windows 2003 system.

I want to connect to an Oracle instance using JDBC

JRE 1.6.0_20 is installed and used

Add driver via Tools, Options, Java, Class Path, Add Archive, point to ojdbc6.jar

Then File, New, Database, Connect to JDBC

No matter what I put in the JDBC driver class it does not test successfully.

Most common answer is oracle.jdbc.driver.OracleDriver but does not work.
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Wed Jul 28, 2010 2:31 pm    Post subject: Reply with quote

Okay...I'm posting without doing the research myself but are you sure that Oracle supplies all JDBC services through a single .jar file? Some enterprise-level engines require multiple .jar files for all/specific services. Though normally the driver service is one archive file. Otherwise, make sure the 'oracle.jdbc.driver.OracleDriver' syntax is exactly correct...and check for a space at the end of your string and eliminate it if found.
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
schusr
Newbie
Newbie


Joined: 08 Mar 2006
Posts: 4

PostPosted: Thu Jul 29, 2010 7:56 am    Post subject: Reply with quote

Readme suggests the new class name is oracle.jdbc.

Attempting to use the Oracle 11.1.0.7.0 driver that downloads as one file ojdbc6.jar.

Can't believe this is a problem.
Back to top
View user's profile Send private message
schusr
Newbie
Newbie


Joined: 08 Mar 2006
Posts: 4

PostPosted: Thu Jul 29, 2010 8:03 am    Post subject: Reply with quote

Oracle readme with the driver has this code snippet

Connection conn =
new oracle.jdbc.OracleDriver().defaultConnection();

So I assume the correct JDBC driver class name is oracle.jdbc.OracleDriver but that does not work
Back to top
View user's profile Send private message
r4zoli
Super User
Super User


Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary

PostPosted: Thu Jul 29, 2010 9:46 am    Post subject: Reply with quote

I added ojdbc6.jar to the classpath, and it gives:
Code:
oracle.jdbc.driver.OracleDriver
as driver class, and I can test it.

Maybe this helps:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#02_16

http://infolab.stanford.edu/~ullman/fcdb/oracle/or-jdbc.html
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Thu Jul 29, 2010 2:35 pm    Post subject: Re: OO 3.2.1 Base, Windows, Oracle, JDBC Reply with quote

schusr wrote:
I want to connect to an Oracle instance using JDBC

Make sure the Oracle server application is running...?
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group