Loadjava and user_objects table

[Matthew Kaiser]

I'm loading a vendor's jar file in oracle with loadjava with the -v -f -r flags and the classes I need and I see them either getting resolved or skipped:

c:\loadjava -r -f -v -genmissing -u "uid/pwd@mydbatrain" ekahau-engine-sdk.jar
...
resolving: class com/ekahau/common/sdk/EConnection
skipping : class com/ekahau/common/sdk/EErrorCodes
skipping : class com/ekahau/common/sdk/EException
...
Classes Loaded: 114
Resources Loaded: 1
Sources Loaded: 0
Published Interfaces: 0
Classes generated: 0
Classes skipped: 0
Synonyms Created: 0
Errors: 0

but when I query user_objects to see if EConnection is in there,

SQL> column object_name format a30
SQL> column object_type format a20
SQL> select object_name,object_type, status from user_objects where object_name like '%ekahau%';

OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ -------------------- -------
com/ekahau/common/sdk/EMsg JAVA CLASS VALID
com/ekahau/common/sdk/IMsg JAVA CLASS VALID
com/ekahau/engine/sdk/Asset JAVA CLASS VALID
com/ekahau/engine/sdk/Device JAVA CLASS VALID
com/ekahau/engine/sdk/Event JAVA CLASS VALID
com/ekahau/engine/sdk/Location JAVA CLASS VALID
com/ekahau/engine/sdk/Model JAVA CLASS VALID
com/ekahau/engine/sdk/ModelMap JAVA CLASS VALID
com/ekahau/engine/sdk/TagMenu JAVA CLASS VALID

9 rows selected.

SQL>

it's not there -
can anyone help an oracle noob?

Matthew

[Fatih Keles]

Hi Mathew,

Something like this will show your java classes

select * from all_objects where object_type like 'JAVA%' and dbms_java.longname(object_name) like '%com/ekahau/common/sdk%'

[Matthew Kaiser]

Okay, I found the class in all_objects.

But, why can't I find it in user_objects and why can't Oracle's jvm see it?
And when I run my routine it can't find the class (after figuring out how to get java errors to show up in the first place):

SQL> call java_contact_t4(801);

Call completed.

SQL> set serveroutput on
SQL> exec dbms_java.set_output(10000);

PL/SQL procedure successfully completed.

SQL> call java_contact_t4(801);
got an error
java.lang.NoClassDefFoundError
        at ThrowAnError.testEkahau(ThrowAnError:13)

Call completed.

SQL>

My entire code is the following:

  //
  // Required class libraries.
  import java.sql.*;
  import oracle.jdbc.driver.*;
  import com.ekahau.common.sdk.*;
  import com.ekahau.engine.sdk.*;
 
  // Define class.
  public class ThrowAnError {
 
    public static void testEkahau(Integer memberID) throws Exception {
	  try {
	    EConnection mEngineConnection = new EConnection("x.x.x.x",xxxx);
  	  } catch (Throwable e) {
		  System.out.println("got an error");
		  e.printStackTrace();
	  }
    }
  }

I've verfied all the classes are loaded, all the jar files are resolved and valid. Is there something else I'm missing?

[Fatih Keles]

Good you have loaded your java classes. Why you can't see under user_objects view? Because you don't own them. What you see as owner in all_objects for your classes? That is the owner.

While dealing with java classes within database you have to keep it simple. Let us re-check what you have done so far.

1) loaded your jar file with loadjava command line utility tool.

2) Verified that your classes are loaded

3) created a java source to use the third party java classes as follows
create or replace and compile java source named xxsmthjava as package xxsmth import <necessary classes> public class Xxsmth{ public static void doSmth(int id){ //do smth } }

4) Created a pl/sql wrapper procedure to invoke your own java class as
create or replace procedure xxdosmth (p_id in number) as
language java name 'xxsmth.Xxsmth.doSmth(int id)';

5) test it
declare
begin
xxdosmth(12);
end;

Can you check these steps?

[Matthew Kaiser]

I tried entering the java code via sqlplus as your suggested with the "create or replace and compile" using a package name and curiously enough when I try to create the wrapper

CREATE OR REPLACE PROCEDURE java_contact_t4 (member_id_in NUMBER) 
is language java
name 'throwAnError.ThrowAnError.testEkahau(java.lang.Integer).showMessage()';
/

It reports it can't find the class even though I can query all_objects and see the source and class java objects

I don't seem to understand how oracle resolves the java names.

[Fatih Keles]

Hi Matthew,

The problem is "throwAnError.ThrowAnError.testEkahau(java.lang.Integer).showMessage()". According to your previous java code it should be

ThrowAnError.testEkahau(java.lang.Integer)

which is in <package>.<class name>.<method name>(<method arguments>) format.

[Matthew Kaiser]

okay

CREATE OR REPLACE PROCEDURE java_contact_t4 (member_id_in NUMBER) 
is language java
name 'ThrowAnError.testEkahau(java.lang.Integer)';
/

works (making sure I dropped the previous "ThrowAnError" class in favor of "throwAnError/ThrowAnError" beforehand)

I'm still unclear as to how to call it as it get the following results trying to use it

SQL> declare begin
  2  ThrowAnError.testEkahau(801);
  3  end;
  4  /
ThrowAnError.testEkahau(801);
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'THROWANERROR.TESTEKAHAU' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


SQL> ed
Wrote file afiedt.buf

  1  declare begin
  2  testEkahau(801);
  3* end;
SQL> /
testEkahau(801);
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'TESTEKAHAU' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


SQL> ed
Wrote file afiedt.buf

  1  declare begin
  2  ThrowAnError(801);
  3* end;
SQL> /
ThrowAnError(801);
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'THROWANERROR' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


SQL>

the code (to recap) being

package throwAnError;

  // Required class libraries.
  import java.sql.*;
  import oracle.jdbc.driver.*;
  import com.ekahau.common.sdk.*;
  import com.ekahau.engine.sdk.*;
 
  // Define class.
  public class ThrowAnError {
 
     public static void testEkahau(Integer memberID) throws Exception {
	try {
	  EConnection mEngineConnection = new EConnection("10.25.10.5",8550);
20from%20Axium-Oracle");
	} catch (Throwable e) {
		System.out.println("got an error");
		e.printStackTrace();
	}
    }
  }

i'm still missing the proper syntax

[Fatih Keles]

Since you created the pl/sql procedure java_contact_t4, now you can use it to invoke your java code.

call java_contact_t4(801);

[Matthew Kaiser]

I'm afraid not:

SQL> call java_contact_t4(801);
call java_contact_t4(801)
     *
ERROR at line 1:
ORA-29540: class ThrowAnError does not exist

SQL>

[Fatih Keles]

Is your java class in a package? Can you just put exact java source here?

[Matthew Kaiser]

yep, already did,
The exact code is as above in the Tuesday, August 09, 2011 14:53:36 post

[Matthew Kaiser]

minus line 15

[Fatih Keles]

create or replace procedure java_contact_t4(p_id in number) as language java name 'throwAnError.ThrowAnError.testEkahau(java.lang.Integer)';