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

["Mohan (JIRA)" <ji...@apache.org>]

    [ 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)