java and oracle 11g connectivity

Ashish Parab

i created java front end and i will be using oracle 11 g database.

for connectivity i use jdbc-odbc bridge.

for that i need to create oracle dsn(data source name).

but after creating dsn when i test the connection it throws an exception" ora 12154 tns could resolve.......".

how to go about it?

also please explain type 4 driver. that is pure java driver using socket programming ..

Joe Weinstein-Oracle

You're following some very old examples/lessons. Welcome to this century, and use the Oracle JDBC driver

to talk to the Oracle DBMS, not the jdbc-odbc bridge. Google 'oracle JDBC examples' and 'oracle jdbc driver download'.

Ashish Parab

hey joe , is this a right method ?

Connect to an Oracle database with JDBC - Real's Java How-to

thanks ..

Joe Weinstein-Oracle

Put that next bit of energy into this... Try it.

Unknown

Why not use Oracle's own documentation?

The Java Tutorials has many trails on JDBC, creating connections and working with databases:

http://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html

First, you need to establish a connection with the data source you want to use. A data source can be a DBMS, a legacy file system, or some other source of data with a corresponding JDBC driver. Typically, a JDBC application connects to a target data source using one of two classes:

The trails cover everything from the basics to advanced functionality.

There is also the JDBC Developers guide that goes into detail of all of the features and API.

http://docs.oracle.com/cd/B28359_01/java.111/b31224/toc.htm

Ashish Parab

got what i wanted...managed to establish connectivity using jdbc driver

thanks..  @rp0428

@Joe Weinstein

Unknown

Then please mark the thread ANSWERED.