Hi all,
i'm gettin the following error while executing a Hibernate query:
Code:
Hibernate: select teste0_.PROGRESSIVO_TESTE as col_0_0_, teste0_.VERSIONE as col_1_0_, teste0_.NOME_TESTE as col_2_0_, teste0_.COGNOME_TESTE as col_3_0_, teste0_.DATANASCI_TESTE as col_4_0_, teste0_.CSIRE as col_5_0_, prodotti1_.MSIRE as col_6_0_, polizze2_.POLIZZA_POLIZZE as col_7_0_, polizze2_.DATAEFFE_POLIZZE as col_8_0_, agenzie3_.RAGSOC_AGENZIE as col_9_0_, polizze2_.AGENZIA_POLIZZE as col_10_0_, polizze2_.RAMO_POLIZZE as col_11_0_, polizze2_.CODCOMP_POLIZZE as col_12_0_, polizze2_.NOME_POLIZZE as col_13_0_, polizze2_.COGNOME_POLIZZE as col_14_0_, case when teste0_.NOME_TESTE=polizze2_.NOME_POLIZZE and teste0_.COGNOME_TESTE=polizze2_.COGNOME_POLIZZE then '1' else '0' end as col_15_0_ from TESTE teste0_, PRODOTTI prodotti1_, POLIZZE polizze2_, AGENZIE agenzie3_ where polizze2_.CODCOMP_POLIZZE=prodotti1_.CCOMP and polizze2_.CODSIRE_POLIZZE=prodotti1_.CSIRE and teste0_.CODCOMP_TESTE=polizze2_.CODCOMP_POLIZZE and teste0_.CSIRE=polizze2_.CODSIRE_POLIZZE and teste0_.NORDSIR_TESTE=polizze2_.NORDSIR_POLIZZE and teste0_.DATAEFFE_TESTE=polizze2_.DATAEFFE_POLIZZE and polizze2_.CODCOMP_POLIZZE=agenzie3_.CODCOMP_AGENZIE and polizze2_.AGENZIA_POLIZZE=agenzie3_.CODICE_AGENZIE and (prodotti1_.CSIRE in (select prodottira4_.CSIRE from PRODOTTI_RAMI prodottira4_ where prodottira4_.CCOMP=? and prodottira4_.FLAG_SINISTRI='M' and prodottira4_.WEB_CONSULTAZIONE='S')) and teste0_.NOME_TESTE=? and teste0_.COGNOME_TESTE=? and polizze2_.CODCOMP_POLIZZE=? and agenzie3_.CODICE_AGENZIE=nvl(?, agenzie3_.CODICE_AGENZIE) order by teste0_.COGNOME_TESTE, teste0_.NOME_TESTE, polizze2_.DATAEFFE_POLIZZE, polizze2_.POLIZZA_POLIZZE, 16 desc
- SQL Error: 1465, SQLState: 72000
- ORA-01465: invalid hex number
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select teste0_.PROGRESSIVO_TESTE as col_0_0_, teste0_.VERSIONE as col_1_0_, teste0_.NOME_TESTE as col_2_0_, teste0_.COGNOME_TESTE as col_3_0_, teste0_.DATANASCI_TESTE as col_4_0_, teste0_.CSIRE as col_5_0_, prodotti1_.MSIRE as col_6_0_, polizze2_.POLIZZA_POLIZZE as col_7_0_, polizze2_.DATAEFFE_POLIZZE as col_8_0_, agenzie3_.RAGSOC_AGENZIE as col_9_0_, polizze2_.AGENZIA_POLIZZE as col_10_0_, polizze2_.RAMO_POLIZZE as col_11_0_, polizze2_.CODCOMP_POLIZZE as col_12_0_, polizze2_.NOME_POLIZZE as col_13_0_, polizze2_.COGNOME_POLIZZE as col_14_0_, case when teste0_.NOME_TESTE=polizze2_.NOME_POLIZZE and teste0_.COGNOME_TESTE=polizze2_.COGNOME_POLIZZE then '1' else '0' end as col_15_0_ from TESTE teste0_, PRODOTTI prodotti1_, POLIZZE polizze2_, AGENZIE agenzie3_ where polizze2_.CODCOMP_POLIZZE=prodotti1_.CCOMP and polizze2_.CODSIRE_POLIZZE=prodotti1_.CSIRE and teste0_.CODCOMP_TESTE=polizze2_.CODCOMP_POLIZZE and teste0_.CSIRE=polizze2_.CODSIRE_POLIZZE and teste0_.NORDSIR_TESTE=polizze2_.NORDSIR_POLIZZE and teste0_.DATAEFFE_TESTE=polizze2_.DATAEFFE_POLIZZE and polizze2_.CODCOMP_POLIZZE=agenzie3_.CODCOMP_AGENZIE and polizze2_.AGENZIA_POLIZZE=agenzie3_.CODICE_AGENZIE and (prodotti1_.CSIRE in (select prodottira4_.CSIRE from PRODOTTI_RAMI prodottira4_ where prodottira4_.CCOMP=? and prodottira4_.FLAG_SINISTRI='M' and prodottira4_.WEB_CONSULTAZIONE='S')) and teste0_.NOME_TESTE=? and teste0_.COGNOME_TESTE=? and polizze2_.CODCOMP_POLIZZE=? and agenzie3_.CODICE_AGENZIE=nvl(?, agenzie3_.CODICE_AGENZIE) order by teste0_.COGNOME_TESTE, teste0_.NOME_TESTE, polizze2_.DATAEFFE_POLIZZE, polizze2_.POLIZZA_POLIZZE, 16 desc]; SQL state [72000]; error code [1465]; ORA-01465: invalid hex number
; nested exception is java.sql.SQLException: ORA-01465: invalid hex number
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}hostname:MW7EQSHHL7UBSM
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select teste0_.PROGRESSIVO_TESTE as col_0_0_, teste0_.VERSIONE as col_1_0_, teste0_.NOME_TESTE as col_2_0_, teste0_.COGNOME_TESTE as col_3_0_, teste0_.DATANASCI_TESTE as col_4_0_, teste0_.CSIRE as col_5_0_, prodotti1_.MSIRE as col_6_0_, polizze2_.POLIZZA_POLIZZE as col_7_0_, polizze2_.DATAEFFE_POLIZZE as col_8_0_, agenzie3_.RAGSOC_AGENZIE as col_9_0_, polizze2_.AGENZIA_POLIZZE as col_10_0_, polizze2_.RAMO_POLIZZE as col_11_0_, polizze2_.CODCOMP_POLIZZE as col_12_0_, polizze2_.NOME_POLIZZE as col_13_0_, polizze2_.COGNOME_POLIZZE as col_14_0_, case when teste0_.NOME_TESTE=polizze2_.NOME_POLIZZE and teste0_.COGNOME_TESTE=polizze2_.COGNOME_POLIZZE then '1' else '0' end as col_15_0_ from TESTE teste0_, PRODOTTI prodotti1_, POLIZZE polizze2_, AGENZIE agenzie3_ where polizze2_.CODCOMP_POLIZZE=prodotti1_.CCOMP and polizze2_.CODSIRE_POLIZZE=prodotti1_.CSIRE and teste0_.CODCOMP_TESTE=polizze2_.CODCOMP_POLIZZE and teste0_.CSIRE=polizze2_.CODSIRE_POLIZZE and teste0_.NORDSIR_TESTE=polizze2_.NORDSIR_POLIZZE and teste0_.DATAEFFE_TESTE=polizze2_.DATAEFFE_POLIZZE and polizze2_.CODCOMP_POLIZZE=agenzie3_.CODCOMP_AGENZIE and polizze2_.AGENZIA_POLIZZE=agenzie3_.CODICE_AGENZIE and (prodotti1_.CSIRE in (select prodottira4_.CSIRE from PRODOTTI_RAMI prodottira4_ where prodottira4_.CCOMP=? and prodottira4_.FLAG_SINISTRI='M' and prodottira4_.WEB_CONSULTAZIONE='S')) and teste0_.NOME_TESTE=? and teste0_.COGNOME_TESTE=? and polizze2_.CODCOMP_POLIZZE=? and agenzie3_.CODICE_AGENZIE=nvl(?, agenzie3_.CODICE_AGENZIE) order by teste0_.COGNOME_TESTE, teste0_.NOME_TESTE, polizze2_.DATAEFFE_POLIZZE, polizze2_.POLIZZA_POLIZZE, 16 desc]; SQL state [72000]; error code [1465]; ORA-01465: invalid hex number
; nested exception is java.sql.SQLException: ORA-01465: invalid hex number
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at servizio.WebServiceIntSoapBindingStub.searchAgenziaByNome(WebServiceIntSoapBindingStub.java:1545)
at com.servizi.gestione.InterrogaClinipass.getElencoAssicuratiBycognomeNomeAgenzia(InterrogaClinipass.java:1053)
at com.view.bean.UtenteAssicurato.getAssicuratiByCognomeNomeCompagnia(UtenteAssicurato.java:1522)
at com.view.businessLogic.pratiche.ElencoAssicurati.ricavaAssicuratiByDatiAnagrafici(ElencoAssicurati.java:312)
at com.view.businessLogic.pratiche.ElencoAssicurati.prepare(ElencoAssicurati.java:449)
at org.apache.jsp.JSP.pratiche.elenco_002dassicurati_jsp._jspService(elenco_002dassicurati_jsp.java:206)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.view.util.SecurityFilter.doFilter(SecurityFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
If i copy and paste into TOAD, the SQL query gives me 13 result rows.
In addiction, if I remove the nvl function (coalesce) from the query, it runs perfectly (either from my app or Toad).
My app has another query on the same tables with the coalesce function but it doesn't give me any problem.
Can someone help me :) ?
Ty in advance
Paolo