Erro Java + Spring
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á!
Discussão (1)
Carregando comentários...