openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Angelo K. Huang" <angel...@ymail.com>
Subject Re: ReportingSQLException: Protocol violation
Date Thu, 13 Jan 2011 18:32:57 GMT

I couldn't find any ORA error in our server log or application log when this
error happens.

For Trenton, 
Did you see any ORA error in your cases?


This is whole stack trace.

Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Protocol violation
{prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status,
t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path,
t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time,
t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0
WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ?
[params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999]       
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
        at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
        at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
        at
org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:64)
        at
org.apache.openjpa.jdbc.kernel.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:234)
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771)
        at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
        at
org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:255)
        at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
        at
org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:609)
        at
org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:567)
        at
org.apache.oozie.store.CoordinatorStore.doOperation(CoordinatorStore.java:425)
        ... 40 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Protocol
violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name,
t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time,
t0.app_path, t0.concurrency, t0.frequency, t0.last_action,
t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out
FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC)
WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]}
[code=17401, state=99999]
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
        at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
        at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1595)
        at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
        at
org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:496)
        at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)
        at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325)
        at
org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:331)
        at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
        at
org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:57)
        ... 52 more





-- 
View this message in context: http://openjpa.208410.n2.nabble.com/ReportingSQLException-Protocol-violation-tp5913554p5919255.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Mime
View raw message