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) > > > >
