Fórum
getInt: conversion error (F) when using teradata..Pls help
Chandra sekar, modificado 16 Anos atrás.
getInt: conversion error (F) when using teradata..Pls help
New Member Postagens: 2 Data de Entrada: 12/12/07 Postagens Recentes
Hi ,
I am using teradata as the database and tomcat 5.5 . I have changed the hibernate dialect to TeradataDialect and when i start the server i get the following error message .
I found that whenever it is trying to read the data from a char column in database it gives the error .
For ex : hidden_ in Layout table
and passwordEncrypted in User_
Please help .
Error Message :
Hibernate: select userimpl0_.userId as userId29_0_, userimpl0_.companyId as companyId29_0_, userimpl0_.createDate as createDate29_0_, userimpl0_.modif
iedDate as modified4_29_0_, userimpl0_.contactId as contactId29_0_, userimpl0_.password_ as password6_29_0_, userimpl0_.passwordEncrypted as password7
_29_0_, userimpl0_.passwordExpirationDate as password8_29_0_, userimpl0_.passwordReset as password9_29_0_, userimpl0_.emailAddress as emailAd10_29_0_,
userimpl0_.languageId as languageId29_0_, userimpl0_.timeZoneId as timeZoneId29_0_, userimpl0_.greeting as greeting29_0_, userimpl0_.resolution as re
solution29_0_, userimpl0_.comments as comments29_0_, userimpl0_.loginDate as loginDate29_0_, userimpl0_.loginIP as loginIP29_0_, userimpl0_.lastLoginD
ate as lastLog18_29_0_, userimpl0_.lastLoginIP as lastLog19_29_0_, userimpl0_.failedLoginAttempts as failedL20_29_0_, userimpl0_.agreedToTermsOfUse as
agreedT21_29_0_, userimpl0_.active_ as active22_29_0_ from User_ userimpl0_ where userimpl0_.userId=?
10:16:59,695 ERROR [JDBCExceptionReporter:78] [NCR][Teradata JDBC Driver]:TeraResultSet:getInt: conversion error (F)
10:16:59,695 ERROR [HibernateUtil:174] Caught HibernateException. could not load an entity: [com.liferay.portal.model.impl.UserImpl#liferay.com.defaul
t]
10:16:59,726 ERROR [MainServlet:296] com.liferay.portal.SystemException: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.
liferay.portal.model.impl.UserImpl#liferay.com.default]
at com.liferay.portal.spring.hibernate.HibernateUtil.processException(HibernateUtil.java:182)
at com.liferay.portal.service.persistence.UserPersistence.fetchByPrimaryKey(UserPersistence.java:187)
at com.liferay.portal.service.persistence.UserPersistence.findByPrimaryKey(UserPersistence.java:164)
at com.liferay.portal.service.persistence.UserUtil.findByPrimaryKey(UserUtil.java:143)
at com.liferay.portal.service.impl.UserLocalServiceImpl.getDefaultUser(UserLocalServiceImpl.java:611)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:280)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy7.getDefaultUser(Unknown Source)
at com.liferay.portal.service.UserLocalServiceUtil.getDefaultUser(UserLocalServiceUtil.java:171)
at com.liferay.portal.service.impl.CompanyLocalServiceImpl.checkCompany(CompanyLocalServiceImpl.java:183)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:280)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy6.checkCompany(Unknown Source)
at com.liferay.portal.service.CompanyLocalServiceUtil.checkCompany(CompanyLocalServiceUtil.java:36)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:293)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
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.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.liferay.portal.model.impl.UserImpl#liferay.com.default]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
at com.liferay.portal.service.persistence.UserPersistence.fetchByPrimaryKey(UserPersistence.java:184)
... 56 more
Caused by: java.sql.SQLException: [NCR][Teradata JDBC Driver]:TeraResultSet:getInt: conversion error (F)
at com.ncr.teradata.ComUtil.ThrowExcp(ComUtil.java:1783)
at com.ncr.teradata.TeraResultSet.getInt(TeraResultSet.java:897)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalResultSet.getInt(TeraLocalResultSet.java:255)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalResultSet.getBoolean(TeraLocalResultSet.java:221)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalResultSet.getBoolean(TeraLocalResultSet.java:433)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getBoolean(DelegatingResultSet.java:227)
at org.hibernate.type.BooleanType.get(BooleanType.java:23)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at com.liferay.util.dao.hibernate.BooleanType.nullSafeGet(BooleanType.java:83)
at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:105)
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.loadEntity(Loader.java:1860)
... 68 more
-- Chandrasekar .
I am using teradata as the database and tomcat 5.5 . I have changed the hibernate dialect to TeradataDialect and when i start the server i get the following error message .
I found that whenever it is trying to read the data from a char column in database it gives the error .
For ex : hidden_ in Layout table
and passwordEncrypted in User_
Please help .
Error Message :
Hibernate: select userimpl0_.userId as userId29_0_, userimpl0_.companyId as companyId29_0_, userimpl0_.createDate as createDate29_0_, userimpl0_.modif
iedDate as modified4_29_0_, userimpl0_.contactId as contactId29_0_, userimpl0_.password_ as password6_29_0_, userimpl0_.passwordEncrypted as password7
_29_0_, userimpl0_.passwordExpirationDate as password8_29_0_, userimpl0_.passwordReset as password9_29_0_, userimpl0_.emailAddress as emailAd10_29_0_,
userimpl0_.languageId as languageId29_0_, userimpl0_.timeZoneId as timeZoneId29_0_, userimpl0_.greeting as greeting29_0_, userimpl0_.resolution as re
solution29_0_, userimpl0_.comments as comments29_0_, userimpl0_.loginDate as loginDate29_0_, userimpl0_.loginIP as loginIP29_0_, userimpl0_.lastLoginD
ate as lastLog18_29_0_, userimpl0_.lastLoginIP as lastLog19_29_0_, userimpl0_.failedLoginAttempts as failedL20_29_0_, userimpl0_.agreedToTermsOfUse as
agreedT21_29_0_, userimpl0_.active_ as active22_29_0_ from User_ userimpl0_ where userimpl0_.userId=?
10:16:59,695 ERROR [JDBCExceptionReporter:78] [NCR][Teradata JDBC Driver]:TeraResultSet:getInt: conversion error (F)
10:16:59,695 ERROR [HibernateUtil:174] Caught HibernateException. could not load an entity: [com.liferay.portal.model.impl.UserImpl#liferay.com.defaul
t]
10:16:59,726 ERROR [MainServlet:296] com.liferay.portal.SystemException: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.
liferay.portal.model.impl.UserImpl#liferay.com.default]
at com.liferay.portal.spring.hibernate.HibernateUtil.processException(HibernateUtil.java:182)
at com.liferay.portal.service.persistence.UserPersistence.fetchByPrimaryKey(UserPersistence.java:187)
at com.liferay.portal.service.persistence.UserPersistence.findByPrimaryKey(UserPersistence.java:164)
at com.liferay.portal.service.persistence.UserUtil.findByPrimaryKey(UserUtil.java:143)
at com.liferay.portal.service.impl.UserLocalServiceImpl.getDefaultUser(UserLocalServiceImpl.java:611)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:280)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy7.getDefaultUser(Unknown Source)
at com.liferay.portal.service.UserLocalServiceUtil.getDefaultUser(UserLocalServiceUtil.java:171)
at com.liferay.portal.service.impl.CompanyLocalServiceImpl.checkCompany(CompanyLocalServiceImpl.java:183)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:280)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy6.checkCompany(Unknown Source)
at com.liferay.portal.service.CompanyLocalServiceUtil.checkCompany(CompanyLocalServiceUtil.java:36)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:293)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
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.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.liferay.portal.model.impl.UserImpl#liferay.com.default]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
at com.liferay.portal.service.persistence.UserPersistence.fetchByPrimaryKey(UserPersistence.java:184)
... 56 more
Caused by: java.sql.SQLException: [NCR][Teradata JDBC Driver]:TeraResultSet:getInt: conversion error (F)
at com.ncr.teradata.ComUtil.ThrowExcp(ComUtil.java:1783)
at com.ncr.teradata.TeraResultSet.getInt(TeraResultSet.java:897)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalResultSet.getInt(TeraLocalResultSet.java:255)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalResultSet.getBoolean(TeraLocalResultSet.java:221)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalResultSet.getBoolean(TeraLocalResultSet.java:433)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getBoolean(DelegatingResultSet.java:227)
at org.hibernate.type.BooleanType.get(BooleanType.java:23)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at com.liferay.util.dao.hibernate.BooleanType.nullSafeGet(BooleanType.java:83)
at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:105)
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.loadEntity(Loader.java:1860)
... 68 more
-- Chandrasekar .