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 <
[email protected]> 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
