Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

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