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

Error while retrieving data from multiple tables

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error while retrieving data from multiple tables

    Hi All,

    I want to take data from multiple tables. My query is something like
    Select table1.field1,table1.field2,table2.field3 from table1,table2 where....

    But I am getting an error when I try to deploy the channel.

    org.mule.umo.routing.RoutingException: Failed to transform message before applying the filter. Failed to route event via endpoint: ImmutableMuleEndpoint{connector=com.webreach.mirth [email protected], endpointUri=jdbc://query, transformer=Transformer{name='ResultMapToXML', returnClass=false, returnClass=false, sourceTypes=[interface java.util.Map, class java.lang.String]}, name='_jdbcEndpoint#865460336', type='receiver', properties={}, transactionConfig=org.mule.impl.MuleTransactionCon [email protected], filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=true, initialState=started, createConnector=0}. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
    at org.mule.routing.inbound.SelectiveConsumer.isMatch (
    at org.mule.routing.inbound.InboundMessageRouter.rout e(
    at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(
    at com.webreach.mirth.connectors.jdbc.JdbcMessageRece iver.processMessage(
    at org.mule.providers.TransactedPollingMessageReceive r$MessageProcessorWorker.doInTransaction(Transacte
    at org.mule.transaction.TransactionTemplate.execute(T
    at org.mule.providers.TransactedPollingMessageReceive r$
    at .java:290)
    at eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at eadPoolExecutor$ :675)
    at Source)
    Caused by: org.mule.umo.transformer.TransformerException: Failed to parse result map
    at com.webreach.mirth.server.mule.transformers.Result MapToXML.doTransform(
    at org.mule.transformers.AbstractTransformer.transfor m(
    at org.mule.impl.MuleEvent.getTransformedMessage(Mule
    at org.mule.routing.inbound.SelectiveConsumer.isMatch (
    ... 12 more


    But the query works fine if it is retrieving from a single table like this
    Select table1.field1,table1.field2 from table1,table2 where....

    Please help me on this.


  • #2
    Re:Error while retrieving data from multiple table

    Post edited by: star123, at: 07/28/2008 06:01


    • #3
      Re:Error while retrieving data from multiple table

      if u r using mssql provide the following information for database connection.

      var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('',
      'jdbc:sqlserver://<SystemNAme>:1433;databaseName=<DataBaseName>;resu ltsetMetaDataOptions=1;useCursorsAlways=1',

      Here resultsetMetaDataOptions , useCursorsAlways are required.

      u have to copy sqljdbc.jar to mirth lib dictory.

      Post edited by: syamakrishna, at: 07/28/2008 04:06

      Post edited by: syamakrishna, at: 07/28/2008 04:07