camel-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mohan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAMEL-4725) camel-sql - Add support for Callable statements
Date Tue, 21 Feb 2017 21:31:44 GMT

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

Mohan commented on CAMEL-4725:
------------------------------

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)

Mime
View raw message