Hello,
Here is the description of my route camel : I get a message type Bytes in my
queue, I transferred this message to another broker instance in another
machine.
was receiving this message I transformed this message to CSV or XML file.
my problem is that my route works very well for XML files and not for CSV
files.
Here is my setup:
<route errorHandlerRef="myDeadLetterChannel">
<from uri="activemq:queue:IN"/>
<choice>
<when>
<xpath> $ action = 'AAE' </ xpath>
<t uri="file:///c:/IN/AAE/"/>
<setBody>
<simple> UPDATE SET CAMEL CamelDate = CURRENT_TIMESTAMP WHERE message = '$
(in.header.MessageId)' </ simple>
</ setBody>
<t uri="jdbc:testdb"/>
</ when>
<when>
<xpath> $ action = 'FAE' </ xpath>
<t uri="file:///c:/IN/FAE/"/>
<setBody>
<simple> UPDATE SET CAMEL CamelDate = CURRENT_TIMESTAMP WHERE message = '$
(in.header.MessageId)' </ simple>
</ setBody>
<t uri="jdbc:testdb"/>
</ when>
<otherwise>
<t uri="activemq:queue:FilterError"/>
</ otherwise>
</ choice>
</ route>
Here is the error that I receive when the transformationfor CSV file.
WARN EndpointMessageListener - Endpoint [ActiveMQ: tail: IN] consumer caught
an exception while processing JMS message: ActiveMQBytesMessage
CommandID = (10, responseRequired = false, messageId = ID:
DCFR-4099-1254861846625-3: 0:1:1:1, originalDestination = null,
originalTransactionId = null,
producerId = ID: DCFR-4099-1254861846625-2: 0:1:1, destination = queue: /
/ IN, transactionId = null, expiration = 0, timestamp = 1254862039687,
arrived
l = 0, brokerInTime = 1254879861750, brokerOutTime = 1254879861765,
CorrelationId = null, ReplyTo = null, persistent = true, type = null,
priority = 4
, GroupID = null, groupSequence = 0, targetConsumerId = null, compressed =
false, userID = null, content = org.apache.activemq.util.ByteSequence @
6baf2
4 marshalledProperties = org.apache.activemq.util.ByteSequence @ 1b7a553,
Datastructures = null, redeliveryCounter = 0, size = 2597, properties =
(Sourc
eEndpoint = null, org_apache_camel_file_name = EUANNA_PCA_20090901
(50e71be4-B408-48b3-9048-4e68faf6cbd3). csv DestinationEndpoint = null,
MessageId = (50e71be
4-B408-48b3-9048-4e68faf6cbd3), Action = PCA PartnerCode = EUANNA,
SourceEndpointUser = null, RequestMessageId = null), readOnlyProperties =
true, readOnlyBo
dy = true, droppable = false) (ActiveMQBytesMessage = null bytesOut, dataOut
= null, @ DATAIN = java.io.DataInputStream 1d314cc)
org.apache.camel.RuntimeCamelException: org.xml.sax.SAXParseException:
Content is not allowed in prolog.
at org.apache.camel.util.ObjectHelper.invokeMethod
(ObjectHelper.java: 567)
at
org.apache.camel.impl.converter.InstanceMethodTypeConverter.convertTo
(InstanceMethodTypeConverter.java: 57)
at org.apache.camel.impl.converter.DefaultTypeConverter.doConvertTo
(DefaultTypeConverter.java: 119)
at org.apache.camel.impl.converter.DefaultTypeConverter.convertTo
(DefaultTypeConverter.java: 90)
at org.apache.camel.impl.MessageSupport.getBody
(MessageSupport.java: 79)
at org.apache.camel.impl.MessageSupport.getBody
(MessageSupport.java: 52)
at org.apache.camel.builder.xml.XPathBuilder.getDocument
(XPathBuilder.java: 536)
at org.apache.camel.builder.xml.XPathBuilder.evaluateAs
(XPathBuilder.java: 428)
at org.apache.camel.builder.xml.XPathBuilder.matches
(XPathBuilder.java: 106)
at org.apache.camel.builder.xml.XPathBuilder.matches
(XPathBuilder.java: 65)
at org.apache.camel.processor.ChoiceProcessor.process
(ChoiceProcessor.java: 47)
at org.apache.camel.management.InstrumentationProcessor.process
(InstrumentationProcessor.java: 80)
Thank you for helping me resolve this problem,
Thank you in advance,
best regards,
titexe
--
View this message in context:
http://www.nabble.com/Camel-%3A-Error-Message-to-CSV-file-tp25781902p25781902.html
Sent from the Camel - Users mailing list archive at Nabble.com.
