Forum Stats

  • 3,757,022 Users
  • 2,251,184 Discussions
  • 7,869,692 Comments

Discussions

How to install NetBeans with Oracle database

ac.arijit
ac.arijit Member Posts: 53
edited Mar 29, 2016 8:01AM in NetBeans

Hi,

I recently did the following tasks, and got messed up with the installation

1. Installed Oracle database 10g Enterprise Ediition in my D: drive on Windows 7.

2. Checked for the database to be running fine with SqlPlus. Yes!! It was working fine.

3. Installed the Oracle Developer Suite 10g, in the same location (under D: drive), and opened the Forms Builder, JDeveloper, Reports Builder to see whether it properly connects to the database or not. Yes!! It was working fine.

4. Installed NetBeans 8.1 with JDK 8 bundle in the same location (under D: drive). But since then, my database isn't working, i'm not able to login with SqlPlus, neither can i open the enterprise manager, nor i can connect to the database from any Developer Suite application.

Lately, i heard that Oracle 10g comes with JDK1.6 and isn't compatible with JDK8. Also, i found that Oracle 11g is compatible with JDK 5/6 and Oracle 12c is with JDK 6/7/8.

Please!! Can anyone make me understand this whole compatibility issues in a simpler way. Also, please suggest me some way i can setup a development environment, where i can have an Oracle database (10g/11g), Oracle Developer Suite (10g/11g) and NetBeans (as latest version as possible). Any help is highly appreciated

Regards,

Ari 

2665100

Answers

  • karianna
    karianna Member Posts: 205 Blue Ribbon
    edited Mar 29, 2016 4:15AM

    So what's likely happened is that when you installed Netbeans with JDK 1.8 (which comes bundled with a JRE), Windows set your default Java to be that 1.8 JRE.

    I'm not familiar with the products you dealing with specifically, but in their startup scripts you need to change the PATH and/or JAVA_HOME to point to the Java 6 that you have installed.

    2665100
  • ac.arijit
    ac.arijit Member Posts: 53
    edited Mar 29, 2016 6:01AM

    Hi,

    Thanks for the response. Yeah you got it right. But i don't know, where the JDK1.6 which comes with Oracle 10g resides. That is, if i change my PATH and/or JAVA_HOME variables explicitly, then where should i make these point to?

    Also, I believe Netbeans 8.1 supports JDK 8 only as of now, so can you suggest which version of Netbeans should i install to make it work with JDK1.6?

    Or, If its possible to override the Oracle bundled JDK 1.6 with the JDK8 that is available with me, then i can run the Netbeans 8.1 over this JDK only. But the question remains, Is it possible to override the bundled-up JDK1.6 of Oracle 10g with a JDK8??

    Regards,

    Ari

  • karianna
    karianna Member Posts: 205 Blue Ribbon
    edited Mar 29, 2016 6:14AM

    Hi Ari,

    Look for a jre subdirectory inside the Oracle 10g directory.  You might also be able to recursively search for java.exe.

    You can then update the startup scripts to point explicitly to that version, best of luck!

  • ac.arijit
    ac.arijit Member Posts: 53
    edited Mar 29, 2016 6:26AM

    Hi,

    Yeah!! I found the JDK and JRE subdirectories under the ORACLE_HOME. But could not understand by this:

    You can then update the startup scripts to point explicitly to that version, best of luck!
    

    Could you please elaborate.

    Regards

    Ari

  • karianna
    karianna Member Posts: 205 Blue Ribbon
    edited Mar 29, 2016 8:01AM

    So there's probably a .bat file or a .ini file or something along those lines that will reference your PATH and/or JAVA_HOME, you need to edit that to point to the internal Java 6 JRE