Please do open a JIRA issue, even if it is a typo we need to add a testcase for your scenario.
If there's anything you can put in the JIRA to help us reproduce the problem it'll be greatly appreciated.. Thanks, -mike On Fri, Jan 30, 2009 at 3:59 PM, Fernando Padilla <[email protected]> wrote: > So the code starts to fail at svn: 739123 > > Should I open a bug?? Or will ppoddar chime in, maybe there was a typo in > this large checkin. > > > > r739123 | ppoddar | 2009-01-29 17:27:35 -0800 (Thu, 29 Jan 2009) | 1line > Changed paths: > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/conf/JDBCConfiguration.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/conf/JDBCConfigurationImpl.java > D > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/conf/QuerySQLCacheValue.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/kernel/JDBCStoreManager.java > A > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/kernel/PreparedQueryCacheImpl.java > A > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/kernel/PreparedQueryImpl.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/kernel/exps/CollectionParam.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/kernel/exps/JDBCExpressionFactory.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/kernel/exps/Param.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/meta/strats/RelationFieldStrategy.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/meta/strats/StoreCollectionFieldStrategy.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/LogicalUnion.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLBuffer.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/Select.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SelectExecutor.java > M > /openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SelectImpl.java > M > /openjpa/trunk/openjpa-jdbc/src/main/resources/org/apache/openjpa/jdbc/kernel/localizer.properties > M > /openjpa/trunk/openjpa-jdbc/src/main/resources/org/apache/openjpa/jdbc/meta/strats/localizer.properties > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/conf/OpenJPAConfiguration.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/conf/OpenJPAConfigurationImpl.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/Broker.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/BrokerImpl.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/DelegatingBroker.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/DelegatingResultList.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/FetchConfigurationImpl.java > A > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/PreparedQuery.java > A > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/PreparedQueryCache.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/QueryHints.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/QueryImpl.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/QueryLanguages.java > A > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/QueryStatistics.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/exps/CollectionParam.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/exps/ExpressionFactory.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/exps/InMemoryExpressionFactory.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/exps/Param.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/exps/Parameter.java > M > /openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/kernel/jpql/JPQLExpressionBuilder.java > M > /openjpa/trunk/openjpa-kernel/src/main/resources/org/apache/openjpa/kernel/localizer.properties > M > /openjpa/trunk/openjpa-lib/src/main/java/org/apache/openjpa/lib/rop/AbstractResultList.java > M > /openjpa/trunk/openjpa-lib/src/main/java/org/apache/openjpa/lib/rop/ResultList.java > M > /openjpa/trunk/openjpa-persistence/src/main/java/org/apache/openjpa/persistence/EntityManagerImpl.java > M > /openjpa/trunk/openjpa-persistence/src/main/java/org/apache/openjpa/persistence/OpenJPAEntityManagerSPI.java > M > /openjpa/trunk/openjpa-persistence/src/main/java/org/apache/openjpa/persistence/QueryImpl.java > D > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/kernel/TestQuerySQLCache.java > M > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/query/TestQueryParameterBinding.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Address.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Author.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Book.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/CD.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Company.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Department.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Employee.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Merchandise.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Person.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/Singer.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/TestEagerQueries.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/TestParameterProcessing.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/TestPreparedQueryCache.java > A > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/sqlcache/TestPreparedQueryCacheExclusion.java > M > /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jpql/expressions/TestEntityTypeExpression.java > M /openjpa/trunk/openjpa-project/src/doc/manual/ref_guide_caching.xml > > OPENJPA-703: Prepared Query Cache > > > > > > > 739178 -- > 739155 -- > 739148 -- > 739146 -- > 739123 -- > > 739054 ++ > 738940 ++ > 738933 ++ > 736881 ++ > 736880 ++ > > > should I create a bug? Maybe there was a typo in that commit > > > > catalina wei wrote: > >> Hi Fernando, >> >> If it is a JPQL query string, the stack trace should show JDBCStoreQuery. >> I >> could be wrong about that. >> >> Do you know the JPQL query string in your app that caused the following >> generated SQL: >> SELECT t0.JDOID, t0.CREATETIME, t0.BRACKET_JDOID, t0.GROUP0, >> t0.USER_JDOID >> FROM BRACKETEER t0 WHERE (t0.GROUP0 = ? AND t0.USER_JDOID = ?) >> >> Are you using named parameter or positional parameter in your JPQL query >> string ? >> >> Again, >> We appreciate it very much if you could send us entities involved and the >> JPQL query string issued from your app. >> >> Catalina >> >> On Fri, Jan 30, 2009 at 12:46 PM, Fernando Padilla <[email protected] >> >wrote: >> >> but my code is expecting to build JPQL queries. Could the api changed >>> some >>> how so that it's now building Native Queries, while it should be using >>> JPQL?? >>> >>> >>> >>> 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) >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>
