JBoss Community

Re: Backups and migrations

created by charly hurtado in Beginner's Corner - View the full discussion

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]