Erro Hibernate Oracle

Assuntos Gerais
#1

Quando executo o seguinte código ocorre essa exceção.

@Override
	public List<Planejamento> obterPorDataVendedor(Planejamento planejamento){
		SimpleDateFormat sd = new SimpleDateFormat("dd/MM/yyyy");  
		return findByHql("from Planejamento as p where p.dataVisita = '"+sd.format(planejamento.getDataVisita())
				+"' and p.vendedor='"+planejamento.getVendedor().getCodigoProtheus()+"' ");
	}
Out 23, 2012 5:08:03 PM com.sun.faces.application.ActionListenerImpl processAction
SEVERE: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select planejamen0_.id as id9_, planejamen0_.ACAO1 as ACAO2_9_, planejamen0_.ACAO2 as ACAO3_9_, planejamen0_.ACAO3 as ACAO4_9_, planejamen0_.ACAO4 as ACAO5_9_, planejamen0_.ACAO5 as ACAO6_9_, planejamen0_.CLIENTE as CLIENTE9_, planejamen0_.COMENTGERENTE as COMENTGE7_9_, planejamen0_.COMENTSUPERVISOR as COMENTSU8_9_, planejamen0_.COMENTVENDEDOR as COMENTVE9_9_, planejamen0_.DATAVISITA as DATAVISITA9_, planejamen0_.FOCO as FOCO9_, planejamen0_.INADIMPLENTE as INADIMP12_9_, planejamen0_.JOIA as JOIA9_, planejamen0_.MAIOR as MAIOR9_, planejamen0_.PLARROZ as PLARROZ9_, planejamen0_.PLFEIJAO as PLFEIJAO9_, planejamen0_.PLLEITE as PLLEITE9_, planejamen0_.RLARROZ as RLARROZ9_, planejamen0_.RLFEIJAO as RLFEIJAO9_, planejamen0_.RLLEITE as RLLEITE9_, planejamen0_.ROTACOACH as ROTACOACH9_, planejamen0_.ULTIMACOMPRAARROZ as ULTIMAC22_9_, planejamen0_.ULTIMACOMPRAFEIJAO as ULTIMAC23_9_, planejamen0_.ULTIMACOMPRALEITE as ULTIMAC24_9_, planejamen0_.VENDEDOR as VENDEDOR9_ from PLANEJAMENTO planejamen0_ where planejamen0_.DATAVISITA='23/10/2012' and planejamen0_.VENDEDOR='B3104']; SQL state [99999]; error code [17004]; Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor; nested exception is java.sql.SQLException: Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
javax.faces.el.EvaluationException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select planejamen0_.id as id9_, planejamen0_.ACAO1 as ACAO2_9_, planejamen0_.ACAO2 as ACAO3_9_, planejamen0_.ACAO3 as ACAO4_9_, planejamen0_.ACAO4 as ACAO5_9_, planejamen0_.ACAO5 as ACAO6_9_, planejamen0_.CLIENTE as CLIENTE9_, planejamen0_.COMENTGERENTE as COMENTGE7_9_, planejamen0_.COMENTSUPERVISOR as COMENTSU8_9_, planejamen0_.COMENTVENDEDOR as COMENTVE9_9_, planejamen0_.DATAVISITA as DATAVISITA9_, planejamen0_.FOCO as FOCO9_, planejamen0_.INADIMPLENTE as INADIMP12_9_, planejamen0_.JOIA as JOIA9_, planejamen0_.MAIOR as MAIOR9_, planejamen0_.PLARROZ as PLARROZ9_, planejamen0_.PLFEIJAO as PLFEIJAO9_, planejamen0_.PLLEITE as PLLEITE9_, planejamen0_.RLARROZ as RLARROZ9_, planejamen0_.RLFEIJAO as RLFEIJAO9_, planejamen0_.RLLEITE as RLLEITE9_, planejamen0_.ROTACOACH as ROTACOACH9_, planejamen0_.ULTIMACOMPRAARROZ as ULTIMAC22_9_, planejamen0_.ULTIMACOMPRAFEIJAO as ULTIMAC23_9_, planejamen0_.ULTIMACOMPRALEITE as ULTIMAC24_9_, planejamen0_.VENDEDOR as VENDEDOR9_ from PLANEJAMENTO planejamen0_ where planejamen0_.DATAVISITA='23/10/2012' and planejamen0_.VENDEDOR='B3104']; SQL state [99999]; error code [17004]; Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor; nested exception is java.sql.SQLException: Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
	at javax.faces.component.UICommand.broadcast(UICommand.java:315)
	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:787)
	at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1252)
	at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select planejamen0_.id as id9_, planejamen0_.ACAO1 as ACAO2_9_, planejamen0_.ACAO2 as ACAO3_9_, planejamen0_.ACAO3 as ACAO4_9_, planejamen0_.ACAO4 as ACAO5_9_, planejamen0_.ACAO5 as ACAO6_9_, planejamen0_.CLIENTE as CLIENTE9_, planejamen0_.COMENTGERENTE as COMENTGE7_9_, planejamen0_.COMENTSUPERVISOR as COMENTSU8_9_, planejamen0_.COMENTVENDEDOR as COMENTVE9_9_, planejamen0_.DATAVISITA as DATAVISITA9_, planejamen0_.FOCO as FOCO9_, planejamen0_.INADIMPLENTE as INADIMP12_9_, planejamen0_.JOIA as JOIA9_, planejamen0_.MAIOR as MAIOR9_, planejamen0_.PLARROZ as PLARROZ9_, planejamen0_.PLFEIJAO as PLFEIJAO9_, planejamen0_.PLLEITE as PLLEITE9_, planejamen0_.RLARROZ as RLARROZ9_, planejamen0_.RLFEIJAO as RLFEIJAO9_, planejamen0_.RLLEITE as RLLEITE9_, planejamen0_.ROTACOACH as ROTACOACH9_, planejamen0_.ULTIMACOMPRAARROZ as ULTIMAC22_9_, planejamen0_.ULTIMACOMPRAFEIJAO as ULTIMAC23_9_, planejamen0_.ULTIMACOMPRALEITE as ULTIMAC24_9_, planejamen0_.VENDEDOR as VENDEDOR9_ from PLANEJAMENTO planejamen0_ where planejamen0_.DATAVISITA='23/10/2012' and planejamen0_.VENDEDOR='B3104']; SQL state [99999]; error code [17004]; Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor; nested exception is java.sql.SQLException: Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
	at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
	at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:904)
	at dao.DaoModel.findByHql(DaoModel.java:133)
	at dao.hibernate.PlanejamentoDaoHibernate.obterPorDataVendedor(PlanejamentoDaoHibernate.java:44)
	at bean.PlanejamentoBean.obterRoteiroDia(PlanejamentoBean.java:105)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.el.parser.AstValue.invoke(AstValue.java:278)
	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
	at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
	... 27 more
