openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trenton D. Adams" <tr...@trentonadams.ca>
Subject Re: ReportingSQLException: Protocol violation
Date Fri, 14 Jan 2011 00:57:49 GMT
On 11-01-13 11:32 AM, Angelo K. Huang wrote:
>
> 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?

No; that's partly what leads me to believe it's some sort of 
communication error, with maybe the network, or dropped connections, 
etc.  Also the phrase "protocol error" gives a bit of hint too.

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


Mime
View raw message