Re: Call stored procedure on jdbc:inbound-endpoint - with no arguments

> I'm not able to figure out how to call a stored proc on a
> jdbc:inbound-endpoint with no arguments
>
> Heres my code
> <jdbc:connector name="jdbcConnector"  dataSource-ref="dataSource" >
>    <jdbc:query key="myQuery" value="call myStoredProcedure()" />
> </jdbc:connector>
>
> ...
> <model name="test>
>        <service name="getData">
>            <inbound>
>                <jdbc:inbound-endpoint pollingFrequency="10000"
> queryKey="myQuery" connector-ref="jdbcConnector"/>
>            </inbound>
>        </service>
> </model>
>
>
>
> I get the following error message
> java.sql.SQLException: Incorrect syntax near ')'. Query: call
> myStoredProcedure() Parameters: []
>    at
> org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:359)
>    at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:240)
>    at
> org.mule.transport.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:202)
>
>    at
> org.mule.transport.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:136)
>
>    at
> org.mule.transport.PollingReceiverWorker.run(PollingReceiverWorker.java:47)
>
>    at org.mule.work.WorkerContext.run(WorkerContext.java:310)
>    at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
>
>    at
> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
>
>    at java.lang.Thread.run(Unknown Source)
>
>
> How to call a stored proc with no arguments as the inbound-endpoint?
>
> Regards,
> Stig Melling
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>
>
>