Thanks Claus for the quick reply
I tried the following 

        .to("jdbc:testdb?readSize=100")
        .process(new Processor() {
            public void process(Exchange exchange) throws Exception {
                ArrayList<HashMap<String, Object>> body =  
(ArrayList<HashMap<String, Object>>) exchange.getIn().getBody();
                HashMap<String, Object> t = (HashMap) body.get(0);
                BLOB blob = (BLOB) t.get("FILECONTENT");
                        long len = blob.length();
                        byte [] data = blob.getBytes(1, (int) len);
                        String s = "";
                        String charsetName = 
exchange.getProperty(Exchange.CHARSET_NAME,
String.class);
                   if (charsetName != null) {
                       try {
                         s =  new String(data, charsetName);
                       } catch (UnsupportedEncodingException e) {
                           System.out.println("Can't convert the byte to
String with the charset =" + charsetName+","+e);
                       }
                   }
                // do something with the payload and/or exchange here
               exchange.getIn().setBody(s);
           }
        }).split(body())
and I get the following error 

ERROR 2010-Mar-11 16:01:27,292 TimerConsumer   Error processing exchange.
Exchange[Message: [{filecontent=oracle.sql.b...@11ea3fc, FILEID=7216}]].
Caused by: [java.sql.SQLException - Closed Connection]   
java.sql.SQLException: Closed Connection
        at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

Please help






schivukula wrote:
> 
> I have a requirement to get a value from the database and convert write
> individual values to file, the fileid is a string and filecontent is a
> oracle.sql.blob. I am getting the following error, please help I am new to
> camel
> 
> from("timer://kickoff?period=30000")
>        .setBody(constant("select fileid,filecontent from ftsmailbox where
> display_status= 'SHOW' and mimetype = 'text/xml' and fileid = 7216"))
>          .to("jdbc:testdb?readSize=100")
>          .split(body())
>          .to("file:target/messages/others");
> 
> 
> Error
> Caused by: org.apache.camel.NoTypeConversionAvailableException: No type
> converter available to convert from type: java.util.HashMap to the
> required type: java.io.InputStream with value
> {filecontent=oracle.sql.b...@16ea15f, FILEID=7216}
>       at
> org.apache.camel.impl.converter.DefaultTypeConverter.mandatoryConvertTo(DefaultTypeConverter.java:123)
>       at
> org.apache.camel.impl.MessageSupport.getMandatoryBody(MessageSupport.java:101)
> 
> 

-- 
View this message in context: 
http://old.nabble.com/java.util.HashMap-to-the-required-type%3A-java.io.InputStream-tp27868505p27869842.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to