i need to configure oracle 10g with netbeans

Answer1

Example 1:

First you will need the Oracle driver found in the file ojdbc16.jar.

In NetBeans go to the Services tab and select the Databases->Drivers node in the tree. Right-click and select New Driver. Find the jar file above and it should recognize the driver class for you (if not it is oracle.jdbc.OracleDriver).

Then right-click on the Databases tree node and select New Connection. Select the Oracle driver in Driver Name and fill in the connection parameters.

 

Example 2:

Install ojdbc14.jar from the net....Its an oracle driver....

Then go to netbeans..
select windows->services
in the left pane of the netbeans you will find the services tab..
In that click you can find databases....
Expand it...
iside it you can find Drivers tab...
Right click on it and select new driver option
You will find a box...
Press add button
Browse for ojdbc14.jar file and press ok...
Netbeans automatically detects it ass ORacle
Then you can find Oracle in the Drivers-Databases node.....

Then right click on the Oracle and select Connect Using Option...

It will ask for <host><port><sid>

For these information do the following procedures:

Go to the location where Oracle is installed...
Follow this folder link
Oracle -> Product -> 10.2 (Version dependent) -> db_1 -> Network -> Admin

Inside that you can find a file called tnsnames...
Open it with using notepad...

You can find the host name port name....

service_name will be your sid

Then click connect...............


Answered by: siva85     On: 11-Apr-2011


Dear Guest,
Spend a minute to Register in a few simple steps, for complete access to the Social Learning Platform with Community Learning Features and Learning Resources.
If you are part of the Learning Community already, Login now!