Matthew Kaiser

minus line 15

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

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>

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

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.

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?

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

Okay, now that Sun has been absorbed by Oracle let's see who knows about both,

Because, I can make Oracle tables, view, trigger, sequences and synonyms with the rest of the Oracle community ,code threads and objects in Java, and I know you can run Java in a Oracle database trigger, but I'm not certified in Oracle enough to know how to solve this problem.

I've been an to run basic example of Java in Oracle trigger, but I'm having a dependency issue with some the basic commons-logging-1.1.jar file while loading it into Oracle via the following command.

$ loadjava -f -v -r -user "<DB_User>/<DB_PASSWORD>" Constant.class

Ought not Oracle have the basics of Java already? Is this a database configuration issue or am I just missing another jar file here?

Help - this ought to be simple

I'm experiencing a com.sun.deploy.net.JARSigningException on my jna.jar file only when I turn off the local storage of temporary internet files in the Java control panel.

I have signed the jna.jar file for local use, but the exception does not occur when I am storing the jars files locally.
Only when I uncheck the "Keep temporary files on my computer" option under Temporary Files Settings in the Java Control Panel.



That doesn't make sense. Can someone tell me what's going on here?

Thanks

I'm experiencing a com.sun.deploy.net.JARSigningException on my jna.jar file only when I turn off the local storage of temporary internet files in the Java control panel.

I have signed the jna.jar file for local use, but the exception does not occur when I am storing the jars files locally.
Only when I uncheck the "Keep temporary files on my computer" option under Temporary Files Settings in the Java Control Panel.



That doesn't make sense. Can someone tell me what's going on here?

Thanks