java stored procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: java stored procedure

  1. #1
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44

    Exclamation

    Hi,
    I got a problem in loading Java stored procedur to database.
    it is giving "java system class not found" error. I am trying to load the fallowing procedure into my local database(scott/tiger)

    import java.util.*;
    public class Dba
    {
    public static void printHello ()
    {
    String prtString="Hello World";
    System.out.println(prtString);
    }
    }

    in the command prompt i have given
    loadjava -u scott/tiger -resolve C:\Dba.java

    but i have encountered with fallowing errors
    1)ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler
    2)ORA-29540: class oracle/aurora/rdbms/DbmsJava does not exist
    Can any body help me please

    Thanks®ards


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Looks like the jserver was not installed or initialized on the instance. So follow the steps to create your java vm.

    Perform the manual installation of JServer by running the following:

    $ORACLE_HOME/javavm/install/initjvm.sql

    Initjvm.sql must be run by the SYS user.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    hi
    instead of uploading we can also write the class files in an oRACLE PROCedure and execute.

    is this a good way???
    regards
    Cheers!
    OraKid.

Posting Permissions

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


Click Here to Expand Forum to Full Width