Home » Developer & Programmer » JDeveloper, Java & XML » loadjava error
loadjava error [message #366673] Tue, 05 September 2000 17:56 Go to next message
Radhesh Mohandas
Messages: 20
Registered: August 2000
Junior Member
Hello,
Has any one got an idea why this error occurs when I use loadjava. However the loaded function still works.

oracle@yantra arlsw/oracle/tmp> loadjava -u scott/tiger -verbose EchoInput.java

initialization complete
loading : EchoInput
creating : EchoInput
Error while retrieving errors for EchoInput
ORA-00942: table or view does not exist

loadjava: 1 errors
~
The java function and how I published them are included here.

cat EchoInput.java echo_input.sql
public class EchoInput {
public static void main (String[[]] args) {
for (int i = 0; i < args.length; i++)
System.out.println(argsi);
}
}
CREATE OR REPLACE PROCEDURE echo_input (
s1 VARCHAR2,
s2 VARCHAR2,
s3 VARCHAR2)
AS LANGUAGE JAVA
NAME 'EchoInput.main(java.lang.String[[]])';

And I call the function using

SQL> call echo_input('1','2','3');
/
Re: loadjava error [message #366739 is a reply to message #366673] Mon, 20 November 2000 12:59 Go to previous messageGo to next message
Nicholas Gray
Messages: 13
Registered: November 2000
Junior Member
Maybe this reply comes a little late, but I
encountered the same problem today.
(well almost the same .. german version complained
about invalid column name ... however it dumped
the same 'Error while retrieving errors')
Enabled tracing and noticed that what loadjava
was actually trying to do was:
select text from user_errors where name =
dbms_java.shortname('JavaFunction');

recreating JVM via:
@ %orahome%\javavm\install\initjvm.sql
fixed the problem.

try that or find out who is responsible for
creating the user_errors view

Sayonara
Re: loadjava error [message #366742 is a reply to message #366673] Mon, 20 November 2000 13:43 Go to previous messageGo to next message
Nicholas Gray
Messages: 13
Registered: November 2000
Junior Member
btw. found the sql-script that creates the
user_errors view (and prepares.
So you might try this one first (much faster).

@ %orahome%\rdbms\admin\catprc.sql

Rem NAME
Rem CATPRC.SQL
Rem FUNCTION
Rem Creates data dictionary views for types,
stored procedures,
Rem and triggers.
Rem NOTES
Rem Must be run while connected to sys or internal.

Sayonara
Re: loadjava error [message #366746 is a reply to message #366673] Tue, 21 November 2000 17:09 Go to previous message
T. Nguyen
Messages: 5
Registered: November 2000
Junior Member
Hi,

Anyone sees this error, when using loadjava

C:\>loadjava -u scott/tiger@mysys:1521:orcl -v C:\hello.java
SQl Error while connecting with thin driver to mysys:1521:orcl: Io exception: The Network Adapter could not establish the connection
could not open connection
loadjava: 2 errors

The oracle server is running, and I can connect to it.

Please let me know, thanks
T. Nguyen
Previous Topic: JAVA OBJECT STORAGE
Next Topic: how can a java stored procedure return a (+ 100K) String
Goto Forum:
  


Current Time: Sat Jul 31 17:32:19 CDT 2021