Mule MySQL Connector -


i'm trying connect mule mysql database, using tutorial (very new in mule): http://www.mulesoft.org/connectors/mysql-connector

i've come way down, step 6 (test listitems). if go url specified, i'm getting error:

failed route event via endpoint: defaultoutboundendpoint{endpointuri=jdbc://selectall, connector=eejdbcconnector {   name=database   lifecycle=start   this=5b3808ad   numberofconcurrenttransactedreceivers=4   createmultipletransactedreceivers=false   connected=true   supportedprotocols=[jdbc]   serviceoverrides=<none> } ,  name='endpoint.jdbc.selectall', mep=request_response, properties={querytimeout=-1}, transactionconfig=transaction{factory=null, action=indifferent, timeout=0}, deleteunacceptedmessages=false, initialstate=started, responsetimeout=10000, endpointencoding=utf-8, disabletransporttransformer=false}. message payload of type: string 

i've been searching quite long time now, can't find solution. maybe guys can me out?

there xml:

<?xml version="1.0" encoding="utf-8"?>  <mule xmlns:jdbc-ee="http://www.mulesoft.org/schema/mule/ee/jdbc" xmlns:http="http://www.mulesoft.org/schema/mule/http" xmlns:json="http://www.mulesoft.org/schema/mule/json" xmlns="http://www.mulesoft.org/schema/mule/core" xmlns:doc="http://www.mulesoft.org/schema/mule/documentation"       xmlns:spring="http://www.springframework.org/schema/beans" version="ee-3.4.1"       xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"       xsi:schemalocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-current.xsd http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/current/mule-json.xsd http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd http://www.mulesoft.org/schema/mule/ee/jdbc http://www.mulesoft.org/schema/mule/ee/jdbc/current/mule-jdbc-ee.xsd">     <jdbc-ee:mysql-data-source name="mysql_data_source" user="$(db.user)" password="$(db.password)" url="$(db.connection_string)" transactionisolation="unspecified" doc:name="mysql data source"/>     <jdbc-ee:connector name="database" datasource-ref="mysql_data_source" validateconnections="true" querytimeout="-1" pollingfrequency="0" doc:name="database">         <jdbc-ee:query key="selectall" value="select * demo_tbl"/>         <jdbc-ee:query key="insertitem" value="insert demo_tbl set title=#[message.inboundproperties['title']], description=#[message.inboundproperties['description']]"/>         <jdbc-ee:query key="deleteitem" value="delete demo_tbl id=#[message.inboundproperties['id']]"/>         <jdbc-ee:query key="findbyid" value="select * demo_tbl  id=#[message.inboundproperties['id']]"/>         <jdbc-ee:query key="updateitem" value="update demo_tbl set title=#[message.inboundproperties['title']], description=#[message.inboundproperties['description']] id=#[message.inboundproperties['id']]"/>     </jdbc-ee:connector>     <flow name="jdbc_demoflow1" doc:name="jdbc_demoflow1">         <http:inbound-endpoint exchange-pattern="request-response" host="localhost" port="8081" path="list" doc:name="http"/>         <jdbc-ee:outbound-endpoint exchange-pattern="request-response" querykey="selectall" querytimeout="-1" connector-ref="database" doc:name="database"/>         <json:object-to-json-transformer doc:name="object json"/>     </flow> </mule> 

tried newest mysql connector (mysql-connector-java-5.1.29-bin), , 1 stated in tutorial. both didn't work.

anybody know how fix :)?

thanks! bart

the error message says jdbc://selectall, looks data source url incorrect. if @ mysql connector tutorial example, url should in style of jdbc:mysql://localhost:3306/mulesoft_db.


Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -