the thing is, that it's not a native sql.. it's jpql..
I did take it back to before 736881 and it's working. I'm trying to get our developers that build, after that I'll try to narrow down which revision breaks it.
catalina wei wrote:
Hi Fernando, From the stack trace, it looks to me the parameters are for a native SQL. We may have introduced problems in handling parameters for native queries. Could you help us isolating the problem ? Could you extract svn revision r738940 and see if that commit introduced the problem ? If possible, could you provide us entities source code for reproducing the problem ? Thank you very much. Catalina Wei On Fri, Jan 30, 2009 at 11:47 AM, Fernando Padilla <[email protected]>wrote:So.. we came in today and our app has stopped working. Simple queries that worked yesterday are not working today. Anyone having this issue? Any ideas before I have to start to figure out which commit caused this?? We have two entities, Bracketeer and User. @Entity public class Bracketeer extends HBaseIdCreateTime implements IBracketeer { ... @Persistent @Externalizer( "getIdLong" ) private BracketGroupId group; @ManyToOne @JoinColumn( name = "USER_JDOID" ) private User user; ... } @Entity public class User extends HBaseIdCreateTime implements UnifiedSocialUser { ... } Now all queries trying to get Bracketeers keep failing.. "specified paramter of type "..." is not a valid query parameter." First it was failing against the User field, now it's failing against the group field.. 2009-01-30 11:28:42,483 [btpool0-2] ERROR com.protrade.bracket.fbsite.filters.AppSubscriptionHandler - The specified parameter of type "class com.protrade.bracket.data.entities.User" is not a valid query parameter. <openjpa-2.0.0-SNAPSHOT-r422266:739178 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: The specified parameter of type "class com.protrade.bracket.data.entities.User" is not a valid query parameter. at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1354) at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeQuery(SQLStoreQuery.java:314) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:997) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:846) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:777) at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525) at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274) at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:284) at com.protrade.common.persistence.JPAUtil.execute(JPAUtil.java:195) at com.protrade.common.persistence.JPAUtil.execute(JPAUtil.java:170) at com.protrade.common.persistence.JPAUtil.executeList(JPAUtil.java:155) at com.protrade.common.persistence.JPADQuery.list(JPADQuery.java:24) at com.protrade.common.persistence.BaseRootDAOBase.runListQueryWithListNCS(BaseRootDAOBase.java:272) at com.protrade.common.persistence.BaseRootDAOBase.findByFieldsNCS(BaseRootDAOBase.java:199) at com.protrade.common.persistence.BaseRootDAOBase.existsByFieldsNCS(BaseRootDAOBase.java:236) at com.protrade.common.persistence.BaseDAOBase.existsByFieldsNCS(BaseDAOBase.java:144) at com.protrade.bracket.data.BracketDao.isBracketeer(BracketDao.java:152) 2009-01-30 11:43:31,349 [btpool0-1] DEBUG openjpa.Query - Executing query: [SELECT t0.JDOID, t0.CREATETIME, t0.BRACKET_JDOID, t0.GROUP0, t0.USER_JDOID FROM BRACKETEER t0 WHERE (t0.GROUP0 = ? AND t0.USER_JDOID = ?)] with parameters: {1=com.protrade.bracket.data.entities.u...@b1406b[ fbId=578696943 appAdded=false recruiter=<null> numMinibrackets=0 numBrackets=0 createTime=1233343722122 idLong=9000 jdoId=<null> jdoversion=0 ], 0=<<BracketGroupId:BracketGroup:32>>} 2009-01-30 11:43:31,366 [btpool0-1] ERROR com.protrade.bracket.fbsite.filters.AppSubscriptionHandler - The specified parameter of type "class com.protrade.bracket.data.entities.BracketGroupId" is not a valid query parameter. <openjpa-2.0.0-SNAPSHOT-r422266:739178 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: The specified parameter of type "class com.protrade.bracket.data.entities.BracketGroupId" is not a valid query parameter. at org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1354) at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeQuery(SQLStoreQuery.java:314) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:997) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:846) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:777) at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525) at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274) at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:284)
