Announcement

Collapse
No announcement yet.

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