Hi, Im using Jdeveloper 10.1.3.4
My situation: Im trying to call a stored procedure from a commandbutton.
So i have:
a command button with this code:
<af:panelLabelAndMessage id="Module3ControlProcedurePlm">
<af:commandButton id="Module3ControlProcedure" textAndAccessKey="Procedure"
actionListener="#{ProcBtn.Proc_action}">
</af:commandButton>
</af:panelLabelAndMessage>
so it calls a managed bean called "ProcBtn". This managed bean references to class Module3AppModuleImpl by "Request"
I also have a Method calling the stored procedure at the application module implementation level:
CODE:
public void callProc1 (String ename,
int empno)
{
PreparedStatement plsqlBlock = null;
String statement = "BEGIN p_proc1(:1,:2); END;";
plsqlBlock = getDBTransaction().createPreparedStatement(statement,0);
try
{
plsqlBlock.setString(1,ename);
plsqlBlock.setInt(2,empno);
plsqlBlock.execute();
}
catch (SQLException sqlException)
{
throw new SQLStmtException(CSMessageBundle.class,
CSMessageBundle.EXC_SQL_EXECUTE_COMMAND,
statement,
sqlException);
}
finally
{
try
{
plsqlBlock.close();
}
catch (SQLException e)
{
// We don't really care if this fails, so just print to the console
e.printStackTrace();
}
}
}
So i call this method from the command button action listener :
public void Proc_action(ActionEvent actionEvent)
{
// Add event code here...
callProc1("asdf",9);
}
and i get this error when button clicked:
java.lang.NoSuchMethodError: javax.faces.event.ActionEvent.<init>(Ljavax/faces/component/UIComponent;)V
the import im using on the appmodule impl is javax.faces.event.ActionEvent...
it would be nice to use some help here :)
EDIT: Well i manage to find out that the problem is when calling the action method of the button... here is the entire error
java.lang.NoSuchMethodError: javax.faces.event.ActionEvent.<init>(Ljavax/faces/component/UIComponent;)V at oracle.adfinternal.view.faces.renderkit.uix.CommandRenderer.decode(CommandRenderer.java:45) at oracle.adf.view.faces.component.UIXComponentBase.__rendererDecode(UIXComponentBase.java:945) at oracle.adf.view.faces.component.UIXComponentBase.decode(UIXComponentBase.java:577) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:676) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXForm.processDecodes(UIXForm.java:53) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildrenImpl(UIXComponentBase.java:818) at oracle.adf.view.faces.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:803) at oracle.adf.view.faces.component.UIXComponentBase.processDecodes(UIXComponentBase.java:673) at javax.faces.component.UIComponentBase.processDecodes(UIComponentBase.java:900) at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:326) at com.sun.faces.lifecycle.ApplyRequestValuesPhase.execute(ApplyRequestValuesPhase.java:99) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:110) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:213) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:162) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:233) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:202) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:123) at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)
Edited by: Cohen on 05-oct-2009 11:15