[jira] [Comment Edited] (CAMEL-4725) camel-sql - Add support for Callable statements

[Mohan (JIRA)]

    [ 
https://issues.apache.org/jira/browse/CAMEL-4725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876763#comment-15876763
 ] 

Mohan edited comment on CAMEL-4725 at 2/21/17 9:32 PM:
-------------------------------------------------------

Here are my test details : 

Java Obj :

{code:title=Person.java|borderStyle=solid}
public class Person {
        
        String text;
        String description;
        
        
        public Person(String text, String description) {
                super();
                this.text = text;
                this.description = description;
         }
}
{code}

Camel Route
{code:title=Route|borderStyle=solid}
<route id="testOraObjInsert" xmlns="http://camel.apache.org/schema/spring";>
        <from uri="timer:foo?period=5s"/>
        <to uri="bean:testDataService?method=testProcess"/>   <!-- returns a 
person object initialized-->
        <to uri="sql-stored:test_camel_obj(STRUCT 
${body})?dataSource=testDataSource"/>
 </route>
{code}

Oracle Proc Details :

{code:title=Oracle Proc|borderStyle=solid}
create or replace type T_TEST as object (
  text           varchar2(50),
  DESCRIPTION  varchar2(50)
);

and procedure

procedure TEST_CAMEL_OBJ(testInput T_TEST) as
  
  begin
  
  insert into test_camel(column1) values(testInput.text);
commit;
  end;
{code}


Getting error when executing as : 

org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; 
uncategorized SQLException for SQL [{call test_camel_obj(?)}]; SQL state 
[99999]; error code [17059]; Fail to convert to internal representation:




was (Author: mohan5sep):
Here are my test details : 

Java Obj :

{code:title=Bar.java|borderStyle=solid}
public class Person {
        
        String text;
        String description;
        
        
        public Person(String text, String description) {
                super();
                this.text = text;
                this.description = description;
         }
}
{code}

Camel Route
{code:title=Bar.java|borderStyle=solid}
<route id="testOraObjInsert" xmlns="http://camel.apache.org/schema/spring";>
        <from uri="timer:foo?period=5s"/>
        <to uri="bean:testDataService?method=testProcess"/>   <!-- returns a 
person object initialized-->
        <to uri="sql-stored:test_camel_obj(STRUCT 
${body})?dataSource=testDataSource"/>
 </route>
{code}

Oracle Proc Details :

{code:title=Bar.java|borderStyle=solid}
create or replace type T_TEST as object (
  text           varchar2(50),
  DESCRIPTION  varchar2(50)
);

and procedure

procedure TEST_CAMEL_OBJ(testInput T_TEST) as
  
  begin
  
  insert into test_camel(column1) values(testInput.text);
commit;
  end;
{code}


Getting error when executing as : 

org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; 
uncategorized SQLException for SQL [{call test_camel_obj(?)}]; SQL state 
[99999]; error code [17059]; Fail to convert to internal representation:



> camel-sql - Add support for Callable statements
> -----------------------------------------------
>
>                 Key: CAMEL-4725
>                 URL: https://issues.apache.org/jira/browse/CAMEL-4725
>             Project: Camel
>          Issue Type: New Feature
>          Components: camel-sql
>    Affects Versions: 2.8.3
>            Reporter: Christian Müller
>            Assignee: Claus Ibsen
>             Fix For: 2.17.0
>
>
> See 
> [Nabble|http://camel.465427.n5.nabble.com/call-Oracle-Package-procedure-td5032133.html]
>  for details.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)