ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Annapoorna Chandra <apurna.chan...@gmail.com>
Subject Re: Oracle issues with ODE 1.3.2 on glassfish appserver
Date Wed, 08 Jul 2009 19:34:57 GMT
Some how my I'm unable to see attached error so I'm pasting it here.

This is the error I'm seeing


ERROR org.apache.ode.bpel.engine.BpelEngineImpl  - Scheduled job failed;
<openjpa-1.1.0-r422266:659716 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: ORA-01453: SET
TRANSACTION must be first statement of transaction

    at
org.apache.openjpa.jdbc.sql.SQLExceptions.narrow(SQLExceptions.java:146)
    at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4150)
    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.JDBCStoreManager.connect(JDBCStoreManager.java:762)
    at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getConnection(JDBCStoreManager.java:215)
    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:349)
    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:328)
    at
org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:407)
    at
org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:218)
    at
org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:208)
    at
org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
    at
org.apache.openjpa.jdbc.kernel.PagingResultObjectProvider.open(PagingResultObjectProvider.java:192)
    at
org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:57)
    at
org.apache.openjpa.jdbc.kernel.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:222)
    at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1222)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:989)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:847)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:778)
    at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525)
    at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:237)
    at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:277)
    at
org.apache.ode.dao.jpa.ProcessDAOImpl.getCorrelator(ProcessDAOImpl.java:95)
    at
org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.findRoute(PartnerLinkMyRoleImpl.java:112)
    at
org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:230)
    at
org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:408)
    at
org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:439)
    at
org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:441)
    at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:411)
    at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:405)
    at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218)
    at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:404)
    at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:401)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: ORA-01453: SET TRANSACTION must be first
statement of transaction

    at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
    at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
    at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
    at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
    at
oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:3971)
    at
com.sun.gjc.spi.base.ConnectionHolder.setTransactionIsolation(ConnectionHolder.java:694)
    at
org.apache.openjpa.lib.jdbc.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:257)
    at
org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:95)
    at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:100)
    at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:88)
    at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal(JDBCStoreManager.java:773)
    at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:758)
    ... 33 more




On Wed, Jul 8, 2009 at 12:59 PM, Annapoorna Chandra <
apurna.chandra@gmail.com> wrote:

> Hi,
> This is my first post . need help regarding the issue
>    My system configuration is like this
>
>    Appserver - Glassfish
>    Database used for ODE - Oracle 10g
>    Apache ODE version -1.3.2
>   Java Version- 1.6.0_13
>
>   I have a webapp which use Ode 1.3.2 and Oracle Database deployed on
> Glassfish.
>
>   1)I have recreated ode tables in oracle.
>   2) added ojdbc14-10.2.0.jar to glasfish lib
>
>   I have set up a JNDI resource from  glassfish admin console and tested
> the connection . connection is successful.
>
> deployed webapp that uses this JNDI specified in
> ode-axis2.properties.(tested this with sample java app it worked fine and
> also tested ode deployment with out specfying JNDI resource which throw me
> an exception saying lookup failed)
>
> also deployed workflow where deployment succeeded with out errors.
>
> When I call operation in workflow from a client I see error.  Attaching
> error to this Message.
>
> * I have following configurations and works fine*
>
> 1) ODE 1.3.2 ,sqlserver ODE database on Glassfish
> 2) ODE 1.3.2 ,sqlserver ODE database on Tomcat 6.0.18(also tried on 5.x
> versionS)
> 3) ODE 1.2 ,sqlserver ODE database on Glassfish
> 4) ODE 1.2 ,sqlserver ODE database on Tomcat
> 5) ODE 1.2 ,Oracle  ODE database on Glassfish
> 6) ODE 1.2 ,Oracle ODE database on Tomcat
> 7)ODE 1.3.2 ,Oracle ODE database on Tomcat
> ( Intially I saw same error on Tomcat with oracle ode1.3.2 , Then modified
>
> Resource in Server.xml * from*
>
> <Context path="/App" docBase="App" debug="5" reloadable="true"
> crossContext="true">
>         <Resource name="jdbc/ODEDB" auth="Container"
> type="javax.sql.DataSource"
>             maxActive="100" maxIdle="30" maxWait="10000" username="user"
> password="password"
>         driverClassName="oracle.jdbc.driver.OracleDriver"
>         url="jdbc:oracle:thin:@hostname:port:SID"/>
>     </Context>
>
>  *to*
>
> <Context path="/App" docBase="App" debug="5" reloadable="true"
> crossContext="true">
>             <Resource name="jdbc/ODEDB" auth="Container"
> type="oracle.jdbc.pool.OracleDataSource"
> factory="oracle.jdbc.pool.OracleDataSourceFactory" maxActive="20"
> maxIdle="30" maxWait="10000" user="user" password="password"
> driverClassName="oracle.jdbc.OracleDriver"  url="jdbc:oracle:thin:@hostname
> :port:SID""/>
>         </Context>
>
> and copied openjpa1.1.0.jar instead of openjpa1.3.0-SNAPSHOT.jar into
> WEB-INF/lib.
>
>
> )
>
>
>
> *My connection pool settings on Glassfish*
>
>  <jdbc-connection-pool allow-non-component-callers="false"
> associate-with-thread="false" connection-creation-retry-attempts="0"
> connection-creation-retry-interval-in-seconds="10"
> connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
> connection-validation-method="auto-commit"
> datasource-classname="oracle.jdbc.pool.OracleDataSource"
> fail-all-connections="false" idle-timeout-in-seconds="300"
> is-connection-validation-required="false"
> is-isolation-level-guaranteed="true" lazy-connection-association="false"
> lazy-connection-enlistment="false" match-connections="false"
> max-connection-usage-count="0" max-pool-size="32"
> max-wait-time-in-millis="60000" name="oracle"
> non-transactional-connections="false" pool-resize-quantity="2"
> res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1"
> steady-pool-size="8" transaction-isolation-level="read-committed"
> validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
>       <property name="URL" value="jdbc:oracle:thin:@hostname:port:SID"/>
>       <property name="NetworkProtocol" value="tcp"/>
>       <property name="PortNumber" value="portnum"/>
>       <property name="Password" value="password"/>
>       <property name="ServerName" value="hostname"/>
>       <property name="DatabaseName" value="SID"/>
>       <property name="User" value="user"/>
>       <property name="DataSourceName" value="OracleDataSource"/>
>     </jdbc-connection-pool>
>
>
> same settings worked with ODE1.2+Oracle ODEDB on glassfish
>
> One morething to add is If I don't use Database for ODE i.e if I write
> everything to memory it works fine. I don't want to follow this approach
> because I need to handle large  binary data .
>
>
> I moved to ODE1.3.2 because of WS Security and My backend need to be
> Oracle.
>
>
> Is there any alternative way to specify External DB for ODE besides the
> approach I'm using?
>
>
>
> --
> Annapoorna
>



-- 
Annapoorna

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message