camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bhagavan <suryabhagavanpad...@gmail.com>
Subject I want change my route config Spring DSL to Java DSL below code but I got sql mismatched exception
Date Fri, 21 Feb 2014 17:58:41 GMT
<camel:route id="Csv to DB example"
			autoStartup="true">
			<camel:from uri="file:input/csv?noop=true&amp;delay=10" />
			<camel:split parallelProcessing="true" streaming="true">
				<camel:tokenize token="\n" group="1" />
				<camel:unmarshal>
					<camel:csv />
				</camel:unmarshal>
				<transform>
					<simple>${body[0]}</simple>
				</transform>
				<camel:to
					uri="sql:insert into palyer (id, name, city) values
(#,#,#)?dataSourceRef=dataSource" />
			</camel:split>
			<camel:stop />
		</camel:route>

When I try with  following code

public void configure() throws Exception {
	        logger.info("CSV file to Database");
	        from("file:input/inbox?noop=true").
	        unmarshal().csv().transform().body().
	        to("sql:insert into palyer (id, name, city) values
(#,#,#)?dataSourceRef=dataSource").
	        stop();
	    }

I got this error 

thread #0 - file://input/inbox] GenericFileOnCompletion        WARN 
Rollback file strategy:
org.apache.camel.component.file.strategy.GenericFileRenameProcessStrategy@1f707a6a
for file: GenericFile[data.txt]
[thread #0 - file://input/inbox] DefaultErrorHandler            ERROR Failed
delivery for (MessageId: ID- PC-56648-1393004785733-0-69 on ExchangeId:
ID-vgsc-PC-56648-1393004785733-0-70). Exhausted after delivery attempt: 1
caught: org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL [insert into
palyer (id, name, city) values (?,?,?)]; SQL state [null]; error code [0];
Number of parameters mismatch. Expected: 3, was:2; nested exception is
java.sql.SQLException: Number of parameters mismatch. Expected: 3, was:2
org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL [insert into
palyer (id, name, city) values (?,?,?)];
 SQL state [null]; error code [0]; Number of parameters mismatch. Expected:
3, was:2; 
nested exception is java.sql.SQLException: Number of parameters mismatch.
Expected: 3, was:2




--
View this message in context: http://camel.465427.n5.nabble.com/I-want-change-my-route-config-Spring-DSL-to-Java-DSL-below-code-but-I-got-sql-mismatched-exception-tp5747785.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message