Created
May 22, 2015 17:40
-
-
Save edgars/27e28c93b43f1257d100 to your computer and use it in GitHub Desktop.
databaseSequence
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<sequence xmlns="http://ws.apache.org/ns/synapse" name="databaseSequence"> | |
<log level="full"> | |
<property name="sequence" value="before-smooks"></property> | |
</log> | |
<smooks config-key="smooks-csv"> | |
<input type="text"></input> | |
<output type="xml"></output> | |
</smooks> | |
<log level="full"> | |
<property name="sequence" value="after-smooks"></property> | |
</log> | |
<iterate xmlns:ns2="http://org.apache.synapse/xsd" xmlns:ns="http://org.apache.synapse/xsd" xmlns:sec="http://secservice.samples.esb.wso2.org" expression="//csv-set/csv-record"> | |
<target> | |
<sequence> | |
<log level="full"> | |
<property name="State" value="Iteration"></property> | |
</log> | |
<dbreport> | |
<connection> | |
<pool> | |
<password>admin</password> | |
<user>admin</user> | |
<url>jdbc:mysql://localhost:3306/northwind</url> | |
<driver>com.mysql.jdbc.Driver</driver> | |
</pool> | |
</connection> | |
<statement> | |
<sql> | |
<![CDATA[ INSERT into Categories(CategoryName,Description) values(?,?)]]></sql> | |
<parameter expression="//csv-record/name/text()" type="VARCHAR"></parameter> | |
<parameter expression="//csv-record/description/text()" type="VARCHAR"></parameter> | |
</statement> | |
</dbreport> | |
</sequence> | |
</target> | |
</iterate> | |
</sequence> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hola querida
¿Cómo están usted y actividades, soy la señora Christina, vi tu perfil hoy luego me interesé saber algo más, así que por favor amablemente Wright para mí a través de mi dirección de correo electrónico (christina0932@hotmail.com) y también tengo algo muy importante que el discurso con usted, gracias, estoy esperando a leer de usted pronto.
Su nuevo amigo (christina0932@hotmail.com)