-
1. Re: Switchyard and stored procedures (IN/OUT params)
igarashitm Mar 2, 2014 8:56 PM (in response to stelmik)Hi Krzysztof,
Can you provide an example project and a testcase so I can reproduce it?
Thanks, Tomo
-
2. Re: Switchyard and stored procedures (IN/OUT params)
trohovsky Mar 4, 2014 3:55 PM (in response to stelmik)Hi Krzysztof,
camel-sql unfortunately doesn't support stored procedures at the moment. Thus neither SQL binding supports it. See these JIRAs: https://issues.apache.org/jira/browse/CAMEL-4725, [SWITCHYARD-1925] Add stored procedure support for SQL Gateway Binding - JBoss Issue Tracker
Tomas
-
3. Re: Switchyard and stored procedures (IN/OUT params)
rohan0287 Mar 4, 2014 4:19 PM (in response to trohovsky)Hi Tomas,
I too agree to that camel-sql doesn't support as of now. But still any experts of Jboss can confirm this?mageshbk
TIA
-
4. Re: Switchyard and stored procedures (IN/OUT params)
igarashitm Mar 4, 2014 9:43 PM (in response to rohan0287)1 of 1 people found this helpfulAlthough OUT parameter can't be retrieved without CallableStatement support, the stored procedure still should be able to be invoked via PreparedStatement IMO. So I think something is wrong if the databse is not updated with the execution.
-
5. Re: Switchyard and stored procedures (IN/OUT params)
stelmik Mar 5, 2014 7:43 AM (in response to igarashitm)Thank you for your responses.
Tomohisa: At this moment it's hard to create a unit test for this one by me, since it connects to an oracle database. I haven't access to stored procedure's source code too.
Inside my example/project I did one mistake and therefore data didn't store in database. I need to call second stored procedure before call myApi.createItem(...) (required internal in my project only).
Currently the data are stored in database but I can't get a result of execution stored procedure.
The stored procedure returns a result of operation (success / failure with error message), but inside my switchyard project I get NULL value always.
The message with error description is very imortant for me when an error occure.
-
6. Re: Switchyard and stored procedures (IN/OUT params)
igarashitm Mar 5, 2014 9:52 AM (in response to stelmik)As Tomas pointed out, OUT parameter cannot be retrieved from stored procedure call via sql binding until CallableStatement is supported unfortunately. Sorry for the inconvenience.