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
1
vote
6 answers

Confusion over class resolution in Oracle java stored procedures

I'm trying to use a third-party java library within oracle. The library seems compatible with the same 1.4 version of the jvm that our Oracle 10g server hosts, since it runs fine outside of Oracle, so I feel like I should be able to get this to…
Chris Farmer
  • 24,974
  • 34
  • 121
  • 164
1
vote
0 answers

LoadJava : oracle server jar dependencies

When i use the command loadJava of my own jar (to load jar into the database oracle), i need others dependencies* which belong to the server installation of oracle (like javax.resource.jar, javax.transaction.jar, oemlt.jar...). *ORA-29521 :…
Gabriel
  • 139
  • 2
  • 11
1
vote
1 answer

loadjava NullPointerException when trying to load

i am trying to use the loadjava utility in an oracle 11g database, i have all the proper privs, yet i am getting this error: The command: c:\load>loadjava -user ccar_eccar/ccar_eccar@ccar -thin tsakirisd-hp:1521:ccar -verbose *.jar The…
Dtsakiris
  • 11
  • 4
1
vote
1 answer

Oracle 11.2.0.3 - Move Java objects from schema to schema

I'm using Oracle 11.2.0.3 and have existing Java classes loaded to a schema called ABC. I have a requirement to move those classes to a different schema DEF on the same DB instance. The easy way would've been to simply loadjava all the classes to…
Eran
  • 11
  • 1
  • 4
0
votes
2 answers

Moving data between oracle and sql server using Linked server

I have set up Oracle Linked server on Sql Server 2005 box using Oracle provider oledb and its working fine from sql server 2005 to oracle 9i, i.e. When i run distributed query from sql server i get data from oracle server to sql server. Now I don't…
neoryan
0
votes
1 answer

Oracle Loadjava JSch Error Incorrectly Formed Java Binary Class Definition

I am running into an issue trying to load a jar into Oracle. I downloaded the JSch package to code in java from source forge (https://sourceforge.net/projects/jsch/). I then attempted the loadjava command while signed into the database. I got an…
millea9805
  • 23
  • 2
0
votes
1 answer

java.util.ServiceConfigurationError: org.firebirdsql.gds.impl.GDSFactoryPlugin: Error reading configuration file from Java Stored Procedure in Oracle

I loaded with loadjava tool Jaybird-3.0.9-JDK_1.8 JDBC driver and my java class to Oracle database. All classes were resolved. When I run Java Stored Procedure from Oracle first time got error ORA-29532: Java call terminated by uncaught Java…
0
votes
1 answer

Steps For adding Apache Commons Codec into oracle database

I've the Apache common codecs library & I need to invoke that in the Oracle 11 database so I can create a java source that utilize the classes inside it as below. What are the steps to make this library included in the database? **Code need to…
0
votes
0 answers

Oracle 11g Database Missing Loadjava Utility

I read few tutorials regarding how to make Oracle SQL trigger to call Java method as here. Everywhere it is mentioned that there is command line utility called loadjava. I am using windows 10, oracle SQL server 11.2.0. I couldn't find anything…
masiboo
  • 4,537
  • 9
  • 75
  • 136
0
votes
2 answers

java.sql.SQLSyntaxErrorException: ORA-01729: database link name expected while using Java stored procedure

I have created a java stored procedure in Oracle, using query: CREATE OR REPLACE PROCEDURE GETSHEETROWS(I_file_id number, I_sheetNode clob,template_key varchar2 ,wksht_key varchar2 ,wksht_name varchar2 ) AS LANGUAGE JAVA NAME…
Ravi Shankar
  • 277
  • 9
  • 23
0
votes
0 answers

Java class has an INVALID status after loadjava command in oracle

I have a problem with java class which I would like to load into oracle database. There was no any output after using 'loadjava' in windows command line: loadjava -user lrn001/123456@LAND SharedAreaDecoder.class but I verified the status of my java…
Tranceholic
  • 13
  • 1
  • 1
  • 5
0
votes
0 answers

loadjava utility for osx

Is there a loadjava utility for OSX or a way to load my java classes to Oracle database from mac os? I am trying to execute a java stored procedure using eclipse from mac os and I am not able to load my java classes into the Oracle database. This…
cNgamba
  • 111
  • 1
  • 10
0
votes
1 answer

Oracle loadjava error during loading of .jar

I'm trying to load and publish a .jar into my Oracle database with this command: loadjava -schema PIN75 -u username/password -v -resolve -debug BIPExtension.jar but I'm getting this error: arguments: '-u' 'username/***' '-schema' 'PIN75' '-v'…
Juan David
  • 2,676
  • 4
  • 32
  • 42
0
votes
1 answer

Using Kafka Producer inside oracle DB

I am trying to post Messages from Oracle to Kafka broker directly using custom java class for that I uploaded the required library in oracle and calling java function using oracle function/procedure. Basic java function is working fine but function…
Rahul
  • 1
  • 4
0
votes
1 answer

Extract loaded jar into oracle database

There is a jar that was loaded into an oracle database using loadjava command. Is there a way to extract this jar(or the classes) loaded into the database. The database version is 11g.
user2329919
  • 43
  • 1
  • 5