Oracle database connections

Thread view:

JTMOBAP - 06 Sep 2005 17:35 GMT

I am testing out Oracle 10g. I have created the database, but I can't seem
to set up any driver for odbc. I only know how to set up access db. Does
anybody know how to create a connection to an oracle database from java?

Reply to this Message

HansF - 06 Sep 2005 17:40 GMT

> I am testing out Oracle 10g. I have created the database, but I can't seem
> to set up any driver for odbc. I only know how to set up access db. Does
> anybody know how to create a connection to an oracle database from java?

Oracle has a wonderful document online at http://docs.oracle.com called
the "JDBC Developer's Guide and Reference". That document not only tells
you how to set up and connect with the various drivers, it even discusses
why you want to chose one ddriver over the others in certain situations.
It's also got examples and test programs.

Signature

Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

Reply to this Message

Mark Bole - 08 Sep 2005 17:02 GMT

>>I am testing out Oracle 10g. I have created the database, but I can't seem
>>to set up any driver for odbc. I only know how to set up access db. Does
[quoted text clipped - 5 lines]
> why you want to chose one ddriver over the others in certain situations.
> It's also got examples and test programs.

And as you read the documentation, you might also want to figure out if
you are trying to set up an ODBC connection from MS Access to Oracle, or
a JDBC connection from Java to Oracle. They are two completely
different, separate things. (Unless you are talking Type 1 JDBC driver,
a JDBC-ODBC bridge...). Setting up an ODBC data source using the
Windows control panel (admin tools) and using in Access is pretty
straightforward and requires no programming.

The "Heterogeneous Connectivity Administrator's Guide" also found at the
Oracle site has some further information on this topic as well.

-Mark Bole

Reply to this Message

Oracle database connections

Free Magazines