Home » Developer & Programmer » JDeveloper, Java & XML » loading java classes to Oracle
loading java classes to Oracle [message #91595] Wed, 04 December 2002 05:04 Go to next message
Prabhuraj
Messages: 1
Registered: December 2002
Junior Member
I am loading the java classes related to MQSeries to Oracle by using loadjava. Many classes are faliling with the error ORA-29534 - class could not be resolved. Where can be the probelem? I am giving the paths properly. Please help urgently.

Prabhu
Re: loading java classes to Oracle [message #91602 is a reply to message #91595] Fri, 06 December 2002 09:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first check your CLASSPATH (since only a few of the classes are failing, this should be FINE).
if you are using a -r option in loadjava OMIT it and try again.

Re: loading java classes to Oracle [message #91801 is a reply to message #91602] Tue, 25 February 2003 00:01 Go to previous messageGo to next message
Sreenath.V
Messages: 1
Registered: February 2003
Junior Member
Hi I am using WorkFlow 2.6.2 Standalone for Oracle 9i DB.
Well i wrote a java class which will act as External java function for my
activity defined in workflow builder and is availabe in the workflow engine.
My problem is when i use loadjava to upload my java function to workflow
database it is giving me an error shown below:
********************************************************************************
C:WorkFlowProject1srcwf>loadjava -u
owf_mgr/owf_mgr@10.99.25.223:1521:oracle
db -v -r -t CloseActivity.java
arguments: '-u' 'owf_mgr/owf_mgr@10.99.25.223:1521:oracledb' '-v' '-r' '-t'
'Clo
seActivity.java'
creating : source wf/CloseActivity
loading : source wf/CloseActivity
creating : wf/CloseActivity
resolving: source wf/CloseActivity
errors : source wf/CloseActivity
ORA-29534: referenced object OWF_MGR.oracle/apps/fnd/wf/WFContext could not
be resolved
The following operations failed
source wf/CloseActivity: resolution
exiting : Failures occurred during processing
********************************************************************************
MY JAVA FUNCTION goes here...............
package wf;
import java.io.*;
import java.sql.*;
import oracle.jdbc.*;
import oracle.apps.fnd.common.*;
import oracle.apps.fnd.wf.engine.*;
import oracle.apps.fnd.wf.*;
abstract class CloseActivity extends oracle.apps.fnd.wf.WFFunctionAPI {
public boolean execute(WFContext pWCtx){
ErrorStack es = pWCtx.getWFErrorStack();
Connection conn = null;
try {
if(funcMode.equalsIgnoreCase("RUN")) {
conn = DriverManager.getConnection("jdbc:default:connection:");
conn.setAutoCommit(false);
PreparedStatement ps = conn.prepareStatement("update CRS_CMPLNT set
STATUS='Y' where PROCESS_ID = ?");
ps.setString(1,itemKey);
ps.executeUpdate();
ps.close();
conn.commit();
}
}catch (Exception e) {
try {
if(conn != null)
conn.rollback();
}catch(Exception ex){}
es.addMessage("WF","WF_FN_ERROR");
es.addToken("MODULE",this.getClass().getName());
es.addToken("ITEMTYPE",itemType);
es.addToken("ITEMKEY",itemKey);
es.addToken("ACTID",actID.toString());
es.addToken("FUNCMODE",funcMode);
es.addToken("ERRMESSAGE",e.getMessage());
Text continued in next action...

24-FEB-03 17:40:14

Text continued from previous action...

return false;
}finally{
try { if(conn != null) conn.close(); }catch(Exception e){}
}
return true;
}
}
********************************************************************************
please resolve the same as early as possible as we are stuck here !
Also tell me if my java function uses other java classes which are available in
myjar.jar how do i upload the same, if there is a way tell me the steps. Tell
me how to set classpath for workflow.
regards
Sreenath.V
loading java classes to Oracle [message #91909 is a reply to message #91801] Mon, 04 August 2003 17:11 Go to previous messageGo to next message
Luis Garro
Messages: 2
Registered: August 2003
Junior Member
Did you find out how to solve this situation?
loading java classes to Oracle? [message #91910 is a reply to message #91602] Mon, 04 August 2003 17:13 Go to previous messageGo to next message
Luis Garro
Messages: 2
Registered: August 2003
Junior Member
Did you find out how to solve this situation??
Re: loading java classes to Oracle [message #92548 is a reply to message #91909] Sat, 11 September 2004 04:06 Go to previous messageGo to next message
kundan
Messages: 5
Registered: August 2001
Junior Member
loadjava -user username/pwd@dbhoststring c:k.class

by using this utitility we can upload a java file into database
Re: loading java classes to Oracle [message #261169 is a reply to message #92548] Wed, 22 August 2007 01:37 Go to previous message
gaurav_think
Messages: 1
Registered: August 2007
Junior Member
No it will not work.

If you dont use -resolve option with the loadjava utility, it will not show the errors.

Now use the following query in database:

select * from all_objects where status='INVALID'

you will see you file in the output.

It means there is some problem in loading of the file.

if you have to load the jar file then it would not be possible because of the following reasons:

Java classes "javax/resource/spi/*" java are not provided by Oracle.

If your application vendor (IBM) has tested the application on Oracle release 9.2, they should be able to supply you with all the necessary classes, or tell you where to obtain them.

Solution
1) Ask your third party application support for those referenced java classes (classes "javax/resource/spi/*").

2) The MQ classes were referencing another classes but they are not present in your database. Load those missed java classes first in order to resolve the Invalid MQ java classes.


Regards
Gaurav
Previous Topic: How can I call JSP Page through HTML?
Next Topic: use of javascript:window.open to call reports
Goto Forum:
  


Current Time: Wed Dec 07 06:52:33 CST 2016

Total time taken to generate the page: 0.13780 seconds