Announcement

Collapse

Mirth Connect 4.1.1 Released!

Mirth Connect 4.1.1 is now available as an appliance update and on our GitHub page. This release contains modifications to the Welcome to Mirth Connect screen and two fixed defects. 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

Setting up Oracle Datareader

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

  • Setting up Oracle Datareader

    I am getting the following exception when I try to set up a channel with an Oracle database reader as the source. I have tried typing the jdbc url string in every way I can think of. I wrote a simple Groovy script to connect the DB from the same server I have Mirth running. I used the following url in my Groovy script:

    jdbcracle:thin:@127.0.0.1:1521:dwprod

    The source of my channel is included after the exception.

    Any help is appreciated.

    org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
    at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
    at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
    at org.mule.providers.AbstractMessageReceiver.start(A bstractMessageReceiver.java:396)
    at org.mule.providers.AbstractConnector.registerListe ner(AbstractConnector.java:518)
    at org.mule.impl.model.AbstractModel.registerListener s(AbstractModel.java:221)
    at org.mule.impl.model.AbstractModel.start(AbstractMo del.java:353)
    at org.mule.MuleManager.start(MuleManager.java:730)
    at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXmlConfigurationBuilder.java:207)
    at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXmlConfigurationBuilder.java:194)
    at com.webreach.mirth.server.Mirth.startMule(Mirth.ja va:229)
    at com.webreach.mirth.server.Mirth.restartMule(Mirth. java:186)
    at com.webreach.mirth.server.Mirth.run(Mirth.java:117 )
    Caused by: org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
    at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
    at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
    at org.mule.providers.AbstractMessageReceiver.connect (AbstractMessageReceiver.java:353)
    at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:32 )
    ... 11 more
    Caused by: org.mule.providers.ConnectException: Initialisation Failure: Io exception: Invalid connection string format, a valid format is: "//hostort/service_name"
    at com.webreach.mirth.connectors.jdbc.JdbcMessageRece iver.doConnect(JdbcMessageReceiver.java:110)
    at org.mule.providers.AbstractMessageReceiver.connect (AbstractMessageReceiver.java:360)
    at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:32 )
    ... 14 more
    Caused by: java.sql.SQLException: Io exception: Invalid connection string format, a valid format is: "//hostort/service_name"
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:334)
    at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TT C7Protocol.java:3678)
    at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.j ava:352)
    at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:365)
    at oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java:547)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:347)
    at java.sql.DriverManager.getConnection(DriverManager .java:525)
    at java.sql.DriverManager.getConnection(DriverManager .java:171)
    at com.webreach.mirth.connectors.jdbc.JdbcConnector.g etConnection(JdbcConnector.java:510)
    at com.webreach.mirth.connectors.jdbc.JdbcMessageRece iver.doConnect(JdbcMessageReceiver.java:108)
    ... 16 more


    {}



    <com.webreach.mirth.model.Channel>
    <id>531631e1-42b3-4388-a44e-edccb52246f6</id>
    <name>ELR</name>
    <description></description>
    <enabled>true</enabled>
    <version>1.6.1.2750</version>
    <revision>20</revision>
    <sourceConnector>
    <name>sourceConnector</name>
    <properties>
    <property name="ackScript"></property>
    <property name="pollingType">interval</property>
    <property name="pollingFrequency">5000</property>
    <property name="username">username</property>
    <property name="DataType">Database Reader</property>
    <property name="useAck">0</property>
    <property name="useScript">0</property>
    <property name="URL">jdbcracle:thin:@127.0.0.1:1521:dwprod</property>
    <property name="query">select PAYLOADTEXTCONTENT from PHIN_MS.ELRWORKERQUEUE where rownum &lt;=1</property>
    <property name="script"></property>
    <property name="password">password</property>
    <property name="host">query</property>
    <property name="driver">oracle.jdbc.driver.OracleDriver</property>
    <property name="ack">UPDATE</property>
    </properties>
    <transformer>
    <steps/>
    <inboundTemplate>&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
    &lt;result&gt;
    &lt;payloadtextcontent&gt;value&lt;/payloadtextcontent&gt;
    &lt;/result&gt;
    </inboundTemplate>
    <inboundProtocol>XML</inboundProtocol>
    <outboundProtocol>HL7V2</outboundProtocol>
    </transformer>
    <filter>
    <rules/>
    </filter>
    <transportName>Database Reader</transportName>
    <mode>SOURCE</mode>
    <enabled>true</enabled>
    </sourceConnector>
    <destinationConnectors>
    <com.webreach.mirth.model.Connector>
    <name>Destination 1</name>
    <properties>
    <property name="charsetEncoding">DEFAULT_ENCODING</property>
    <property name="outputAppend">1</property>
    <property name="DataType">File Writer</property>
    <property name="outputPattern">elr.data</property>
    <property name="template">${message.rawData}</property>
    <property name="host">/var/data/mirth</property>
    <property name="binary">0</property>
    </properties>
    <transformer>
    <steps/>
    <inboundProtocol>HL7V2</inboundProtocol>
    <outboundProtocol>HL7V2</outboundProtocol>
    </transformer>
    <filter>
    <rules/>
    </filter>
    <transportName>File Writer</transportName>
    <mode>DESTINATION</mode>
    <enabled>true</enabled>
    </com.webreach.mirth.model.Connector>
    </destinationConnectors>
    <properties>
    <property name="synchronous">true</property>
    <property name="removeNamespace">true</property>
    <property name="transactional">false</property>
    <property name="initialState">started</property>
    <property name="dont_store_filtered">false</property>
    <property name="error_messages_only">false</property>
    <property name="max_message_age">-1</property>
    <property name="store_messages">true</property>
    <property name="encryptData">false</property>
    </properties>
    <preprocessingScript>// Modify the message variable below to pre process data
    return message;</preprocessingScript>
    <postprocessingScript>// This script executes once after a message has been processed
    return;</postprocessingScript>
    <deployScript>// This script executes once when the mule engine is started
    // You only have access to the globalMap here to persist data
    return;</deployScript>
    <shutdownScript>// This script executes once when the mule engine is stopped
    // You only have access to the globalMap here to persist data
    return;</shutdownScript>
    </com.webreach.mirth.model.Channel>
Working...
X