This discussion is archived
2 Replies Latest reply: Sep 30, 2012 11:55 PM by 959916 RSS

Load JAVA error: SQL Error while connecting with oci8 driver

959916 Newbie
Currently Being Moderated
Hi,
When I am trying to upload the JAVA in to DB using loadjava command am getting the below error.

SQL Error while connecting with oci8 driver to default database: Closed Connection
exiting : could not open connection

I use the below command to upload
loadjava -user apps/password -oci8 -resolve CreateFolder.class
Kindly help me to solve this issue.

Thanks,
  • 1. Re: Load JAVA error: SQL Error while connecting with oci8 driver
    rp0428 Guru
    Currently Being Moderated
    >
    When I am trying to upload the JAVA in to DB using loadjava command am getting the below error.

    SQL Error while connecting with oci8 driver to default database: Closed Connection
    exiting : could not open connection

    loadjava -user apps/password -oci8 -resolve CreateFolder.class
    >
    Specify the database you are trying to connect to in the url.

    See the 'loadjava' section of chap 11 'Schema Objects and Oracle JVM Utilities' in the Java Developer's Guide
    http://docs.oracle.com/cd/B28359_01/java.111/b31225/cheleven.htm

    What is the 4 digit Oracle version? Are you running the loadjava command on the DB server or on a client machine?

    Can you connect as user apps/password via sql*plus?
  • 2. Re: Load JAVA error: SQL Error while connecting with oci8 driver
    959916 Newbie
    Currently Being Moderated
    Hi,

    Thanks for your help,now its working fine.

    I installed the loadjava.exe from ORACLE_HOME\bin\loadjava.exe and then used the force upload with the below command and it uploaded successfully.

    loadjava -force -user apps/XXXX@DEVT -resolve createFolder.class

    Thanks,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points