Connecting Oracle RDMS to Netbeans

[meetme02ng]

Good day all,

I will like to know the steps involved in connecting my Oracle RDMS to Netbeans, so that i can access its Databases and tables.

Please can anyone help me out?

Alam Ikenna

[emiddio]

i dont remember -- and i didnt know either;

but i dnloaded oracle 11g; installed on windows7; read some docs, netbeans
help, google -- and
with a couple of hrs got things working.

gary

----- Original Message -----
From: "meetme02ng" <address-removed>
To: <address-removed>
Sent: Thursday, February 11, 2010 7:11 AM
Subject: [nbusers] Connecting Oracle RDMS to Netbeans

[Nan Null]

Please let me try.

1) Download the Oracle thin driver.
2) Go to Oracle database, <oracle db>/NETWORK/ADMIN
3) Edit tnsnames.org
4) Copy the stuffs starting with (DESCRIPTION
including the parenthesis
5) Setup the driver with the downloaded Oracle thin driver
6) Using this connection string:

jdbc:oracle:thin:@(DESCRIPTION = .....)

Make sure all the open and close parenthesis's are correct.

Also make sure the user name and password are correct.

For working inside Netbeans, go to Services tab
right click on Databases
Under Driver names, click drop down=> New driver
Driver files, click add, and add all Oracle jars for the thin driver
(usually, just one, ojdbc14.jar for example)
Driver class should be populated automatically
(oracle.jdbc.OracleDriver). Enter a name.

After the driver setup, select Direct URL entry. Select Oracle
driver, enter username, password, and JDBC URL, then you're set to go.



On Thu, Feb 11, 2010 at 2:37 PM, emiddio-verizon <address-removed> wrote:

[meetme02ng]

Thanks very much for the time you took in giving a detailed answer to my question.
Your directions eased off my stresses all this while.

Thanks once more.