You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by chaituu <ya...@gmail.com> on 2015/05/21 10:51:30 UTC
camel sql outputType=SelectList is giving errors
using 2.14.1 version...
<route id="route1">
<from uri="sql:select * from
Employee?dataSource=empSource&outputType=SelectList&outputClass=com.xxx.util.Employee&consumer.useIterator=true"/>
<bean ref="htmlprocess"/>
</route>
In the bean..
final List<Telecast> record = exchange.getIn().getBody(List.class);
LOG.info( "record size:" + record.size());
failed polling endpoint:
Endpoint[sql://select%20*%20%20from%20EMPLOYEE?consumer.useIterator=true&dataSource=elogDataSource&outputClass=com.xxx.util.Telecast&outputType=SelectList].
Will try again at next poll. Caused by:
[org.springframework.beans.BeanInstantiationException - Could not
instantiate bean class [com.xxx.util.Telecast]: Is it an abstract class?;
nested exception is java.lang.InstantiationException: com.xxx.util.Telecast]
org.springframework.beans.BeanInstantiationException: Could not instantiate
bean class [com.xxx.util.Telecast]: Is it an abstract class?; nested
exception is java.lang.InstantiationException: com.xxx.util.Telecast
at org.springframework.beans.BeanUtils.instantiate(BeanUtils.java:82)
at
org.springframework.jdbc.core.BeanPropertyRowMapper.mapRow(BeanPropertyRowMapper.java:235)
at
org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
at
org.apache.camel.component.sql.SqlEndpoint.queryForList(SqlEndpoint.java:260)
at
org.apache.camel.component.sql.SqlConsumer$1.doInPreparedStatement(SqlConsumer.java:102)
--
View this message in context: http://camel.465427.n5.nabble.com/camel-sql-outputType-SelectList-is-giving-errors-tp5767373.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: camel sql outputType=SelectList is giving errors
Posted by Henryk Konsek <he...@gmail.com>.
Hi,
Option outputType has SelectList by default. Does it mean that your
endpoint always fail or only when you set outputType=SelectList explictly.
Cheers.
czw., 21.05.2015 o 10:51 użytkownik chaituu <ya...@gmail.com>
napisał:
> using 2.14.1 version...
>
> <route id="route1">
> <from uri="sql:select * from
>
> Employee?dataSource=empSource&outputType=SelectList&outputClass=com.xxx.util.Employee&consumer.useIterator=true"/>
> <bean ref="htmlprocess"/>
> </route>
>
>
> In the bean..
> final List<Telecast> record =
> exchange.getIn().getBody(List.class);
> LOG.info( "record size:" + record.size());
>
> failed polling endpoint:
>
> Endpoint[sql://select%20*%20%20from%20EMPLOYEE?consumer.useIterator=true&dataSource=elogDataSource&outputClass=com.xxx.util.Telecast&outputType=SelectList].
> Will try again at next poll. Caused by:
> [org.springframework.beans.BeanInstantiationException - Could not
> instantiate bean class [com.xxx.util.Telecast]: Is it an abstract class?;
> nested exception is java.lang.InstantiationException:
> com.xxx.util.Telecast]
> org.springframework.beans.BeanInstantiationException: Could not instantiate
> bean class [com.xxx.util.Telecast]: Is it an abstract class?; nested
> exception is java.lang.InstantiationException: com.xxx.util.Telecast
> at
> org.springframework.beans.BeanUtils.instantiate(BeanUtils.java:82)
> at
>
> org.springframework.jdbc.core.BeanPropertyRowMapper.mapRow(BeanPropertyRowMapper.java:235)
> at
>
> org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
> at
>
> org.apache.camel.component.sql.SqlEndpoint.queryForList(SqlEndpoint.java:260)
> at
>
> org.apache.camel.component.sql.SqlConsumer$1.doInPreparedStatement(SqlConsumer.java:102)
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/camel-sql-outputType-SelectList-is-giving-errors-tp5767373.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>