The exception says it wants a varchar, but your view is returning a big int, have you checked that?
You might need to specify the column type : @Column(name="ID", columnDefinition="VARCHAR") Chris -----Original Message----- From: Himadri [mailto:[email protected]] Sent: Wednesday, 30 June 2010 3:01 PM To: [email protected] Subject: Issue with ID column for Database view as Entity (EJB3.0) Hi, My requirement is to use a database view as EJB3.0 Entity. I suppose this doesnt need any extra effort. table name tag is db view name instead of table name. This is how it looks like @Entity @Table(name="Property_V") @NamedQueries({ @NamedQuery(name="findPropsByName" ,query="Select o from PropertyView o where o.name = :a"), }) public class PropertyView extends PropertyViewBean {} I have only getter methods in Entity and no setters. The issue comes only when I declare ID column in entity. @Column(name="ID") public String id ; public String getId() { return this.id; } Its varchar2 in oracle database but somehow openjpa interpret it as BIGINT and throws me below ! This is coming when I try to call the namedquery. javax.ejb.EJBException: EJB Exception: ; nested exception is: <openjpa-0.0.0-rnull fatal user error> org.apache.openjpa.persistence.ArgumentException: "com.sample.magic.poc.domain.PropertyViewBean.id" declares a column that is not compatible with the expected type "varchar". Column details: Full Name: Property_V.id Type: bigint Size: 0 Default: null Not Null: true at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.unwrapRemoteExceptio n(RemoteBusinessIntfProxy.java:105) at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusines sIntfProxy.java:87) at $Proxy0.getProperties(Unknown Source) at test.junit.TestSample.testView(TestSample.java:67) at test.junit.TestSample.main(TestSample.java:26) Caused by: <openjpa-0.0.0-rnull fatal user error> org.apache.openjpa.persistence.ArgumentException: "com.tieto.magic.poc.domain.PropertyViewBean.id" declares a column that is not compatible with the expected type "varchar". Column details: Full Name: Property_V.id Type: bigint Size: 0 Default: null Not Null: true at org.apache.openjpa.jdbc.meta.MappingInfo.mergeColumn(MappingInfo.java:659) at org.apache.openjpa.jdbc.meta.MappingInfo.createColumns(MappingInfo.java:518) at org.apache.openjpa.jdbc.meta.ValueMappingInfo.getColumns(ValueMappingInfo.ja va:143) at org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy.map(StringFieldStrat egy.java:79) at org.apache.openjpa.jdbc.meta.FieldMapping.setStrategy(FieldMapping.java:120) at org.apache.openjpa.jdbc.meta.RuntimeStrategyInstaller.installStrategy(Runtim eStrategyInstaller.java:80) at org.apache.openjpa.jdbc.meta.FieldMapping.resolveMapping(FieldMapping.java:4 38) at org.apache.openjpa.jdbc.meta.FieldMapping.resolve(FieldMapping.java:403) at org.apache.openjpa.jdbc.meta.ClassMapping.resolveNonRelationMappings(ClassMa pping.java:851) at org.apache.openjpa.jdbc.meta.MappingRepository.prepareMapping(MappingReposit ory.java:324) at org.apache.openjpa.meta.MetaDataRepository.preMapping(MetaDataRepository.jav a:662) at org.apache.openjpa.meta.MetaDataRepository.resolve(MetaDataRepository.java:5 49) at org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.ja va:308) at org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.ja va:363) at org.apache.openjpa.kernel.QueryImpl.classForName(QueryImpl.java:1563) at org.apache.openjpa.kernel.ExpressionStoreQuery$1.classForName(ExpressionStor eQuery.java:108) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaData(JPQLEx pressionBuilder.java:168) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMetaData(JP QLExpressionBuilder.java:139) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JP QLExpressionBuilder.java:225) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JP QLExpressionBuilder.java:195) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateType(JPQLEx pressionBuilder.java:188) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$600(JPQLExpressi onBuilder.java:69) at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.populate(JPQ LExpressionBuilder.java:1754) at org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java:56) at org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilation(Expre ssionStoreQuery.java:153) at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:657) at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:638) at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:604 ) at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:666) at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:573) at kodo.kernel.KodoQuery.compile(KodoQuery.java:75) at org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityMana gerImpl.java:892) at org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityMana gerImpl.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:597) at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceCo ntextProxyImpl My P.xml is a very simple one <persistence-unit name="pocDS" transaction-type="JTA"> <jta-data-source>pocDS</jta-data-source> <properties> <property name="openjpa.jdbc.DBDictionary" value="oracle(UseGetBytesForBlobs=true)"/> </properties> </persistence-unit> </persistence> This works fine with actual table in database . Only view has this problem. Is there any specific configuration required when working with view ? Thanks in advance, -- View this message in context: http://openjpa.208410.n2.nabble.com/Issue-with-ID-column-for-Database-view-a s-Entity-EJB3-0-tp5237213p5237213.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
