<db:mysql-config name="MySQL_Configuration" url="jdbc:mysql://localhost:3306/mysqla2?user=root&amp;password=hugo1995" doc:name="MySQL Configuration"/>
    <twitter:config name="Twitter__Configuration" accessKey="810196779895586816-TB1dUGgEBk1AapJR48qmOTm4CK7uVsx" accessSecret="M1NbbR1yxxhZLeKFn9p2tC9gHTfepSqCLDQ4yFGdW9iYk" consumerKey="i802werZQpXycOLedpek6u1g7" consumerSecret="kxIk7U5hJl0HkwJ1ZgfpID2RO02l09zpvHD3I3pgRGJF9sXQwr" doc:name="Twitter: Configuration"/>
    <flow name="dbtestFlowJSON">
        <quartz:inbound-endpoint jobName="Wait" repeatInterval="5000" responseTimeout="10000" doc:name="Quartz">
            <quartz:event-generator-job/>
        </quartz:inbound-endpoint>
        <db:select config-ref="MySQL_Configuration" doc:name="Database">
            <db:parameterized-query><![CDATA[select course_student.student_id, student.address,student.inst_email, course_student.course_id from course_student,student where student_id in (select id from student);]]></db:parameterized-query>
        </db:select>
        <json:object-to-json-transformer doc:name="Object to JSON"/>
        <logger message="#[payload]" level="INFO" doc:name="Logger"/>
    </flow>
    <flow name="dbtestFlowXML">
        <quartz:inbound-endpoint jobName="Wait2" repeatInterval="5000" responseTimeout="10000" doc:name="Quartz2">
            <quartz:event-generator-job/>
        </quartz:inbound-endpoint>
        <db:select config-ref="MySQL_Configuration" doc:name="Database">
            <db:parameterized-query><![CDATA[select name, course_id from material;]]></db:parameterized-query>
        </db:select>
        <mulexml:object-to-xml-transformer doc:name="Object to XML"/>
        <logger message="#[payload]" level="INFO" doc:name="Logger"/>
        <file:outbound-endpoint path="C:\Users\gonca\Desktop" outputPattern="new.xml" responseTimeout="10000" doc:name="File"/>
    </flow>
    <flow name="dbtestFlow">
        <twitter:sample-stream config-ref="Twitter__Configuration" doc:name="Twitter (Streaming)"/>
    	<twitter:update-status config-ref="Twitter__Configuration" status="&quot;yolo&quot;" doc:name="Twitter"/>
    </flow>