Re: Oracle database connections
- From: Mark Bole <makbo@xxxxxxxxxxx>
- Date: Thu, 08 Sep 2005 16:02:15 GMT
HansF wrote:
On Tue, 06 Sep 2005 12:35:11 -0400, JTMOBAP interested us by writing:
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.
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
.
- References:
- Oracle database connections
- From: JTMOBAP
- Re: Oracle database connections
- From: HansF
- Oracle database connections
- Prev by Date: JDBC vs Hibernate
- Next by Date: Re: JDBC vs Hibernate
- Previous by thread: Re: Oracle database connections
- Next by thread: Oracle Pooling performance problems with concurrent connections
- Index(es):
Relevant Pages
|
|
