web stats
Setting up Oracle Datareader - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2007, 01:35 PM
rdistler rdistler is offline
What's HL7?
 
Join Date: Aug 2007
Posts: 1
rdistler
Default 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>
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up SSL tunnels on Mirth okken Support 5 09-15-2010 02:59 AM
oracle-database.sql cpettazzi Support 1 10-22-2008 10:58 AM
Help with setting up my first channel siliconburn Support 1 08-26-2008 09:41 AM
Driver for Oracle 9i hope Support 1 09-11-2007 11:20 AM
Mirth Administrator does not retain "Send ACK: NO" setting nshaik Support 1 09-19-2006 08:35 AM


All times are GMT -8. The time now is 11:29 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation