Announcement

Collapse
No announcement yet.

database reader to file writer

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

  • database reader to file writer

    I'm testing de mirth and i'm trying to create a ORM^O01 message, I've made some diferents cases, and the result is ever the same: The last time I've download the example on the web but the result without tranformations is the same:
    ************************************************** ******************************

    ERROR 2006-10-17 17:52:34,561 [14.2] org.mule.impl.DefaultComponentExceptionStrategy: Caught exception in Exception Strategy for: 14: org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
    org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
    at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:193)
    at org.mule.impl.DefaultLifecycleAdapter.intercept(De faultLifecycleAdapter.java:232)
    at org.mule.impl.InterceptorsInvoker.execute(Intercep torsInvoker.java:53)
    at org.mule.impl.model.DefaultMuleProxy.run(DefaultMu leProxy.java:388)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.mule.umo.transformer.TransformerException: Failed to parse result map
    at com.webreach.mirth.server.mule.transformers.Result MapToXML.doTransform(ResultMapToXML.java:70)
    at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
    at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
    at org.mule.impl.MuleEventContext.getTransformedMessa ge(MuleEventContext.java:100)
    at com.webreach.mirth.server.mule.components.Outbound Channel.onCall(OutboundChannel.java:22)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.mule.model.DynamicEntryPoint.invokeCurrent(Dyn amicEntryPoint.java:168)
    at org.mule.model.DynamicEntryPoint.invoke(DynamicEnt ryPoint.java:90)
    at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:177)
    ... 7 more
    DEBUG 2006-10-17 17:52:39,531 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:52:44,532 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:52:49,532 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:52:54,533 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:52:59,533 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:04,533 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:09,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:14,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:19,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:24,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:29,535 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:29,535 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcMessageReceiver: Received Message: {obr16=null, obr44=^^^ , msh2=^~\& , obr24=CR , msh5=DocuMed HL7 Server , obr46=^^^ , msh1=|, msh7=200610171023 , obr36=200606171115 , obr366=200606171115 , orc7=R , orc2=null, obr45=^^^ , obr19=null, msh9=ORM^001 , orc3=null, obr363=200606171115 , obr361=200606171115 , pid7=191501010000 , obr4=10^EXTREMIDADES INFERIORES^1012^RODILLAS AP+LAT , pid8=F , pid5=BARCELO^FERNANDEZ^FRANCISCA , obr364=200606171115 , obr365=200606171115 , obr43=^^^ , pv18=null, orc1=NW , obr20=null, obr31=null, msh10= 38, obr42=^^^ , obr362=200606171115 , obr41=10^CINTURĂ“N ESCAPULAR^1012^HOMBRO AP + AX , msh3=WEBHOSPITAL , obr15=null, msh12=2.3.1 , pid2=1019656 , obr34=null}
    DEBUG 2006-10-17 17:53:29,550 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
    DEBUG 2006-10-17 17:53:29,550 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcMessageReceiver: Message Received from: jdbc://query
    DEBUG 2006-10-17 17:53:29,550 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcMessageReceiver: MuleMessage{id=[uniqueId not supported], payload=org.apache.commons.dbutils.BasicRowProcess or$CaseInsensitiveHashMap, correlationId=null, correlationGroup=-1, correlationSeq=-1, exceptionPayload=null, properties={}}
    DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcMessageReceiver: Message Payload:
    {obr16=null, obr44=^^^ , msh2=^~\& , obr24=CR , msh5=DocuMed HL7 Server , obr46=^^^ , msh1=|, msh7=200610171023 , obr36=200606171115 , obr366=200606171115 , orc7=R , orc2=null, obr45=^^^ , obr19=null, msh9=ORM^001 , orc3=null, obr363=200606171115 , obr361=200606171115 , pid7=191501010000 , obr4=10^EXTREMIDADES INFERIORES^1012^RODILLAS AP+LAT , pid8=F , pid5=BARCELO^FERNANDEZ^FRANCISCA , obr364=200606171115 , obr365=200606171115 , obr43=^^^ , pv18=null, orc1=NW , obr20=null, obr31=null, msh10= 38, obr42=^^^ , obr362=200606171115 , obr41=10^CINTURĂ“N ESCAPULAR^1012^HOMBRO AP + AX , msh3=WEBHOSPITAL , obr15=null, msh12=2.3.1 , pid2=1019656 , obr34=null}
    DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.MuleSession: dispatching event to component: 14 event is: Event: a21cc0d0-5df7-11db-8b5f-bfeb6dbcc61b, sync=false, stop processing=false, ImmutableMuleEndpoint{connector=org.mule.providers [email protected], endpointUri=jdbc://query, transformer=Transformer{name='ResultMapToXML& #039;, returnClass=false, returnClass=false, sourceTypes=[class java.util.HashMap]}, name='_jdbcEndpoint#305920046', type='receiver', properties={}, transactionConfig=org.mule.impl.MuleTransactionCon [email protected], filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=null, initialState=started, createConnector=0}
    DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.model.seda.SedaComponent: Component: 14 has received asynchronous event on: jdbc://query
    DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.model.seda.SedaComponent: Component: 14 has received asynchronous event on: jdbc://query
    DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.model.seda.SedaComponent: Event added to queue for: 14
    DEBUG 2006-10-17 17:53:29,566 [14.1] org.mule.impl.model.seda.SedaComponent: Component: 14 dequeued event on: jdbc://query
    DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.impl.model.DefaultMuleProxy: MuleProxy: async onEvent for Mule UMO 14
    DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.model.DynamicEntryPoint: Invoking com.webreach.mirth.server.mule.components.Outbound Channel.onCall(org.mule.impl.MuleEventContext)
    DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.transformer.TransformerExceptio n' is: http://mule.codehaus.org/docs/apidoc...Exception.html
    DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.transformer.TransformerExceptio n' is: null
    DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.MessagingException' is: http://mule.codehaus.org/docs/apidoc...Exception.html
    DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.MessagingException' is: null
    DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.MessagingException' is: http://mule.codehaus.org/docs/apidoc...Exception.html
    DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.MessagingException' is: null
    DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.MessagingException' is: http://mule.codehaus.org/docs/apidoc...Exception.html
    DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.MessagingException' is: null
    DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.transformer.TransformerExceptio n' is: http://mule.codehaus.org/docs/apidoc...Exception.html
    ERROR 2006-10-17 17:53:29,582 [14.3] org.mule.impl.DefaultComponentExceptionStrategy:
    ************************************************** ******************************
    Message : Failed to parse result map
    Type : org.mule.umo.transformer.TransformerException
    Code : 64999
    Transformer : Transformer{name='ResultMapToXML', returnClass=false, returnClass=false, sourceTypes=[class java.util.HashMap]}
    JavaDoc : http://mule.codehaus.org/docs/apidoc...Exception.html
    ************************************************** ******************************
    Exception stack is:
    1. Failed to parse result map (org.mule.umo.transformer.TransformerException)
    com.webreach.mirth.server.mule.transformers.Result MapToXML:70 (http://mule.codehaus.org/docs/apidoc...Exception.html)
    ************************************************** ******************************
    Root Exception stack trace:
    org.mule.umo.transformer.TransformerException: Failed to parse result map
    at com.webreach.mirth.server.mule.transformers.Result MapToXML.doTransform(ResultMapToXML.java:70)
    at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
    at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
    at org.mule.impl.MuleEventContext.getTransformedMessa ge(MuleEventContext.java:100)
    at com.webreach.mirth.server.mule.components.Outbound Channel.onCall(OutboundChannel.java:22)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.mule.model.DynamicEntryPoint.invokeCurrent(Dyn amicEntryPoint.java:168)
    at org.mule.model.DynamicEntryPoint.invoke(DynamicEnt ryPoint.java:90)
    at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:177)
    at org.mule.impl.DefaultLifecycleAdapter.intercept(De faultLifecycleAdapter.java:232)
    at org.mule.impl.InterceptorsInvoker.execute(Intercep torsInvoker.java:53)
    at org.mule.impl.model.DefaultMuleProxy.run(DefaultMu leProxy.java:388)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    at java.lang.Thread.run(Unknown Source)

    ************************************************** ******************************

    ERROR 2006-10-17 17:53:29,582 [14.3] org.mule.impl.DefaultComponentExceptionStrategy: Caught exception in Exception Strategy for: 14: org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
    org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
    at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:193)
    at org.mule.impl.DefaultLifecycleAdapter.intercept(De faultLifecycleAdapter.java:232)
    at org.mule.impl.InterceptorsInvoker.execute(Intercep torsInvoker.java:53)
    at org.mule.impl.model.DefaultMuleProxy.run(DefaultMu leProxy.java:388)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.mule.umo.transformer.TransformerException: Failed to parse result map
    at com.webreach.mirth.server.mule.transformers.Result MapToXML.doTransform(ResultMapToXML.java:70)
    at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)



    this is chanel:
    [blue]
    <?xml version="1.0" encoding="UTF-8" ?>
    - <mule-configuration id="MirthConfiguration" version="1.0">
    <mule-environment-properties embedded="false" />
    - <agents>
    <agent className="org.mule.management.agents.RmiRegistryA gent" name="RMI" />
    - <agent className="org.mule.management.agents.JmxAgent" name="JMX">
    - <properties>
    <property name="connectorServerUrl" value="service:jmx:rmi:///jndi/rmi://localhost:1099/server" />
    - <map name="connectorServerProperties">
    <property name="jmx.remote.jndi.rebind" value="true" />
    </map>
    </properties>
    </agent>
    </agents>
    - <connector className="org.mule.providers.jdbc.JdbcConnector" name="14_source">
    - <properties>
    <property name="pollingFrequency" value="5000" />
    <property name="username" value="sa" />
    <property name="useAck" value="1" />
    <property name="URL" value="jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7" />
    <property name="password" value="hsjd05" />
    <property name="driver" value="net.sourceforge.jtds.jdbc.Driver" />
    - <map name="queries">
    <property name="query" value="SELECT MSH1,MSH2,MSH3,MSH5,MSH7,MSH9,MSH10,MSH12,PID2,pid 5,PID7,PID8,PV18,ORC1,ORC2,ORC3,ORC7,OBR24,OBR16,O BR4,OBR15,OBR19,OBR20,OBR34,OBR36,OBR31,OBR41,OBR3 61,OBR42,OBR362,OBR43,OBR363,OBR44,OBR364,OBR45,OB R365,OBR46,OBR366 FROM mensaje WHERE ESTADO IS NULL" />
    <property name="ack" value="UPDATE mensaje SET estado=&#039;OK&#039;" />
    </map>
    </properties>
    </connector>
    - <connector className="org.mule.providers.file.FileConnector" name="14_destination_1">
    - <properties>
    <property name="outputAppend" value="0" />
    <property name="outputPattern" value="${DATE:yy-MM-dd}" />
    <property name="template" value="${HL7 ER7}" />
    </properties>
    </connector>
    - <transformers>
    <transformer className="org.mule.transformers.simple.ByteArrayT oString" name="ByteArrayToString" />
    <transformer className="org.mule.transformers.simple.StringToBy teArray" name="StringToByteArray" />
    <transformer className="com.webreach.mirth.server.mule.transfor mers.ER7toXML" name="ER7toXML" />
    <transformer className="com.webreach.mirth.server.mule.transfor mers.XMLtoER7" name="XMLtoER7" />
    <transformer className="com.webreach.mirth.server.mule.transfor mers.ResultMapToXML" name="ResultMapToXML" />
    <transformer className="com.webreach.mirth.server.mule.transfor mers.VariableHashMapToER7String" name="VariableHashMapToER7String" />
    - <transformer className="com.webreach.mirth.server.mule.transfor mers.JavaScriptTransformer" name="14_destination_1">
    - <properties>
    <property name="script" value="var hl7_xml = new XML(&#039;<?xml version="1.0"?><ORM_O01 xmlns="urn:hl7-org:v2xml"> <MSH> <MSH.1>|</MSH.1> <MSH.2>^~\&</MSH.2> <MSH.3>LAB</MSH.3> <MSH.4>CCF</MSH.4> <MSH.7>20040920080937</MSH.7> <MSH.9> <CM_MSG.1>ORM</CM_MSG.1> <CM_MSG.2>O01</CM_MSG.2> </MSH.9> <MSH.10>42640000009</MSH.10> <MSH.11>P</MSH.11> <MSH.12>2.1</MSH.12> </MSH> <NTE/> <ORM_O01.PATIENT> <PID> <PID.3> <CK.1>56797971</CK.1> </PID.3> <PID.5> <PN.1>RESULTSREVIEW</PN.1> <PN.2>TESTPATIENT</PN.2> </PID.5> <PID.7>19650525</PID.7> <PID.8>M</PID.8> <PID.18> <CK.1>56797971</CK.1> </PID.18> </PID> <NTE/> <PV1> <PV1.2>O</PV1.2> <PV1.3>UNKO</PV1.3> </PV1> </ORM_O01.PATIENT> <ORM_O01.ORDER> <ORC> <ORC.1>CA</ORC.1> <ORC.2> <CM.1>30725991</CM.1> <CM.2>EPIC_EC</CM.2> </ORC.2> <ORC.16> <UNKNOWN.2>Duplicate</UNKNOWN.2> </ORC.16> </ORC> <ORM_O01.ORDER_DETAIL> <OBR> <OBR.2> <CM.1>30725991</CM.1> <CM.2>EPIC_EC</CM.2> </OBR.2> <OBR.4> <CE.1>CBCDIF</CE.1> <CE.2>CBC and Differential</CE.2> </OBR.4> <OBR.7>200409200805</OBR.7> <OBR.14>L</OBR.14> <OBR.16> <CN.1>00593</CN.1> </OBR.16> <OBR.20>M10274</OBR.20> <OBR.21>UNKO</OBR.21> <OBR.25>X</OBR.25> <OBR.27> <CM.2>ONCE</CM.2> <CM.4>200409200805</CM.4> </OBR.27> </OBR> </ORM_O01.ORDER_DETAIL> </ORM_O01.ORDER></ORM_O01>&#039;var hl7_er7 = &#039;MSH|^~\&|LAB|CCF|||20040920080937||ORM^O01|4 2640000009|P|2.1|\rPID|||56797971||RESULTSREVIEW^T ESTPATIENT^||19650525|M||||||||||56797971|\rPV1||O |UNKO^|||||\rORC|CA|30725991^EPIC_EC|||||||||||||| ^Duplicate|\rOBR||30725991^EPIC_EC||CBCDIF^CBC and Differential|||200409200805|||||||L|^|00593^||||M1 0274|UNKO||||X||^ONCE^^200409200805^^|^^|\r&#039;; channelid = &#039;14&#039;;localMap.put("HL7 XML", hl7_xml);localMap.put("HL7 ER7", hl7_er7);" />
    </properties>
    </transformer>
    </transformers>
    - <interceptor-stack name="default">
    <interceptor className="org.mule.interceptors.LoggingIntercepto r" />
    <interceptor className="org.mule.interceptors.TimerInterceptor" />
    </interceptor-stack>
    - <model name="Mirth">
    - <!-- new descriptors will be added here
    -->
    - <mule-descriptor implementation="com.webreach.mirth.server.mule.com ponents.OutboundChannel" initialState="stopped" name="14">
    - <inbound-router>
    <endpoint address="jdbc://query" connector="14_source" transformers="ResultMapToXML" />
    </inbound-router>
    - <outbound-router>
    - <router className="org.mule.routing.outbound.FilteringMult icastingRouter">
    - <endpoint address="file://C:/MENSAJES/SALIDA" connector="14_destination_1" transformers="14_destination_1">
    - <filter className="com.webreach.mirth.server.mule.filters. JavaScriptFilter">
    - <properties>
    <property name="script" value="return true;" />
    </properties>
    </filter>
    </endpoint>
    </router>
    </outbound-router>
    </mule-descriptor>
    </model>
    </mule-configuration>[/blue]

    thanks

  • #2
    Re: database reader to file writer

    Can you email me the channel export (chrisl [at] webreachinc.com) and possibly a database schema dump/sample data?

    Thanks,
    -Chris
    Chris Lang

    Comment


    • #3
      Re: database reader to file writer

      Now, if I only select the fields of the bd that I want to transform, The destination file is writed, but the hl7 variable that I&#039;ve mapped it&#039;s appears like &#039;UNDEFINED&#039; in the text destination file.

      Is the type of the field in the database? All of them are defined like char or varchar

      why?

      thanks

      Comment


      • #4
        Re: database reader to file writer

        To prevent &#039;undefined&#039;, put .toString() on all of your mappings. Undefined is the default JS value when a variable does not exist (equivalent to null).

        -CHris
        Chris Lang

        Comment


        • #5
          Re: database reader to file writer

          Now, the error is:

          "cannot find the function text"

          Comment

          Working...
          X