[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register /  [Login] Login 
[Expert]
Quartz runing against clustered Oracle  XML
Forum Index -> Quartz
Author Message
[Post New]12/14/2009 14:14:19
    Subject: Quartz runing against clustered Oracle
[Up]
bradleyw

master

Joined: 11/30/2009 14:39:53
Messages: 53
Offline
Will look for more information about the Oracle environment but we're running into issues running Quartz 1.6.0 against a clustered Oracle instance in our application:
Code:
 2009-12-03 16:50:11,488 WARN  [AttributeRestoringConnectionInvocationHandler] : Failed restore connection's original auto commit setting.
 java.sql.SQLException: Closed Connection
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
 	at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:1241)
 	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)
 	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293)
 	at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.java:134)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3453)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3090)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3749)
 2009-12-03 16:50:11,489 WARN  [AttributeRestoringConnectionInvocationHandler] : Failed restore connection's original auto commit setting.
 java.sql.SQLException: Closed Connection
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
 	at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:1241)
 	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)
 	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293)
 	at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.java:134)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3453)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3124)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3749)
 2009-12-03 16:50:11,490 ERROR [LocalDataSourceJobStore] : ClusterManager: Error managing cluster: null
 java.lang.reflect.UndeclaredThrowableException
 	at $Proxy121.rollback(Unknown Source)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3503)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3084)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713)
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3749)
 Caused by: java.lang.reflect.InvocationTargetException
 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 	at java.lang.reflect.Method.invoke(Unknown Source)
 	at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)
 	... 5 more
 Caused by: java.sql.SQLException: Closed Connection
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
 	at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1412)
 	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
 	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)
 	... 10 more
[Post New]12/14/2009 17:11:16
    Subject: Re:Quartz runing against clustered Oracle
[Up]
steve

ophanim

Joined: 05/24/2006 14:22:53
Messages: 619
Offline
James will probably poke his head in on this one but I thought I would mention that we have a beta of clustering quartz with Terracotta. It's faster and easier to get started with and just as free if your interested in giving it a try.

http://www.terracotta.org/quartz/get-started
Want to post to this forum? Join the Terracotta Community
[Post New]12/15/2009 07:04:18
    Subject: Re:Quartz runing against clustered Oracle
[Up]
jhouse

seraphim
[Avatar]
Joined: 11/06/2009 15:29:56
Messages: 1703
Offline

Is there no error in the logs before this one? Per the exception, something has closed the connection.

 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team