Announcement

Collapse
No announcement yet.

SQLException DefaultQuartzScheduler

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLException DefaultQuartzScheduler

    Hi,

    I get this warning in Mirth.log file every 60 minutes exactly:

    Code:
    WARN  2007-10-01 04:13:16,072 [DefaultQuartzScheduler_Worker-10] com.webreach.mirth.plugins.messagepruner.MessagePrunerService: could not prune message database
    com.webreach.mirth.server.controllers.ControllerException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    	at com.webreach.mirth.server.controllers.ChannelController.getChannel(ChannelController.java:131)
    	at com.webreach.mirth.plugins.messagepruner.MessagePrunerService.execute(MessagePrunerService.java:187)
    	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
    Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
    	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
    	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    	at java.sql.DriverManager.getConnection(DriverManager.java:525)
    	at java.sql.DriverManager.getConnection(DriverManager.java:171)
    	at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)
    	at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222)
    	at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
    	at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
    	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
    	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
    	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
    	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
    	at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
    	at com.webreach.mirth.server.controllers.ChannelController.getChannel(ChannelController.java:129)
    	... 3 more

    The Mirth operation is correct and I am using Oracle and Mirth 1.6.1
Working...
X