title: Mule ESB simple jdbc insert
body: <p>I'm trying to force Mule ESB Studio, to perform some simple insert into a jdbc. My goal is to open a page in my webbrowser, let's say it's <code>http://localhost:8081/</code>, and then Mule ESB performs insert 'foobar' value into database.</p>
  
  <p>Here's my code:</p>
  
  <pre><code>&lt;jdbc-ee:mssql-data-source name="MS_SQL_Data_Source" user="esbtest" password="Test123" transactionIsolation="NONE" doc:name="MS SQL Data Source"  loginTimeout="10000" 
  url="jdbc:sqlserver://10.1.212.42:1433;databaseName=test"&gt;&lt;/jdbc-ee:mssql-data-source&gt;
  
  &lt;jdbc-ee:connector name="Database" dataSource-ref="MS_SQL_Data_Source" validateConnections="true" queryTimeout="-1" pollingFrequency="0" doc:name="Database"/&gt;
  
  &lt;flow name="Test_PierwszyFlow1" doc:name="Test_PierwszyFlow1"&gt; 
      &lt;http:inbound-endpoint exchange-pattern="request-response" host="localhost" port="8081" doc:name="HTTP" mimeType="text/plain"&gt;&lt;/http:inbound-endpoint&gt;
      &lt;object-to-string-transformer doc:name="Object to String"/&gt;
      &lt;jdbc-ee:outbound-endpoint exchange-pattern="one-way"  queryTimeout="-1" doc:name="Database" connector-ref="Database" queryKey="insertQuery"&gt;
          &lt;jdbc-ee:query key="insertQuery" value="INSERT INTO t_Login (login) VALUES ('foo bar')"/&gt;
      &lt;/jdbc-ee:outbound-endpoint&gt;
  
  &lt;/flow&gt;
  </code></pre>
  
  <p>I've not specified any beans or such things. In logs, I see these lines:</p>
  
  <pre><code>    INFO  2013-07-02 11:20:37,550 [[test_pierwszy].connector.http.mule.default.receiver.02] org.mule.lifecycle.AbstractLifecycleManager: Initialising: 'Database.dispatcher.1938839184'. Object is: EEJdbcMessageDispatcher
  INFO  2013-07-02 11:20:37,550 [[test_pierwszy].connector.http.mule.default.receiver.02] org.mule.lifecycle.AbstractLifecycleManager: Starting: 'Database.dispatcher.1938839184'. Object is: EEJdbcMessageDispatcher
  INFO  2013-07-02 11:20:37,670 [[test_pierwszy].connector.http.mule.default.receiver.02] com.mulesoft.mule.transport.jdbc.sqlstrategy.UpdateSqlStatementStrategy: Executing SQL statement: 1 row(s) updated
  INFO  2013-07-02 11:20:37,730 [[test_pierwszy].connector.http.mule.default.receiver.02] com.mulesoft.mule.transport.jdbc.sqlstrategy.UpdateSqlStatementStrategy: Executing SQL statement: 1 row(s) updated
  </code></pre>
  
  <p>...but my database is empty! I must say, I am totally new in Mule ESB area and have no idea what is wrong. Please - help.</p>
  
  <p><strong>Edit:</strong> Funny thing is, that when I change talbe or column name to something, that does not exist, I get JDBC error corresponding to that matter.</p>
  
  <p>Second question is, how to inject to DB value I've specified in URL? For example, when I type in browser <code>http://localhost:8081/foo</code>, the value foo is passed to jdbc outcome connector, and 'foo' value is inserted.</p>
  
  <p>Thanks in advance.</p>