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)
