This discussion is archived
1 Reply Latest reply: Dec 1, 2012 4:20 AM by peterv6i.blogspot.com RSS

Oracle Enteprise 11g, java procedure, fail with ENUM and @anotation tags...

peterv6i.blogspot.com Newbie
Currently Being Moderated
Hello,
I have a problem with java sources on database (java stored procedures)..
My sources uses anotation and Enumerator...

When i try to load java sources to my db with loadjava I get some errors like:

----------------------
loading : source INSURANCE2.org/mozilla/universalchardet/Constants
Error while determining classes contained in org/mozilla/universalchardet/prober/Big5Prober.java
Exception oracle.aurora.sqljdecl.ParseException: Lexical error at line 75, column 5. Encountered: "@" (64), after : ""
creating : INSURANCE2.org/mozilla/universalchardet/prober/Big5Prober.java
Error while determining classes contained in org/mozilla/universalchardet/prober/CharsetProber.java
Exception oracle.aurora.sqljdecl.ParseException: Encountered "{" at line 63, column 5.
Was expecting one of:
"=" ...
"[" ...
";" ...
"," ...
"(" ...
---------------------

here is some sample of my source compiled with JDK 1.5.0_00
public abstract class CharsetProber
{
    ////////////////////////////////////////////////////////////////
    // constants
    ////////////////////////////////////////////////////////////////
    public static final float   SHORTCUT_THRESHOLD = 0.95f;
    public static final int     ASCII_A = 0x61; // 'a'
    public static final int     ASCII_Z = 0x7A; // 'z'
    public static final int     ASCII_A_CAPITAL = 0x41; // 'A'
    public static final int     ASCII_Z_CAPITAL = 0x5A; // 'Z'
    public static final int     ASCII_LT = 0x3C; // '<'
    public static final int     ASCII_GT = 0x3E; // '>'
    public static final int     ASCII_SP = 0x20; // ' '

    
    ////////////////////////////////////////////////////////////////
    // inner types
    ////////////////////////////////////////////////////////////////
    public enum ProbingState
    {
        DETECTING,
        FOUND_IT,
        NOT_ME
    }

    
    ////////////////////////////////////////////////////////////////
    // methods
    ////////////////////////////////////////////////////////////////
    public CharsetProber()
    {}
    
    public abstract String getCharSetName();
    public abstract ProbingState handleData(final byte[] buf, int offset, int length);
    public abstract ProbingState getState();
    public abstract void reset();
    public abstract float getConfidence();
    public abstract void setOption();
On my database I think (correct me if not) I have java 1.5.0_10
  select f_vrni_parameter('java.version') from dual

CREATE OR REPLACE function INSURANCE2.f_vrni_parameter(p_vhodni in varchar2) return varchar2 as language java name  'java.lang.System.getProperty(java.lang.String) return java.lang.String';
What I'am doing wrong or what is the right way to upload java source or classes on db? (i will try to upload compiler classes with jdk 1.5.0)

thank you

Legend

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