Setting up Oracle Datareader

[rdistler]

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>