Caused by: java.sql.SQLException: Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
	at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:375)
	at oracle.jdbc.driver.Accessor.getTimestamp(Accessor.java:808)
	at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:1060)
	at oracle.jdbc.driver.OracleResultSet.getTimestamp(OracleResultSet.java:512)
	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:262)
	at org.hibernate.type.TimestampType.get(TimestampType.java:30)
	at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
	at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
	at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
	at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2096)
	at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
	at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)
	at org.hibernate.loader.Loader.getRow(Loader.java:1206)
	at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
	at org.hibernate.loader.Loader.doQuery(Loader.java:701)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	at org.hibernate.loader.Loader.doList(Loader.java:2220)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	at org.hibernate.loader.Loader.list(Loader.java:2099)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
	at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
	... 41 more
#2

Caused by: java.sql.SQLException: Tipo de coluna inválido: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor

É cara, parece que seu driver está desatualizado. O.o

#3

Atualizei o driver porém o erro persiste

SEVERE: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id9_2_, this_.ACAO1 as ACAO2_9_2_, this_.ACAO2 as ACAO3_9_2_, this_.ACAO3 as ACAO4_9_2_, this_.ACAO4 as ACAO5_9_2_, this_.ACAO5 as ACAO6_9_2_, this_.CLIENTE as CLIENTE9_2_, this_.COMENTGERENTE as COMENTGE7_9_2_, this_.COMENTSUPERVISOR as COMENTSU8_9_2_, this_.COMENTVENDEDOR as COMENTVE9_9_2_, this_.DATAVISITA as DATAVISITA9_2_, this_.FOCO as FOCO9_2_, this_.INADIMPLENTE as INADIMP12_9_2_, this_.JOIA as JOIA9_2_, this_.MAIOR as MAIOR9_2_, this_.PLARROZ as PLARROZ9_2_, this_.PLFEIJAO as PLFEIJAO9_2_, this_.PLLEITE as PLLEITE9_2_, this_.RLARROZ as RLARROZ9_2_, this_.RLFEIJAO as RLFEIJAO9_2_, this_.RLLEITE as RLLEITE9_2_, this_.ROTACOACH as ROTACOACH9_2_, this_.ULTIMACOMPRAARROZ as ULTIMAC22_9_2_, this_.ULTIMACOMPRAFEIJAO as ULTIMAC23_9_2_, this_.ULTIMACOMPRALEITE as ULTIMAC24_9_2_, this_.VENDEDOR as VENDEDOR9_2_, cliente2_.CODIGOPROTHEUS as CODIGOPR1_1_0_, cliente2_.BAIRRO as BAIRRO1_0_, cliente2_.CEP as CEP1_0_, cliente2_.CGC as CGC1_0_, cliente2_.CIDADE as CIDADE1_0_, cliente2_.CONTATO as CONTATO1_0_, cliente2_.ENDERECO as ENDERECO1_0_, cliente2_.IE as IE1_0_, cliente2_.NOMEFANTASIA as NOMEFANT9_1_0_, cliente2_.RAZAOSOCIAL as RAZAOSO10_1_0_, cliente2_.STATUS as STATUS1_0_, cliente2_.TELEFONE as TELEFONE1_0_, colaborado3_.CODIGOPROTHEUS as CODIGOPR1_2_1_, colaborado3_.BAIRRO as BAIRRO2_1_, colaborado3_.CEP as CEP2_1_, colaborado3_.CGC as CGC2_1_, colaborado3_.EMAIL as EMAIL2_1_, colaborado3_.ENDERECO as ENDERECO2_1_, colaborado3_.ESTADO as ESTADO2_1_, colaborado3_.GERENTE as GERENTE2_1_, colaborado3_.INSCRICAOESTADUAL as INSCRICA8_2_1_, colaborado3_.MUNICIPIO as MUNICIPIO2_1_, colaborado3_.NOME as NOME2_1_, colaborado3_.NOMEREDUZIDO as NOMERED11_2_1_, colaborado3_.STATUS as STATUS2_1_, colaborado3_.SUPERVISOR as SUPERVISOR2_1_, colaborado3_.TELEFONE as TELEFONE2_1_ from PLANEJAMENTO this_, CLIENTES cliente2_, COLABORADOR colaborado3_ where this_.CLIENTE=cliente2_.CODIGOPROTHEUS(+) and this_.VENDEDOR=colaborado3_.CODIGOPROTHEUS(+)]; SQL state [99999]; error code [17004]; Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor; nested exception is java.sql.SQLException: Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor javax.faces.el.EvaluationException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id9_2_, this_.ACAO1 as ACAO2_9_2_, this_.ACAO2 as ACAO3_9_2_, this_.ACAO3 as ACAO4_9_2_, this_.ACAO4 as ACAO5_9_2_, this_.ACAO5 as ACAO6_9_2_, this_.CLIENTE as CLIENTE9_2_, this_.COMENTGERENTE as COMENTGE7_9_2_, this_.COMENTSUPERVISOR as COMENTSU8_9_2_, this_.COMENTVENDEDOR as COMENTVE9_9_2_, this_.DATAVISITA as DATAVISITA9_2_, this_.FOCO as FOCO9_2_, this_.INADIMPLENTE as INADIMP12_9_2_, this_.JOIA as JOIA9_2_, this_.MAIOR as MAIOR9_2_, this_.PLARROZ as PLARROZ9_2_, this_.PLFEIJAO as PLFEIJAO9_2_, this_.PLLEITE as PLLEITE9_2_, this_.RLARROZ as RLARROZ9_2_, this_.RLFEIJAO as RLFEIJAO9_2_, this_.RLLEITE as RLLEITE9_2_, this_.ROTACOACH as ROTACOACH9_2_, this_.ULTIMACOMPRAARROZ as ULTIMAC22_9_2_, this_.ULTIMACOMPRAFEIJAO as ULTIMAC23_9_2_, this_.ULTIMACOMPRALEITE as ULTIMAC24_9_2_, this_.VENDEDOR as VENDEDOR9_2_, cliente2_.CODIGOPROTHEUS as CODIGOPR1_1_0_, cliente2_.BAIRRO as BAIRRO1_0_, cliente2_.CEP as CEP1_0_, cliente2_.CGC as CGC1_0_, cliente2_.CIDADE as CIDADE1_0_, cliente2_.CONTATO as CONTATO1_0_, cliente2_.ENDERECO as ENDERECO1_0_, cliente2_.IE as IE1_0_, cliente2_.NOMEFANTASIA as NOMEFANT9_1_0_, cliente2_.RAZAOSOCIAL as RAZAOSO10_1_0_, cliente2_.STATUS as STATUS1_0_, cliente2_.TELEFONE as TELEFONE1_0_, colaborado3_.CODIGOPROTHEUS as CODIGOPR1_2_1_, colaborado3_.BAIRRO as BAIRRO2_1_, colaborado3_.CEP as CEP2_1_, colaborado3_.CGC as CGC2_1_, colaborado3_.EMAIL as EMAIL2_1_, colaborado3_.ENDERECO as ENDERECO2_1_, colaborado3_.ESTADO as ESTADO2_1_, colaborado3_.GERENTE as GERENTE2_1_, colaborado3_.INSCRICAOESTADUAL as INSCRICA8_2_1_, colaborado3_.MUNICIPIO as MUNICIPIO2_1_, colaborado3_.NOME as NOME2_1_, colaborado3_.NOMEREDUZIDO as NOMERED11_2_1_, colaborado3_.STATUS as STATUS2_1_, colaborado3_.SUPERVISOR as SUPERVISOR2_1_, colaborado3_.TELEFONE as TELEFONE2_1_ from PLANEJAMENTO this_, CLIENTES cliente2_, COLABORADOR colaborado3_ where this_.CLIENTE=cliente2_.CODIGOPROTHEUS(+) and this_.VENDEDOR=colaborado3_.CODIGOPROTHEUS(+)]; SQL state [99999]; error code [17004]; Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor; nested exception is java.sql.SQLException: Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:315) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:787) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1252) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id9_2_, this_.ACAO1 as ACAO2_9_2_, this_.ACAO2 as ACAO3_9_2_, this_.ACAO3 as ACAO4_9_2_, this_.ACAO4 as ACAO5_9_2_, this_.ACAO5 as ACAO6_9_2_, this_.CLIENTE as CLIENTE9_2_, this_.COMENTGERENTE as COMENTGE7_9_2_, this_.COMENTSUPERVISOR as COMENTSU8_9_2_, this_.COMENTVENDEDOR as COMENTVE9_9_2_, this_.DATAVISITA as DATAVISITA9_2_, this_.FOCO as FOCO9_2_, this_.INADIMPLENTE as INADIMP12_9_2_, this_.JOIA as JOIA9_2_, this_.MAIOR as MAIOR9_2_, this_.PLARROZ as PLARROZ9_2_, this_.PLFEIJAO as PLFEIJAO9_2_, this_.PLLEITE as PLLEITE9_2_, this_.RLARROZ as RLARROZ9_2_, this_.RLFEIJAO as RLFEIJAO9_2_, this_.RLLEITE as RLLEITE9_2_, this_.ROTACOACH as ROTACOACH9_2_, this_.ULTIMACOMPRAARROZ as ULTIMAC22_9_2_, this_.ULTIMACOMPRAFEIJAO as ULTIMAC23_9_2_, this_.ULTIMACOMPRALEITE as ULTIMAC24_9_2_, this_.VENDEDOR as VENDEDOR9_2_, cliente2_.CODIGOPROTHEUS as CODIGOPR1_1_0_, cliente2_.BAIRRO as BAIRRO1_0_, cliente2_.CEP as CEP1_0_, cliente2_.CGC as CGC1_0_, cliente2_.CIDADE as CIDADE1_0_, cliente2_.CONTATO as CONTATO1_0_, cliente2_.ENDERECO as ENDERECO1_0_, cliente2_.IE as IE1_0_, cliente2_.NOMEFANTASIA as NOMEFANT9_1_0_, cliente2_.RAZAOSOCIAL as RAZAOSO10_1_0_, cliente2_.STATUS as STATUS1_0_, cliente2_.TELEFONE as TELEFONE1_0_, colaborado3_.CODIGOPROTHEUS as CODIGOPR1_2_1_, colaborado3_.BAIRRO as BAIRRO2_1_, colaborado3_.CEP as CEP2_1_, colaborado3_.CGC as CGC2_1_, colaborado3_.EMAIL as EMAIL2_1_, colaborado3_.ENDERECO as ENDERECO2_1_, colaborado3_.ESTADO as ESTADO2_1_, colaborado3_.GERENTE as GERENTE2_1_, colaborado3_.INSCRICAOESTADUAL as INSCRICA8_2_1_, colaborado3_.MUNICIPIO as MUNICIPIO2_1_, colaborado3_.NOME as NOME2_1_, colaborado3_.NOMEREDUZIDO as NOMERED11_2_1_, colaborado3_.STATUS as STATUS2_1_, colaborado3_.SUPERVISOR as SUPERVISOR2_1_, colaborado3_.TELEFONE as TELEFONE2_1_ from PLANEJAMENTO this_, CLIENTES cliente2_, COLABORADOR colaborado3_ where this_.CLIENTE=cliente2_.CODIGOPROTHEUS(+) and this_.VENDEDOR=colaborado3_.CODIGOPROTHEUS(+)]; SQL state [99999]; error code [17004]; Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor; nested exception is java.sql.SQLException: Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584) at dao.hibernate.PlanejamentoDaoHibernate.obterPorDataVendedor(PlanejamentoDaoHibernate.java:50) at bean.PlanejamentoBean.obterRoteiroDia(PlanejamentoBean.java:105) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.el.parser.AstValue.invoke(AstValue.java:278) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) ... 27 more Caused by: java.sql.SQLException: Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:690) at oracle.jdbc.driver.BlobAccessor.getString(BlobAccessor.java:830) at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:3133) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1343) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:225) at org.hibernate.type.StringType.get(StringType.java:18) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154) at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2096) at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380) at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308) at org.hibernate.loader.Loader.getRow(Loader.java:1206) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580) at org.hibernate.loader.Loader.doQuery(Loader.java:701) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 39 more

#4

É mano, na verdade o erro mudou:
Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor

Aquela hora era getTimeStamp. O.o

#5

Tive um erro muito semelhante por questões do classloader.
Havia a lib do Hibernate empacotada na aplicação E no servidor, em outro caso eram até versões diferentes, que impactavam nesses problemas.
Verifique isso e mantenha em apenas um lugar.

#6

Os campos do banco estavam incompatíveis com os do java.

#7

quais eram os campos do banco e em java?

#8

O campo data foi criado com tipo errado no Oracle.

#9

tem que ser date ou timestamp no oracle?
e como fica no java dependendo de cada caso?
se eu tiver no oracle date como uso no java?

#10

[quote=Hebert Coelho]É mano, na verdade o erro mudou:
Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor

Aquela hora era getTimeStamp. O.o[/quote]

tem que ser date ou timestamp no oracle?
e como fica no java dependendo de cada caso?
se eu tiver no oracle date como uso no java?

#11

[quote=Hebert Coelho]É mano, na verdade o erro mudou:
Tipo de coluna inválido: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor

Aquela hora era getTimeStamp. O.o[/quote]

o erro é por causa da coluna onde renderizo a consulta sql ou na entity que tem que ser timestamp quando o oracle é timestamp? ou não entendi a solução?

#12