cache.xml

<ee:cache doc:name="Cache">
  <logger message="getting item from db for key #[payload]" level="INFO" doc:name="Logger"/>
  <jdbc-ee:outbound-endpoint exchange-pattern="request-response" queryKey="fetchValue" queryTimeout="-1" connector-ref="jdbcConnector" doc:name="Database (JDBC)"/>
  <expression-transformer expression="#[payload[0].value]" doc:name="Expression"/>
</ee:cache>

flow.xml

<flow name="htmlCacheFlow" doc:name="htmlCacheFlow">
  <http:inbound-endpoint exchange-pattern="request-response" host="localhost" port="8081" path="cache" doc:name="HTTP"/>
  <expression-transformer expression="#[payload.substring(payload.lastIndexOf('/') + 1)]" doc:name="Expression"/>
  <ee:cache doc:name="Cache">
    <logger message="getting item from db for key #[payload]" level="INFO" doc:name="Logger"/>
    <jdbc-ee:outbound-endpoint exchange-pattern="request-response" queryKey="fetchValue" queryTimeout="-1" connector-ref="jdbcConnector" doc:name="Database (JDBC)"/>
    <expression-transformer expression="#[payload[0].value]" doc:name="Expression"/>
  </ee:cache>
</flow>

jdbc-connector.xml

<jdbc-ee:connector name="jdbcConnector" dataSource-ref="jdbcDatasource" validateConnections="true" queryTimeout="-1" pollingFrequency="0" doc:name="jdbcConnector">
  <jdbc-ee:query key="fetchValue" value="SELECT value FROM keyValue WHERE id=#[payload]"/>
</jdbc-ee:connector>

mule.log

INFO 2012-07-23 13:43:13,010 [[cache-example].connector.http.mule.default.receiver.07] org.mule.api.processor.LoggerMessageProcessor: getting item from db for key 25
DEBUG 2012-07-23 13:43:13,011 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.EEJdbcConnector: Borrowing a dispatcher for endpoint: jdbc://fetchValue
DEBUG 2012-07-23 13:43:13,011 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.EEJdbcConnector: Borrowed a dispatcher for endpoint: jdbc://fetchValue = EEJdbcMessageDispatcher{this=65ad4b68, endpoint=jdbc://fetchValue, disposed=false}
DEBUG 2012-07-23 13:43:13,011 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.EEJdbcConnector: Borrowed dispatcher: EEJdbcMessageDispatcher{this=65ad4b68, endpoint=jdbc://fetchValue, disposed=false}
DEBUG 2012-07-23 13:43:13,012 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.sqlstrategy.EESqlStatementStrategyFactory: Using selectSQLStrategy
ERROR 2012-07-23 13:43:13,013 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.sql.command.parser.DefaultSqlCommandParser: invalid expression template #[payload]. It should be replaced with #[payload:] to conform with the correct expression syntax. Mule has replaced this for you, but may not in future versions.
DEBUG 2012-07-23 13:43:13,013 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.sql.command.executor.PreparedSqlCommandExecutor: Filling input parameters for: SELECT value FROM keyValue WHERE id=?
DEBUG 2012-07-23 13:43:13,014 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.sql.command.executor.PreparedSqlCommandExecutor: SQL: SELECT value FROM keyValue WHERE id=? input params: [25]
DEBUG 2012-07-23 13:43:13,014 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.sql.command.executor.PreparedSqlCommandExecutor: Registering output parameters for: SELECT value FROM keyValue WHERE id=?
DEBUG 2012-07-23 13:43:13,014 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.sql.command.executor.PreparedSqlCommandExecutor: Executing query: SELECT value FROM keyValue WHERE id=?
DEBUG 2012-07-23 13:43:13,014 [[cache-example].connector.http.mule.default.receiver.07] com.mulesoft.mule.transport.jdbc.sql.command.executor.PreparedSqlCommandExecutor: Command executed successfully: SELECT value FROM keyValue WHERE id=?