Questions tagged [loadjava]

loadjava is a utility application for Oracle databases which uploads Java files using the SQL CREATE JAVA statement to load the Java files into the Oracle database as schema objects.

35 questions
10
votes
2 answers

Where does the system.out.println output go in Oracle Java class?

I have loaded a Java class into Oracle using the loadjava utility. This class has some system.out.println messages. When I execute a method from this class I want to see the the sysout messages. Where can I find these messages?
prabhakar
  • 101
  • 1
  • 1
  • 3
4
votes
0 answers

When does loadjava utility skip a class?

I tried to load Zebra Crossing Bar Code Library in Oracle 12c environment. Most of the class files are created and loaded but there are some that are skipped. What does this skipping mean? Does it mean that loadjava utility didn't process given…
kapiell
  • 697
  • 7
  • 23
4
votes
3 answers

Get java class content from oracle database

Is it possible to get the java .class file from a database? I mean java classes, which was loaded via loadjava tool with -r -s -v -g parameters. How to do this? Edit: I need it in readable form ;)
rzysia
  • 737
  • 1
  • 11
  • 26
3
votes
1 answer

Oracle how to import missing java classes when calling java from plsql

I am trying to gradually write a java function that can take the Oracle XML (BI) Publisher Report (not BI Publisher as used in Business Intelligence but rather XML Publisher used by Oracle Applications) functionality and provide the output of the…
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
3
votes
0 answers

Load Java Class File To Oracle Database

I have some java classes and i want to import these files into oracle database 11gR2 . When i want to use loadjava utility , the error in below is shown : C:\Users\oracle>loadjava -f -v -r -user tree AllData.class Password: ******* arguments:…
saeed.sh
  • 327
  • 1
  • 6
  • 16
3
votes
1 answer

Oracle Java stored librairies won't compile

I'm looking to store Java libraries inside my Oracle database. Note that this is the first time I'm doing that. That library is pd4ml. It is made up of two jars, which contains the compiled classes. pd4ml.jar ss_css2.jar (required by pd4ml.jar) As…
tdtm
  • 334
  • 2
  • 13
2
votes
2 answers

loadjava isn't in Oracle Instant Client 19c - what options do I have?

We have a very old application with a complex installation process that relies on Oracle's loadjava client application. loadjava was included with Oracle's client up until 12c but now that we are upgrading to 19c I don't see it included in any of…
TrojanName
  • 4,853
  • 5
  • 29
  • 41
2
votes
1 answer

Oracle loadjava JSch

I am wondering if using loadjava to load the Java package called JSch.jar in an Oracle database and then loading another .java file, that utilizes the JSch package to connect over SSH, would be able to be executed within an Oracle database through a…
millea9805
  • 23
  • 2
2
votes
1 answer

Unable to load jar using dbms_java.loadjava in Oracle

I need to upload a jar file in Oracle RDBMS using dbms_java.loadjava method. I have granted all the required permission and able to run below function successfully. create or replace function get_java_property(prop in varchar2) return varchar2…
2
votes
1 answer

Getting PLS-00258 when creating PL/SQL wrapper function for Java method

I've got the following Java method (which I've loaded into an Oracle 11g database from its JAR using loadjava) public int GatewayClientPoolHA( String[] DAUTAddresses, int[] DAUTPortArray, String sslKeystorePath, …
J Dor
  • 307
  • 4
  • 13
2
votes
1 answer

Oracle: named java procedures, scoped by schema name?

If I do this: loadjava -u user1 MyClass.class loadjava -u user2 MyClass.class are the two class definitions distinct? i.e., I can install a new version into user2 without affecting the code referenced by user1?
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
2
votes
1 answer

Couldn't run loadjava on user schema to load dbwsclientws.jar dbwsclientdb102.jar

I am trying to load oracle webservice client jars to my schema. I did set the PATH to inlcude: /u01/app/oracle/product/10.2.0/db_1/bin When I try to run loadjava as "loadjava -u myschema/myscehmapwd -r -v -f -genmissing dbwsclientws.jar…
padmaja
  • 21
  • 3
2
votes
3 answers

ORA-29534: referenced object cannot be resolved (Loadjava) error

I apologize if this has been answered before but Ii'm stuck with this problem. Here it goes: I have a Java program the creates an Excel workbook and writes data to it, the Java program works fine, I'm trying to import the program into Oracle using…
user188606
  • 23
  • 1
  • 5
1
vote
0 answers

loadjava Tool causing : ORA-29532: Cannot instantiate class: weblogic.jndi.WLInitialContextFactory

After hours of exhaustive exploration and Oracle Docs and support pages we were unable to solve this issue. Utility: loadjava Action: Trying to load a .jar file using loadjava and call Java Class using PL/SQL Api. This java class simply adds a value…
Aj Tula
  • 11
  • 1
1
vote
1 answer

How to upload jar using `dbms_java.loadjava` from remote system in oracle

I need to upload a jar file in the Oracle database using dbms_java.loadjava from a remote system. I have tried call dbms_java.loadjava('–proxy -Dhttp.proxyHost=remote_system_ip -Dhttp.proxyPort=22 file:///home/abc.jar'); Its returning Call…
Tajinder
  • 2,248
  • 4
  • 33
  • 54
1
2 3