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