It works. Thank you Fay. It seems I made a crappy error. Fay Wang wrote: > > Hi, > Please do the following: > > select j from job j > > > -fay > > --- On Tue, 7/8/08, tao <[EMAIL PROTECTED]> wrote: > >> From: tao <[EMAIL PROTECTED]> >> Subject: Query problem with open jpa 1.0.2 >> To: [email protected] >> Date: Tuesday, July 8, 2008, 3:30 PM >> Hi, I'm working on a project using openjpa 1.0.2. I got >> org.apache.openjpa.persistence.ArgumentException while >> executing a simple >> query today, wish someone can help me on this issue. Thanks >> >> The query I'm trying to execute is: >> "select job from job j" >> Moreover there is no problem for me to create a new job >> record. >> >> Three related persistence classes are defined as the >> following: >> >> @Table(name = "job") >> @Entity(name = "job") >> public class Job implements Serializable{ >> @Id >> @Column (name = "job_id") >> @GeneratedValue(strategy = GenerationType.IDENTITY) >> private long jobId; >> >> @Column (name = "job_name", length = 255, >> nullable = false) >> private String jobName; >> >> @Column >> private String status; >> >> @ManyToOne (optional = false) >> @JoinColumn(name = "create_by", >> referencedColumnName = "user_id") >> private User createUser; >> >> @Column (name = "create_time") >> private Date createTime; >> >> @ManyToOne (optional = true) >> @JoinColumn(name = "update_by", >> referencedColumnName = "user_id") >> private User updateUser; >> >> @Column (name = "update_time") >> private Date updateTime; >> >> @ManyToOne (optional = false, fetch = FetchType.EAGER) >> @JoinColumn(name = "proj_lead_id", >> referencedColumnName = "user_id") >> private User projectLead; >> >> @ManyToOne (optional = false, fetch = FetchType.EAGER) >> @JoinColumn(name = "designer_id", >> referencedColumnName = "user_id") >> private User designer; >> >> @Column (name = "approve_by") >> private String approveBy; >> >> @Column (name = "concept_date") >> private Date conceptDate; >> >> @Column (name = "vendor_due_date") >> private Date vendorDueDate; >> >> @Column (name = "release_date") >> private Date releaseDate; >> ... >> } >> >> @Entity(name = "user") >> @Table(name = "usr_user") >> public class User implements Serializable { >> >> private static final long serialVersionUID = 3L; >> >> @Id >> @Column (name = "user_id") >> @GeneratedValue(strategy = GenerationType.IDENTITY) >> private long userId; >> >> @Column >> private String password; >> >> @Column (name = "user_name", length = 20, >> nullable = false) >> private String userName; >> >> @Column (name = "first_name", length = 32, >> nullable = false) >> private String firstName; >> >> @Column (name = "last_name", length = 32, >> nullable = false) >> private String lastName; >> >> @Column (name = "mid_name", length = 20, >> nullable = true) >> private String midName; >> >> @ManyToOne (optional = false, fetch = >> FetchType.EAGER) >> @JoinColumn(name = "role_id", >> referencedColumnName = "role_id") >> private Role role; >> >> ... >> } >> >> @Entity (name = "role") >> @Table(name = "role") >> public class Role { >> @Id >> @Column (name="role_id") >> @GeneratedValue(strategy = GenerationType.IDENTITY) >> private long roleId; >> >> @Column (name="role_name", length = 20, nullable >> = false) >> private String roleName; >> ... >> } >> >> and the exception details I got are >> javax.faces.FacesException: Error calling action method of >> component with id >> job-search-form:search-button >> at >> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:69) >> at >> javax.faces.component.UICommand.broadcast(UICommand.java:121) >> at >> javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:292) >> at >> javax.faces.component.UIViewRoot.process(UIViewRoot.java:209) >> at >> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:117) >> at >> org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32) >> at >> org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103) >> at >> org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76) >> at >> javax.faces.webapp.FacesServlet.service(FacesServlet.java:148) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) >> at >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) >> at >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) >> at java.lang.Thread.run(Thread.java:595) >> Caused by: javax.faces.el.EvaluationException: >> javax.el.ELException: >> /web/searchJob.xhtml @278,43 >> action="#{jobBacking.search}": >> org.springframework.dao.InvalidDataAccessApiUsageException: >> nested exception >> is <openjpa-1.0.2-r420667:627158 nonfatal user error> >> org.apache.openjpa.persistence.ArgumentException: null >> at >> javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:79) >> at >> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:54) >> ... 23 more >> Caused by: javax.el.ELException: /web/searchJob.xhtml >> @278,43 >> action="#{jobBacking.search}": >> org.springframework.dao.InvalidDataAccessApiUsageException: >> nested exception >> is <openjpa-1.0.2-r420667:627158 nonfatal user error> >> org.apache.openjpa.persistence.ArgumentException: null >> at >> com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:74) >> at >> javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:75) >> ... 24 more >> Caused by: >> org.springframework.dao.InvalidDataAccessApiUsageException: >> nested exception is <openjpa-1.0.2-r420667:627158 >> nonfatal user error> >> org.apache.openjpa.persistence.ArgumentException: null >> at >> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:269) >> at >> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120) >> at >> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:212) >> at >> org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152) >> at >> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:190) >> at >> org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:152) >> at >> org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:299) >> at >> org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:295) >> at com.xyz.dao.JobDAO.searchJob(JobDAO.java:209) >> 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:585) >> at >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) >> at $Proxy11.searchJob(Unknown Source) >> at com.xyz.backing.JobBacking.search(JobBacking.java:157) >> 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:585) >> at org.apache.el.parser.AstValue.invoke(AstValue.java:152) >> at >> org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) >> at >> com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68) >> ... 25 more >> Caused by: <openjpa-1.0.2-r420667:627158 nonfatal user >> error> >> org.apache.openjpa.persistence.ArgumentException: null >> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:808) >> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:769) >> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:765) >> at >> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517) >> at >> org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:238) >> at >> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:277) >> at >> org.springframework.orm.jpa.JpaTemplate$9.doInJpa(JpaTemplate.java:307) >> at >> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:185) >> ... 44 more >> Caused by: java.lang.NullPointerException >> at >> org.apache.openjpa.jdbc.kernel.exps.PCPath.initialize(PCPath.java:445) >> at >> org.apache.openjpa.jdbc.kernel.exps.SelectConstructor.initialize(SelectConstructor.java:197) >> at >> org.apache.openjpa.jdbc.kernel.exps.SelectConstructor.newSelect(SelectConstructor.java:119) >> at >> org.apache.openjpa.jdbc.kernel.exps.SelectConstructor.evaluate(SelectConstructor.java:73) >> at >> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.createWhereSelects(JDBCStoreQuery.java:331) >> at >> org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeQuery(JDBCStoreQuery.java:171) >> at >> org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeQuery(ExpressionStoreQuery.java:676) >> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:988) >> at >> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:799) >> ... 51 more >> -- >> View this message in context: >> http://n2.nabble.com/Query-problem-with-open-jpa-1.0.2-tp395802p395802.html >> Sent from the OpenJPA Users mailing list archive at >> Nabble.com. > > > > >
-- View this message in context: http://n2.nabble.com/Query-problem-with-open-jpa-1.0.2-tp395802p470863.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
