geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zakharov, Vasily M" <vasily.m.zakha...@intel.com>
Subject RE: [jira] Commented: (GERONIMO-1046) ORA-00920 SQL Exception thrown when testing day trader with Oracle
Date Mon, 19 Jun 2006 15:48:21 GMT
Matt,

What do you mean by plans you corrected?

And by "select for update" we need to be able to specify?

 Vasily


-----Original Message-----
From: Matt Hogstrom [mailto:matt@hogstrom.org] 
Sent: Saturday, June 17, 2006 5:48 AM
To: dev@geronimo.apache.org
Subject: Re: [jira] Commented: (GERONIMO-1046) ORA-00920 SQL Exception
thrown when testing day trader with Oracle

Thanks Vasily,

I have corrected the plans.  How are the plans going for Oracle?  I
think that we need to be able to 
specify select for update to achieve the right consistency level for
SPECj2004.  Curious what your 
feedback is.

Vasily Zakharov (JIRA) wrote:
>     [
http://issues.apache.org/jira/browse/GERONIMO-1046?page=comments#action_
12416551 ] 
> 
> Vasily Zakharov commented on GERONIMO-1046:
> -------------------------------------------
> 
> There's a typo in this bug's resolution - the package name for
<ejb-ql-compiler-factory> is org.tranql.ejbQLcompiler.
> 
> So the right line would be:
> 
>
<ejb-ql-compiler-factory>org.tranql.ejbqlcompiler.OracleEJBQLCompilerFac
tory</ejb-ql-compiler-factory>
> 
> 
>> ORA-00920 SQL Exception thrown when testing day trader with Oracle
>> ------------------------------------------------------------------
>>
>>          Key: GERONIMO-1046
>>          URL: http://issues.apache.org/jira/browse/GERONIMO-1046
>>      Project: Geronimo
>>         Type: Bug
>>     Security: public(Regular issues) 
>>     Versions: 1.0
>>  Environment: All
>>     Reporter: Matt Hogstrom
>>     Assignee: Matt Hogstrom
>>      Fix For: 1.0
> 
>> The following exception occurs when running day trader with Oracle:
>> 15:54:36,575 WARN  [/trade] /trade/app: java.rmi.RemoteException:
Unable to commit container transaction; nested exception is:
>>         javax.transaction.SystemException: Unable to commit container
transaction
>>         at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
va(Compiled Code))
>>         at
org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$c46b8cb8.login(<gen
erated>)
>>         at
org.apache.geronimo.samples.daytrader.TradeAction.login(TradeAction.java
:421)
>>         at
org.apache.geronimo.samples.daytrader.web.TradeServletAction.doLogin(Tra
deServletAction.java:341)
>>         at
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.performTask(Tr
adeAppServlet.java:124)
>>         at
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.doPost(TradeAp
pServlet.java:86)
>>         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
>>         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>         at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
>>         at
org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.j
ava:99)
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(Web
ApplicationHandler.java:830)
>>         at
org.apache.geronimo.samples.daytrader.web.OrdersAlertFilter.doFilter(Ord
ersAlertFilter.java:84)
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(Web
ApplicationHandler.java:821)
>>         at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171)
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(
>> WebApplicationHandler.java:821)
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
>> onHandler.java:471)
>>         at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
>> 68)
>>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
>>         at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
>> Context.java:635)
>>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
>>         at org.mortbay.http.HttpServer.service(HttpServer.java:954)
>>         at
org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
>>         at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
>>         at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
>>         at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
>> 244)
>>         at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
>>         at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
>> Caused by: javax.transaction.SystemException: Unable to commit
container transac
>> tion
>>         at
org.apache.geronimo.transaction.context.InheritableTransactionContext
>> .rollbackAndThrow(InheritableTransactionContext.java:327)
>>         at
org.apache.geronimo.transaction.context.InheritableTransactionContext
>> .complete(InheritableTransactionContext.java(Compiled Code))
>>         at
org.apache.geronimo.transaction.context.InheritableTransactionContext
>> .commit(InheritableTransactionContext.java(Compiled Code))
>>         at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPo
>> licy.java(Compiled Code))
>>         at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transact
>> ionContextInterceptor.java(Compiled Code))
>>         at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionIntercep
>> tor.java(Compiled Code))
>>         at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java(Compi
>> led Code))
>>         ... 27 more
>> Caused by: org.tranql.ql.QueryException: Error executing statement:
UPDATE Accou
>> ntEJB SET creationDate = CASE WHEN ? THEN ? ELSE creationDate END,
openBalance =
>>  CASE WHEN ? THEN ? ELSE openBalance END, logoutCount = CASE WHEN ?
THEN ? ELSE
>> logoutCount END, balance = CASE WHEN ? THEN ? ELSE balance END,
lastLogin = CASE
>>  WHEN ? THEN ? ELSE lastLogin END, loginCount = CASE WHEN ? THEN ?
ELSE loginCou
>> nt END, profile_userID = CASE WHEN ? THEN ? ELSE profile_userID END
WHERE accoun
>> tID = ?
>>         at
org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java(
>> Compiled Code))
>>         at
org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java(C
>> ompiled Code))
>>         at
org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java(C
>> ompiled Code))
>>         at org.tranql.cache.InTxCache.flush(InTxCache.java(Inlined
Compiled Code
>> ))
>>         at
org.apache.geronimo.transaction.context.AbstractTransactionContext.fl
>> ushState(AbstractTransactionContext.java(Compiled Code))
>>         ... 33 more
>> Caused by: java.sql.SQLException: ORA-00920: invalid relational
operator
>>         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
>> :124)
>>         at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Compiled Cod
>> e))
>>         at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Inlined Comp
>> iled Code))
>>         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java(Compiled
Code))
>>         at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
>> java(Compiled Code))
>>         at
oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS
>> tatement.java(Compiled Code))
>>         at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
>> nt.java(Compiled Code))
>>         at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
>> aredStatement.java(Compiled Code))
>>         at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
>> edStatement.java(Compiled Code))
>>         at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(Prepa
>> redStatementHandle.java(Compiled Code))
>>         ... 38 more
>> 15:54:36,585 WARN  [ServletHandler] /trade/app:
>> java.rmi.RemoteException: Unable to commit container transaction;
nested excepti
>> on is:
>>         javax.transaction.SystemException: Unable to commit container
transactio
>> n
>>         at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor
>> .java(Compiled Code))
>>         at
org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$c46b8cb8.login(<
>> generated>)
>>         at
org.apache.geronimo.samples.daytrader.TradeAction.login(TradeAction.j
>> ava:421)
>>         at
org.apache.geronimo.samples.daytrader.web.TradeServletAction.doLogin(
>> TradeServletAction.java:341)
>>         at
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.performTask
>> (TradeAppServlet.java:124)
>>         at
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.doPost(Trad
>> eAppServlet.java:86)
>>         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
>>         at
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>         at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427
>> )
>>         at
org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolde
>> r.java:99)
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(
>> WebApplicationHandler.java:830)
>>         at
org.apache.geronimo.samples.daytrader.web.OrdersAlertFilter.doFilter(
>> OrdersAlertFilter.java:84)
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(
>> WebApplicationHandler.java:821)
>>         at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171
>> )
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(
>> WebApplicationHandler.java:821)
>>         at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
>> onHandler.java:471)
>>         at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
>> 68)
>>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
>>         at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
>> Context.java:635)
>>         at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
>>         at org.mortbay.http.HttpServer.service(HttpServer.java:954)
>>         at
org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
>>         at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
>>         at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
>>         at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
>> 244)
>>         at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
>>         at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
>> Caused by: javax.transaction.SystemException: Unable to commit
container transac
>> tion
>>         at
org.apache.geronimo.transaction.context.InheritableTransactionContext
>> .rollbackAndThrow(InheritableTransactionContext.java:327)
>>         at
org.apache.geronimo.transaction.context.InheritableTransactionContext
>> .complete(InheritableTransactionContext.java(Compiled Code))
>>         at
org.apache.geronimo.transaction.context.InheritableTransactionContext
>> .commit(InheritableTransactionContext.java(Compiled Code))
>>         at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPo
>> licy.java(Compiled Code))
>>         at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transact
>> ionContextInterceptor.java(Compiled Code))
>>         at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionIntercep
>> tor.java(Compiled Code))
>>         at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java(Compi
>> led Code))
>>         ... 27 more
>> Caused by: org.tranql.ql.QueryException: Error executing statement:
UPDATE Accou
>> ntEJB SET creationDate = CASE WHEN ? THEN ? ELSE creationDate END,
openBalance =
>>  CASE WHEN ? THEN ? ELSE openBalance END, logoutCount = CASE WHEN ?
THEN ? ELSE
>> logoutCount END, balance = CASE WHEN ? THEN ? ELSE balance END,
lastLogin = CASE
>>  WHEN ? THEN ? ELSE lastLogin END, loginCount = CASE WHEN ? THEN ?
ELSE loginCou
>> nt END, profile_userID = CASE WHEN ? THEN ? ELSE profile_userID END
WHERE accoun
>> tID = ?
>>         at
org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java(
>> Compiled Code))
>>         at
org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java(C
>> ompiled Code))
>>         at
org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java(C
>> ompiled Code))
>>         at org.tranql.cache.InTxCache.flush(InTxCache.java(Inlined
Compiled Code
>> ))
>>         at
org.apache.geronimo.transaction.context.AbstractTransactionContext.fl
>> ushState(AbstractTransactionContext.java(Compiled Code))
>>         ... 33 more
>> Caused by: java.sql.SQLException: ORA-00920: invalid relational
operator
>>         at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
>> :124)
>>         at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Compiled Cod
>> e))
>>         at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Inlined Comp
>> iled Code))
>>         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java(Compiled
Code))
>>         at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
>> java(Compiled Code))
>>         at
oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS
>> tatement.java(Compiled Code))
>>         at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
>> nt.java(Compiled Code))
>>         at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
>> aredStatement.java(Compiled Code))
>>         at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
>> edStatement.java(Compiled Code))
>>         at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(Prepa
>> redStatementHandle.java(Compiled Code))
>>         ... 38 more
> 

Mime
View raw message