| loading java classes to Oracle [message #91595] |
Wed, 04 December 2002 05:04  |
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 #91801 is a reply to message #91602] |
Tue, 25 February 2003 00:01  |
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
|
|
|
|
|
|
|
|
|
|
| Re: loading java classes to Oracle [message #261169 is a reply to message #92548] |
Wed, 22 August 2007 01:37 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
