You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by Fernando Padilla <fe...@alum.mit.edu> on 2009/01/30 20:47:40 UTC
snapshot build failing..
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.User@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)
Re: snapshot build failing..
Posted by catalina wei <ca...@gmail.com>.
Hi Fernando,
Could you please help us verify if the latest commit (r740208) by Pinaki
resolved your problem ?
Appreciate it greatly.
Catalina Wei
On Fri, Jan 30, 2009 at 2:47 PM, Pinaki Poddar <pp...@apache.org> wrote:
>
> Hi,
> 1. Set <property name="openjpa.QuerySQLCache" value="false"/>
>
> 2. Send the query and the parameters being set.
>
>
> --
> View this message in context:
> http://n2.nabble.com/snapshot-build-failing..-tp2246748p2247614.html
> Sent from the OpenJPA Developers mailing list archive at Nabble.com.
>
>
Re: snapshot build failing..
Posted by Pinaki Poddar <pp...@apache.org>.
Hi,
1. Set <property name="openjpa.QuerySQLCache" value="false"/>
2. Send the query and the parameters being set.
--
View this message in context: http://n2.nabble.com/snapshot-build-failing..-tp2246748p2247614.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.
Re: snapshot build failing..
Posted by Fernando Padilla <fe...@alum.mit.edu>.
thank you. I have a bug filed:
https://issues.apache.org/jira/browse/OPENJPA-886
:) :)
Michael Dick wrote:
> 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 <fe...@alum.mit.edu> 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 <fern@alum.mit.edu
>>>> 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 <fern@alum.mit.edu
>>>>>
>>>>>> 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.User@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)
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>
Re: snapshot build failing..
Posted by Michael Dick <mi...@gmail.com>.
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 <fe...@alum.mit.edu> 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 <fern@alum.mit.edu
>> >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 <fern@alum.mit.edu
>>>>
>>>>> 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.User@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)
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>
Re: snapshot build failing..
Posted by Fernando Padilla <fe...@alum.mit.edu>.
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 <fe...@alum.mit.edu>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 <fern@alum.mit.edu
>>>> 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.User@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)
>>>>
>>>>
>>>>
>>>>
>>>>
>
Re: snapshot build failing..
Posted by catalina wei <ca...@gmail.com>.
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 <fe...@alum.mit.edu>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 <fern@alum.mit.edu
>> >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.User@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)
>>>
>>>
>>>
>>>
>>>
>>
Re: snapshot build failing..
Posted by Fernando Padilla <fe...@alum.mit.edu>.
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 <fe...@alum.mit.edu>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.User@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)
>>
>>
>>
>>
>
Re: snapshot build failing..
Posted by Fernando Padilla <fe...@alum.mit.edu>.
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 <fe...@alum.mit.edu>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.User@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)
>>
>>
>>
>>
>
Re: snapshot build failing..
Posted by catalina wei <ca...@gmail.com>.
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 <fe...@alum.mit.edu>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.User@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)
>
>
>
>