charly hurtado [http://community.jboss.org/people/charly.hurtado] created the discussion "Re: Backups and migrations" To view the discussion, visit: http://community.jboss.org/message/593886#593886 -------------------------------------------------------------- we did not make change about database type.. i detect the problem is on field tipe @Lob. our EJB3 Version running actually is  "EJB 3.0 Preview RC9 Patch 1- FD." my annotation on Bean @Stateless @LocalBinding(jndiBinding="x/BlogPostedBean") public class BlogPostedBean implements BlogPostedLocal example tables-entities  with this error... blog_posts        Column        |            Type             |                  Modifiers                  ---------------------+-----------------------------+--------------------------------------------- post_abstract       | text                        | not null Field  @Lob @Column(name = "post_abstract", nullable = false)    private String postAbstract;    public String getPostAbstract() {        return postAbstract;    } logs about error : 16:14:25,840 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 22003 16:14:25,840 ERROR [JDBCExceptionReporter] Bad value for type int : Best known for her series of 54 oil paintings re-creating the images and symbols of the classic Mexican Loteria from a US Latino perspective, Cristina Noriega is also an accomplished portrait painter. Her portraits have a vividness, depth and intensity that makes them exceptional. She is a veteran of more than a dozen group shows, a one-woman show at Ortiz Contemporary Gallery and recently joined her father Lionel and John Dyer for the Witte Museum exhibition of ?Vaqueros, the Original American Cowboy,?. She spends her time between San Antonio, Marfa and Alpine, Texas. 16:14:25,842 INFO  [DefaultLoadEventListener] Error performing load command: org.hibernate.exception.DataException: could not load an entity: [RoleEJB#96]         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102) [:3.6.0.Final]         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [:3.6.0.Final]         at org.hibernate.loader.Loader.loadEntity(Loader.java:2041) [:3.6.0.Final]         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86) [:3.6.0.Final]         at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76) [:3.6.0.Final]         at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3268) [:3.6.0.Final]         at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) [:3.6.0.Final]         at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) [:3.6.0.Final]         at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) [:3.6.0.Final]         at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285) [:3.6.0.Final]         at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152) [:3.6.0.Final]         at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090) [:3.6.0.Final]         at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1038) [:3.6.0.Final]         at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:630) [:3.6.0.Final]         at org.hibernate.type.EntityType.resolve(EntityType.java:438) [:3.6.0.Final]         at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:139) [:3.6.0.Final]         at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:982) [:3.6.0.Final]         at org.hibernate.loader.Loader.doQuery(Loader.java:857) [:3.6.0.Final]         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [:3.6.0.Final]         at org.hibernate.loader.Loader.doList(Loader.java:2533) [:3.6.0.Final]         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [:3.6.0.Final]         at org.hibernate.loader.Loader.list(Loader.java:2271) [:3.6.0.Final]         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) [:3.6.0.Final]         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) [:3.6.0.Final]         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [:3.6.0.Final]         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) [:3.6.0.Final]         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [:3.6.0.Final]         at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246) [:3.6.0.Final]         at org.matt.site.ejb.stateless.blog.BlogPostedBean.getUserOnBlogPost(Unknown Source) [:]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_23]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_23]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_23]         at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_23]         at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) [jboss-aop.jar:2.2.1.GA]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.interceptors.container.ContainerMethodInvocationWrapper.invokeNext(ContainerMethodInvocationWrapper.java:72) [:1.1.3]         at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:76) [:1.1.3]         at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:62) [:1.1.3]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_23]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_23]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_23]         at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_23]         at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) [jboss-aop.jar:2.2.1.GA]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:74) [:1.1.3]         at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_2078818709.invoke(InvocationContextInterceptor_z_fillMethod_2078818709.java) [:]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:90) [:1.1.3]         at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_2078818709.invoke(InvocationContextInterceptor_z_setup_2078818709.java) [:]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.async.impl.interceptor.AsynchronousServerInterceptor.invoke(AsynchronousServerInterceptor.java:128) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) [:1.0.3]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.core.context.SessionInvocationContextAdapter.proceed(SessionInvocationContextAdapter.java:95) [:1.7.17]         at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:247) [:0.0.1]         at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.required(CMTTxInterceptor.java:349) [:0.0.1]         at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(CMTTxInterceptor.java:209) [:0.0.1]         at org.jboss.ejb3.tx2.aop.CMTTxInterceptorWrapper.invoke(CMTTxInterceptorWrapper.java:52) [:0.0.1]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) [:1.0.0.GA]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) [:1.0.3]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:182) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.core.context.CurrentInvocationContextInterceptor.invoke(CurrentInvocationContextInterceptor.java:47) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) [:1.0.1]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCCLInterceptor.java:86) [:1.7.17]         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]         at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:323) [:1.7.17]         at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:380) [:1.7.17]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_23]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_23]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_23]         at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_23] -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/593886#593886] Start a new discussion in Beginner's Corner at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

charly hurtado [http://community.jboss.org/people/charly.hurtado] created the discussion "Re: Backups and migrations" To view the discussion, visit: http://community.jboss.org/message/593903#593903 -------------------------------------------------------------- with show_sql on 2011-03-17 12:55:13,359 DEBUG [org.hibernate.util.JDBCExceptionReporter] (Thread-25) could not execute query [select blogpostej0_.post_id as post1_181_, blogpostej0_.cat_id as cat2_181_, blogpostej0_.post_hasimage as post3_181_, blogpostej0_.post_abstract as post4_181_, blogpostej0_.post_body as post5_181_, blogpostej0_.post_date as post6_181_, blogpostej0_.post_language as post7_181_, blogpostej0_.post_title as post8_181_, blogpostej0_.post_total_comments as post9_181_, blogpostej0_.post_url as post10_181_, blogpostej0_.usr_id as usr11_181_ from blog_posts blogpostej0_ where blogpostej0_.cat_id<>? and (blogpostej0_.post_date between ? and ?) order by blogpostej0_.post_id DESC]: org.postgresql.util.PSQLException: Bad value for type int : -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/593903#593903] Start a new discussion in Beginner's Corner at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]