Results 1 to 7 of 7
  1. #1
    esgol is offline Member
    Join Date
    Dec 2010
    Posts
    29
    Rep Power
    0

    Default 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 )

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,015
    Rep Power
    20

    Default

    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.

  3. #3
    goldest's Avatar
    goldest is offline Senior Member
    Join Date
    Oct 2009
    Location
    Pune, India
    Posts
    469
    Rep Power
    5

    Wink

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

    Refer here: NetBeans-Oracle Connection

    Hope that helps,

    Goldest
    Java Is A Funny Language... Really!
    Click on * and add to member reputation, if you find their advices/solutions effective.

  4. #4
    esgol is offline Member
    Join Date
    Dec 2010
    Posts
    29
    Rep Power
    0

    Default

    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

    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
    Last edited by esgol; 01-05-2011 at 01:32 PM.

  5. #5
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,015
    Rep Power
    20

    Default

    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.

  6. #6
    esgol is offline Member
    Join Date
    Dec 2010
    Posts
    29
    Rep Power
    0

    Default

    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

  7. #7
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,015
    Rep Power
    20

    Default

    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.

Similar Threads

  1. connect to oracle from java
    By ahmadian in forum Advanced Java
    Replies: 7
    Last Post: 05-15-2013, 04:15 PM
  2. cannot connect to oracle DB
    By freddy000 in forum JDBC
    Replies: 9
    Last Post: 12-09-2010, 12:08 PM
  3. Oracle Connect thru register driver
    By chyrl in forum JDBC
    Replies: 5
    Last Post: 05-11-2010, 03:45 PM
  4. NetBeans 6.8 + Oracle 9i
    By Stephen Douglas in forum New To Java
    Replies: 1
    Last Post: 03-19-2010, 07:46 PM
  5. Using JDBC to connect to ORACLE database
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-10-2008, 11:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •