Bom dia pessoal!
Bom estou com o seguinte problema com o JPA, quando ele vai pegar na minha base de dado um campo que ele está como estring ele tenta pegar como inteiro, não consigo entender porque ele está fazendo isso, o mapeamento foi gerado no netbeans, e está de acordo. o projeto está sendo desenvolvido no eclipse.
quando tento executar essa consulta no servidor, estou usando JBoss 4.2.2.GA.
imprime o seguinte no console
ERROR [JDBCExceptionReporter] Invalid value for getInt() - '00-00-00-00-00-00' in column 1
09:36:20,058 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
09:36:20,058 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
09:36:20,068 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)
09:36:20,068 ERROR [STDERR] at br.com.prodesan.remote.cacic.dao.SoftwaresInventariadosEstacoesDAO.getAll(SoftwaresInventariadosEstacoesDAO.java:21)
09:36:20,068 ERROR [STDERR] at br.com.prodesan.remote.cacic.ws.SoftwaresInventariadosEstacoesRemoteImpl.getSoftwaresAll(SoftwaresInventariadosEstacoesRemoteImpl.java:3
09:36:20,068 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
09:36:20,068 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
09:36:20,068 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
09:36:20,068 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
09:36:20,068 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
09:36:20,068 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
09:36:20,068 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
09:36:20,068 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,068 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
09:36:20,068 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,078 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
09:36:20,088 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,088 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
09:36:20,098 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
09:36:20,108 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,108 ERROR [STDERR] at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
09:36:20,118 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,128 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
09:36:20,138 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,138 ERROR [STDERR] at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
09:36:20,148 ERROR [STDERR] at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
09:36:20,158 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,158 ERROR [STDERR] at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
09:36:20,168 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,178 ERROR [STDERR] at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
09:36:20,188 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
09:36:20,188 ERROR [STDERR] at org.jboss.wsf.container.jboss42.InvocationHandlerEJB3.invoke(InvocationHandlerEJB3.java:103)
09:36:20,208 ERROR [STDERR] at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:220)
09:36:20,208 ERROR [STDERR] at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:408)
09:36:20,218 ERROR [STDERR] at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:272)
09:36:20,228 ERROR [STDERR] at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:189)
09:36:20,228 ERROR [STDERR] at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:122)
09:36:20,238 ERROR [STDERR] at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
09:36:20,248 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
09:36:20,258 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
09:36:20,258 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
09:36:20,268 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
09:36:20,278 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
09:36:20,278 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
09:36:20,288 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
09:36:20,298 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
09:36:20,308 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
09:36:20,308 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
09:36:20,318 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
09:36:20,328 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
09:36:20,328 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
09:36:20,338 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
09:36:20,348 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
09:36:20,358 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
09:36:20,358 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
09:36:20,368 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
09:36:20,378 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
09:36:20,378 ERROR [STDERR] Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
09:36:20,388 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
09:36:20,388 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
09:36:20,398 ERROR [STDERR] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
09:36:20,408 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2223)
09:36:20,408 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
09:36:20,418 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2099)
09:36:20,418 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
09:36:20,428 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
09:36:20,438 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
09:36:20,438 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
09:36:20,448 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
09:36:20,458 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
09:36:20,458 ERROR [STDERR] ... 54 more
09:36:20,458 ERROR [STDERR] Caused by: java.sql.SQLException: Invalid value for getInt() - '00-00-00-00-00-00' in column 1
09:36:20,468 ERROR [STDERR] at com.mysql.jdbc.ResultSet.getIntFromString(ResultSet.java:2419)
09:36:20,478 ERROR [STDERR] at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3727)
09:36:20,488 ERROR [STDERR] at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2338)
09:36:20,488 ERROR [STDERR] at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2353)
09:36:20,618 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedResultSet.getInt(WrappedResultSet.java:692)
09:36:20,618 ERROR [STDERR] at org.hibernate.type.IntegerType.get(IntegerType.java:28)
09:36:20,618 ERROR [STDERR] at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
09:36:20,618 ERROR [STDERR] at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
09:36:20,618 ERROR [STDERR] at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
09:36:20,618 ERROR [STDERR] at org.hibernate.type.ComponentType.hydrate(ComponentType.java:560)
09:36:20,618 ERROR [STDERR] at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:275)
09:36:20,618 ERROR [STDERR] at org.hibernate.type.ManyToOneType.hydrate(ManyToOneType.java:103)
09:36:20,618 ERROR [STDERR] at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2096)
09:36:20,618 ERROR [STDERR] at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
09:36:20,628 ERROR [STDERR] at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)
09:36:20,628 ERROR [STDERR] at org.hibernate.loader.Loader.getRow(Loader.java:1206)
09:36:20,628 ERROR [STDERR] at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
09:36:20,628 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:701)
09:36:20,628 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
09:36:20,628 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2220)
09:36:20,628 ERROR [STDERR] ... 62 morese alguém ja teve um problema parecido como conseguiu resolver, se não, alguém poderia me ajudar?
desde já agradeço a todos!