camel-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antoine DESSAIGNE (JIRA)" <>
Subject [jira] [Created] (CAMEL-10870) camel-sql stored procedures don't support negative vendor-specific JDBC types
Date Tue, 21 Feb 2017 11:57:44 GMT
Antoine DESSAIGNE created CAMEL-10870:

             Summary: camel-sql stored procedures don't support negative vendor-specific JDBC
                 Key: CAMEL-10870
             Project: Camel
          Issue Type: Bug
          Components: camel-sql
            Reporter: Antoine DESSAIGNE

When you use a vendor-specific JDBC type in {{camel-sql}} you need to use its value instead
of its label.

For instance, if you use oracle if you want to call a stored procedure that returns a {{FIXED_CHAR}}
type you need to write:
<to uri="sql-stored:PROCEDURE1(OUT 999 result)?dataSource=oracle"/>
All values are defined here:

You can notice that there are negative values in this list ({{CURSOR}} for instance). Unfortunately
the negative values aren't handled by the parser which leads to the following exception
org.apache.camel.component.sql.stored.template.ast.ParseRuntimeException: Field -10 not found
from java.procedureName.Types
	at org.apache.camel.component.sql.stored.template.ast.ParseHelper.parseSqlType(
	at org.apache.camel.component.sql.stored.template.generated.SSPTParser.OutParameter(
	at org.apache.camel.component.sql.stored.template.generated.SSPTParser.Parameter(
	at org.apache.camel.component.sql.stored.template.generated.SSPTParser.parse(
	at org.apache.camel.component.sql.stored.template.TemplateParser.parseTemplate(
	at org.apache.camel.component.sql.stored.CallableStatementWrapperFactory.getTemplateStoredProcedure(
	at org.apache.camel.component.sql.stored.CallableStatementWrapper.populateStatement(
	at org.apache.camel.component.sql.stored.SqlStoredProducer$1.execute(
	at org.apache.camel.component.sql.stored.SqlStoredProducer.process(

This message was sent by Atlassian JIRA

View raw message