Erro Java + Spring

[Jefferson Mendes 0]

Pessoa estou testando uma aplicação java e no momento que clico em um botão surge essas mensagens de erro:

 

exception

 

javax.servlet.ServletException: #{clienteMBean.getTitular}: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call sp_consulta_horarios_3(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: A cursor with the name 'contrato_dentista' does not exist.

javax.faces.webapp.FacesServlet.service(FacesServlet.java:256)

com.ericsson.sn.mobilefaces.MobileFacesServletFilter.doFilter(MobileFacesServletFilter.java:96)

 

 

 

 

root cause

 

org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call sp_consulta_horarios_3(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: A cursor with the name 'contrato_dentista' does not exist.

org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:108)

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:927)

org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:960)

org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:369)

org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:343)

org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:166)

br.com.odontosystem.mobile.core.dao.jdbc.support.SpConsultarHorarios.execute(SpConsultarHorarios.java:81)

br.com.odontosystem.mobile.core.dao.jdbc.support.SpConsultarHorarios.executeByRede(SpConsultarHorarios.java:33)

br.com.odontosystem.mobile.core.dao.jdbc.AgendaConsultaJdbcDAO.findHorarios(AgendaConsultaJdbcDAO.java:18)

br.com.odontosystem.mobile.core.service.AgendaConsultaServiceImpl.findHorarios(AgendaConsultaServiceImpl.java:15)

br.com.odontosystem.mobile.web.jsf.mbeans.ClienteMBean.getTitular(ClienteMBean.java:127)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

java.lang.reflect.Method.invoke(Unknown Source)

org.apache.el.parser.AstValue.invoke(AstValue.java:262)

org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)

org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:70)

javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)

com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)

javax.faces.component.UICommand.broadcast(UICommand.java:383)

javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:447)

javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)

com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)

com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)

com.ericsson.sn.mobilefaces.MobileFacesServletFilter.doFilter(MobileFacesServletFilter.java:96)

 

 

A Stored Procedure está criada no banco, alguem tem alguma sugestão sobre esse problema?

 

Agradeço desde já!

[EduFranzoni 0]

verifica a procedure que você está chamando do banco, veja se realmente existe e a quantidade de parametros está certa. att