How to connect with Oracle XE 10g(10.2.0.1.0) from NetBeans

Hi I instaled Oracle Database Express Edittion (XE) 10g (10.2.0.1.0)

I want to connect a Java programm which is an ATM interface with this database, to manage account movements record and the transactions

I've made a research on google and found this:

1.Oracle uses JDeveloper to connect through a simple wizard process
Can i connect through NetBeans too?

2. to do that i need the proper JDBC driver (for XE 10g (10.2.0.1.0))
is it preinstalled with NetBeans or i have to download the one from oracle?

3.If i download JDeveloper i find only the 11g will it be compatible with the(XE 10g (10.2.0.1.0)) I've installed

4.If someone can tell me where can i find the code for conecting to Oracle XE 10g (10.2.0.1.0) or copy-paste it here :SSS

P.S.
IS IT LESS MESSY WITH MY SQL????!! ( LOL :P )

You need the driver.
XE (I think) comes with it.
Doesn't matter on the db, you need to get hold of the driver, so you'd still have to do this with MySQL.

This is nothing to do with Netbeans anyway, you'd have to do this with almost any other environment.

Here's the driver download page, you should find your one on here.

Here is the Netbeans documentation that might give you some more idea.

Refer here: NetBeans-Oracle Connection

Hope that helps,

Goldest

Oh yes I have found this page already but dont know what to download. For my version of db It has all this stuff :SS

Quote:

---

Oracle Database 10g Release 2 (10.2.0.1.0) JDBC Drivers
JavaDoc (4,383,404 bytes)
README

JDBC Thin for All Platforms
classes12.jar (1,590,491 bytes) - for use with JDK 1.2 and JDK 1.3
classes12_g.jar (2,033,507 bytes) - same as classes12.jar, except that classes were compiled with "javac -g" and contain some tracing information.
classes12dms.jar (1,598,183 bytes) - same as classes12.jar, except that it contains additional code`to support Oracle Dynamic Monitoring Service.
classes12dms_g.jar (2,041,904 bytes) - same as classes12dms.jar except that classes were compiled with "javac -g" and contain some tracing information.
ojdbc14.jar (1,536,979 bytes) - classes for use with JDK 1.4 and 1.5
ojdbc14_g.jar (1,928,714 bytes) - same as ojdbc14.jar, except that classes were compiled with "javac -g" and contain some tracing information.
ojdbc14dms.jar (1,544,468 bytes) - same as ojdbc14.jar, except that it contains additional code`to support Oracle Dynamic Monitoring Service.
ojdbc14dms_g.jar (1,936,765 bytes) - same as ojdbc14dms.jar, except that classes were compiled with "javac -g" and contain some tracing information.
orai18n.jar (1,551,155 bytes) - NLS classes for use with JDK 1.2, 1.3, 1.4, and 1.5. This jar file replaces the old nls_charset jar/zip files.
ons.jar (48,492 bytes) - for use by the pure Java client-side Oracle Notification Services (ONS) deamon.
demo.tar (604,160 bytes) or demo.zip (529,267 bytes) - contains sample JDBC programs.

---

I have NetBeans IDE 6.8

The tutorial from NEtBeans suggests ojdbc6.jar which is not to this list even

What should i download and how do i install? :SS I put the jar files into my NetBeans folders? :SS A specific one? :ss

Hope just that it works for Oracle XE 10.2.0.1.0 too :SS

edit2
hmm seems it need netbeans 7.0. I will download it damned if it isi to make the damned connection one hour earlier and finish this exercise

ojdbc14.jar

You could try ojdbc16, but I don't know if there's any 11g specific stuff in there. I doubt it, but you should be fine with 14.

You mean ojbc6.jar

oh... thanks :S

ojbc6.jar is for 11g release? if so I unistall the 10g and put 11g to coincide with the NetBeans 7 Tutorial and have my peace. Or I wont have problems anyway with 10g and
ojdbc14.jar

How do I install it a driver in jar format?

By putting it into one of the netbeans folders? :SS

Stick with the one you have installed.
Get whichever driver you feel happy with (if you have 6 then use that).

You don't install the driver.
You simply need it to be on the classpath of your application.
There's probably something in Netbeans for adding a library to a project.