There is a problem with the dataFormat MESSAGE and an XSLT transformation?

2014-11-03 Thread aioria3077
Good day to all


I have the following request:


soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/;
xmlns:ws=http://ws.ampersand.mx; xmlns:mod=http://modelo.ampersand.mx;
   soapenv:Header/
   soapenv:Body
  ws:PointsExchangeFR2CPCion
 ws:request
mod:accountNumber6508/mod:accountNumber
mod:activityDate2014-09-01T00:00:00/mod:activityDate
mod:amountKM1500/mod:amountKM
mod:externalAuthorizationCodeId unico Grupo
Posadas/mod:externalAuthorizationCode
 /ws:request
  /ws:PointsExchangeFR2CPCion
   /soapenv:Body
/soapenv:Envelope

my camel route command to call the transformation:


?xml version=1.0 encoding=UTF-8?
xsl:stylesheet version=2.0
xmlns:xsl=http://www.w3.org/1999/XSL/Transform; 
   xmlns:ws=http://ws.ampersand.mx; xmlns:mod=http://modelo.ampersand.mx;
   xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/;
   xsl:template match=/
  soapenv:Envelope
xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/;
xmlns:mer=http://skywards.com/Mercator.CRIS.WS;
   soapenv:Body
  mer:CreateAccrualActivity
 mer:programmeMemberEntities
mer:ProgrammeMemberActivity
   mer:PersonID
  mer:IsQueryfalse/mer:IsQuery
  mer:QueryString/mer:QueryString
 
mer:ContainsQueryOperatorsfalse/mer:ContainsQueryOperators
  mer:HasValuefalse/mer:HasValue
  mer:Value0/mer:Value
   /mer:PersonID
   mer:NumberOfActivityUnits
  mer:IsQueryfalse/mer:IsQuery
  mer:QueryString/mer:QueryString
 
mer:ContainsQueryOperatorsfalse/mer:ContainsQueryOperators
  mer:HasValuetrue/mer:HasValue
  *mer:Valuexsl:value-of
select=ws:PointsExchangeFR2CPCion/ws:request/mod:amountKM//mer:Value*
   /mer:NumberOfActivityUnits
   mer:Bcp/mer:Bcp
   mer:PmaDate
  mer:IsQueryfalse/mer:IsQuery
  mer:QueryString/mer:QueryString
 
mer:ContainsQueryOperatorsfalse/mer:ContainsQueryOperators
  mer:HasValuetrue/mer:HasValue
  *mer:Valuexsl:value-of
select=ws:PointsExchangeFR2CPCion/ws:request/mod:activityDate//mer:Value*
   /mer:PmaDate
   mer:RedeemedStatus/mer:RedeemedStatus
   mer:FareBasis/mer:FareBasis
   mer:Inv_by_ptnr_date
  mer:IsQueryfalse/mer:IsQuery
  mer:QueryString/mer:QueryString
 
mer:ContainsQueryOperatorsfalse/mer:ContainsQueryOperators
  mer:HasValuefalse/mer:HasValue
  mer:Value0001-01-01T00:00:00/mer:Value
   /mer:Inv_by_ptnr_date
   mer:RevCodeCOMP/mer:RevCode
   mer:PNRName/mer:PNRName
   mer:HuetCode/mer:HuetCode
   mer:RpsCode/mer:RpsCode
  
mer:Rps_code_after_time_limit/mer:Rps_code_after_time_limit
   mer:BilledCancelledAct/mer:BilledCancelledAct
   mer:CouponNumber
  mer:IsQueryfalse/mer:IsQuery
  mer:QueryString/mer:QueryString
 
mer:ContainsQueryOperatorsfalse/mer:ContainsQueryOperators
  mer:HasValuefalse/mer:HasValue
  mer:Value0/mer:Value
   /mer:CouponNumber
   mer:Diff/mer:Diff
   *mer:ActiveCardNoxsl:value-of
select=ws:PointsExchangeFR2CPCion/ws:request/mod:accountNumber//mer:ActiveCardNo*
  
mer:InsertRejectedActivitiesfalse/mer:InsertRejectedActivities
   mer:NewRowStatusfalse/mer:NewRowStatus
   mer:ForceUpdatefalse/mer:ForceUpdate
   mer:TerminalID/mer:TerminalID
   *mer:ExternalAuthorizationCodexsl:value-of
select=ws:PointsExchangeFR2CPCion/ws:request/mod:externalAuthorizationCode//mer:ExternalAuthorizationCode*
   mer:NumberOfUnits
  mer:IsQueryfalse/mer:IsQuery
  mer:QueryString/mer:QueryString
 
mer:ContainsQueryOperatorsfalse/mer:ContainsQueryOperators
  mer:HasValuefalse/mer:HasValue
  mer:Value0/mer:Value
   /mer:NumberOfUnits
   mer:IsCurrency/mer:IsCurrency
   mer:Source?/mer:Source
/mer:ProgrammeMemberActivity
 /mer:programmeMemberEntities
  /mer:CreateAccrualActivity
  /soapenv:Body
/soapenv:Envelope
   /xsl:template
/xsl:stylesheet


camel route looks like this endpoint with dataFormat MESSAGE



cxf:cxfEndpoint id=PointsExchangeFR2CPProxy
   address=/PointsExchangeFR2CPService
   wsdlURL=wsdl/proxy.wsdl/


  
  cxf:cxfEndpoint id=ClubPremierEndpoint 
   
address=http://cr5w5cptest.clubpremier.com/Mercator.CRIS.WebService.TESTCRIS/MemberWebService.asmx;
 
wsdlURL=wsdl/MemberWebService.wsdl

Re: please help with transformation of a response by xslt

2014-09-22 Thread aioria3077
thanks, run the transformation to String after the XSLT transformation,
continuous error, I think it's my transformation which is having problems,
I'll check, thank you very much for your help



--
View this message in context: 
http://camel.465427.n5.nabble.com/please-help-with-transformation-of-a-response-by-xslt-tp5756711p5756850.html
Sent from the Camel - Users mailing list archive at Nabble.com.


RE: please help with transformation of a response by xslt

2014-09-22 Thread aioria3077
Thank you very much for this information, and check the coding of the
original RESPONSE and matches my XSLT transformation, both are UTF-8.



--
View this message in context: 
http://camel.465427.n5.nabble.com/please-help-with-transformation-of-a-response-by-xslt-tp5756711p5756852.html
Sent from the Camel - Users mailing list archive at Nabble.com.


Re: please help with transformation of a response by xslt

2014-09-22 Thread aioria3077
effectively, since last week Always change a PAYLOAD to MESSAGE data format.

 I'm about to check out the transformation with the manager of that part
because apparently that's where we're having problems, thank you very much



--
View this message in context: 
http://camel.465427.n5.nabble.com/please-help-with-transformation-of-a-response-by-xslt-tp5756711p5756851.html
Sent from the Camel - Users mailing list archive at Nabble.com.


Re: please help with transformation of a response by xslt

2014-09-20 Thread aioria3077
if the call to the original web service, the change will dataFormat MESSAGE 
by PAYLOAD, The error is:

The PayLoad elements cannot fit with the message parts of the
BindingOperation. Please check the BindingOperation and PayLoadMessage. 


I make the first transformation successfully receiving the REQUEST as
dataFormat PAYLOAD, I realize that a change to MESSAGE in the original WS
call is where the transformation does not work, 

There is some problem the xslt with MESSAGE dataFormat being that before
sending the body convert STRING



--
View this message in context: 
http://camel.465427.n5.nabble.com/please-help-with-transformation-of-a-response-by-xslt-tp5756711p5756757.html
Sent from the Camel - Users mailing list archive at Nabble.com.


Re: please help with transformation of a response by xslt

2014-09-19 Thread aioria3077
*thanks for replying, really like right before calling xsl transformer, I
have this line*


* convertBodyTo type=java.lang.String /*
 to uri=xslt:xslt/ClubPremier/response.xslt /

will try to put it back then see what happens. 

any other suggestions?



--
View this message in context: 
http://camel.465427.n5.nabble.com/please-help-with-transformation-of-a-response-by-xslt-tp5756711p5756748.html
Sent from the Camel - Users mailing list archive at Nabble.com.


please help with transformation of a response by xslt

2014-09-18 Thread aioria3077
*have a original Web Services, a proxy which has a transformation because you
need to add data authentication, the request works fine, can consume the
service, but I need to transform the response to the expectations created my
webService proxy, the transformation applied in the same way which the
request is armed, but I get an error:*


2014-09-18 17:27:46,714 | WARN | qtp1787857896-70 | PhaseInterceptorChain |
? ? | 164 - org.apache.cxf.cxf-api - 2.7.0.redhat-610379 | Interceptor for
{http://www.ampersand.mx/FiestaRewardsServices;
target=_blankhttp://www.ampersand.mx/FiestaRewardsServices}PointsExchangeFR2CPPortTypeService#{http://www.ampersand.mx/FiestaRewardsServices;
target=_blankhttp://www.ampersand.mx/FiestaRewardsServices}PointsExchangeFR2CPOp
has thrown exception, unwinding now 
java.lang.ClassCastException: java.io.ByteArrayInputStream cannot be cast to
javax.xml.transform.Source 
at
org.apache.cxf.databinding.source.XMLStreamDataWriter.write(XMLStreamDataWriter.java:79)[162:org.apache.cxf.cxf-rt-core:2.7.0.redhat-610379]
 
at
org.apache.cxf.databinding.source.XMLStreamDataWriter.write(XMLStreamDataWriter.java:54)[162:org.apache.cxf.cxf-rt-core:2.7.0.redhat-610379]
 
at
org.apache.camel.component.cxf.HybridSourceDataBinding$1.write(HybridSourceDataBinding.java:100)[205:org.apache.camel.camel-cxf:2.12.0.redhat-610379]
 
at
org.apache.camel.component.cxf.HybridSourceDataBinding$1.write(HybridSourceDataBinding.java:81)[205:org.apache.camel.camel-cxf:2.12.0.redhat-610379]
 
at
org.apache.cxf.interceptor.AbstractOutDatabindingInterceptor.writeParts(AbstractOutDatabindingInterceptor.java:123)[164:org.apache.cxf.cxf-api:2.7.0.redhat-610379]
 
at
org.apache.cxf.interceptor.BareOutInterceptor.handleMessage(BareOutInterceptor.java:68)[164:org.apache.cxf.cxf-api:2.7.0.redhat-610379]
 
at
org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:272)[164:org.apache.cxf.cxf-api:2.7.0.redhat-610379]
at
org.apache.cxf.interceptor.OutgoingChainInterceptor.handleMessage(OutgoingChainInterceptor.java:77)[164:org.apache.cxf.cxf-api:2.7.0.redhat-610379]


*this is my camel-context.xml*


?xml version=1.0 encoding=UTF-8?
beans
xmlns:spring-security=http://www.springframework.org/schema/security;
xmlns=http://www.springframework.org/schema/beans; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xmlns:camel=http://camel.apache.org/schema/spring;
xmlns:osgi=http://www.springframework.org/schema/osgi;
xmlns:cxf=http://camel.apache.org/schema/cxf;
xmlns:poin=http://www.ampersand.mx/PointsExchangeFR2CPReq;
xsi:schemaLocation=
   http://camel.apache.org/schema/spring/security
  
http://camel.apache.org/schema/spring/security/camel-spring-security.xsd
   http://www.springframework.org/schema/security
   http://www.springframework.org/schema/security/spring-security.xsd
   http://camel.apache.org/schema/security
http://camel.apache.org/schema/security/camel-security.xsd
   http://www.springframework.org/schema/beans 
   http://www.springframework.org/schema/beans/spring-beans.xsd
   http://www.springframework.org/schema/osgi 
   http://www.springframework.org/schema/osgi/spring-osgi.xsd
   http://camel.apache.org/schema/spring 
   http://camel.apache.org/schema/spring/camel-spring.xsd
   http://camel.apache.org/schema/cxf 
   http://camel.apache.org/schema/cxf/camel-cxf-2.8.3.xsd;


bean id=cleanerProcessor
class=mx.ampersand.processors.RequestCleanerProcessor /


cxf:cxfEndpoint id=PointsExchangeFR2CPProxy
address=/PointsExchangeFR2CPService
serviceClass=mx.ampersand.fiestarewardsservices.PointsExchangeFR2CPPortType
/cxf:cxfEndpoint


cxf:cxfEndpoint id=ClubPremierEndpoint
address=http://cr5w5cptest.clubpremier.com/Mercator.CRIS.WebService.TESTCRIS/MemberWebService.asmx;
wsdlURL=wsdl/MemberWebService.wsdl
cxf:properties
entry key=dataFormat value=MESSAGE /
/cxf:properties
/cxf:cxfEndpoint

camelContext
id=mx.ampersand.fiestarewardsservices.PointsExchangeFR2CP-Proxy
xmlns=http://camel.apache.org/schema/spring;
route id=proxy
from
uri=cxf:bean:PointsExchangeFR2CPProxy?dataFormat=PAYLOADamp;loggingFeatureEnabled=true
/
to uri=log:output?showAll=true /

to uri=cleanerProcessor/

convertBodyTo type=java.lang.String /

to uri=xslt:xslt/ClubPremier/request.xslt /

setHeader headerName=operationName
constantCreateAccrualActivity/constant
/setHeader
setHeader headerName=SOAPAction

constanthttp://skywards.com/Mercator.CRIS.WS/CreateAccrualActivity/constant
/setHeader

   

problems with camel-example-cxf-proxy example of CLAUSIBSEN

2014-08-07 Thread aioria3077
I run the example successfully with mvn camel: run, 
doubt is that I want to create my own project to deploy proxy in fuse
container. 

the example of claus has the following dependencies ( seems to me important
):

camel-core

camel-spring

camel-http

camel-cxf

cxf-rt-frontend-jaxws

cxf-rt-transports-http

cxf-rt-transports-http-jetty


when I create my own project I put these units with their versions. 

Here I show my pom.xml

?xml version=1.0 encoding=UTF-8?
project xmlns=http://maven.apache.org/POM/4.0.0;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://maven.apache.org/POM/4.0.0
http://maven.apache.org/maven-v4_0_0.xsd;

  modelVersion4.0.0/modelVersion

  groupIdcom.cion/groupId
  artifactIdwsProxy/artifactId
  packagingbundle/packaging
  version1.0.0/version

  nameActiveMQ embedded with Camel/name
  urlhttp://www.myorganization.org/url

  properties
project.build.sourceEncodingUTF-8/project.build.sourceEncoding
   
project.reporting.outputEncodingUTF-8/project.reporting.outputEncoding
  /properties

  dependencies
dependency
  groupIdorg.apache.camel/groupId
  artifactIdcamel-core/artifactId
  version2.13.2/version
/dependency
dependency
  groupIdorg.apache.camel/groupId
  artifactIdcamel-jms/artifactId
  version2.13.2/version
/dependency
dependency
  groupIdorg.apache.camel/groupId
  artifactIdcamel-spring/artifactId
  version2.13.2/version
/dependency


dependency
  groupIdorg.apache.activemq/groupId
  artifactIdactivemq-client/artifactId
  version5.9.1/version
/dependency
dependency
  groupIdorg.apache.activemq/groupId
  artifactIdactivemq-camel/artifactId
  version5.9.1/version
/dependency
dependency
  groupIdorg.apache.activemq/groupId
  artifactIdactivemq-pool/artifactId
  version5.9.1/version
/dependency


dependency
  groupIdorg.apache.activemq/groupId
  artifactIdactivemq-broker/artifactId
  version5.9.1/version
/dependency
dependency
  groupIdorg.apache.activemq/groupId
  artifactIdactivemq-spring/artifactId
  version5.9.1/version
/dependency
dependency
  groupIdorg.apache.activemq/groupId
  artifactIdactivemq-kahadb-store/artifactId
  version5.9.1/version
/dependency
dependency
  groupIdorg.apache.xbean/groupId
  artifactIdxbean-spring/artifactId
  version3.16/version
/dependency
dependency
  groupIdorg.springframework/groupId
  artifactIdspring-context/artifactId
  version3.2.8.RELEASE/version
/dependency


dependency
  groupIdorg.slf4j/groupId
  artifactIdslf4j-api/artifactId
  version1.7.7/version
/dependency
dependency
  groupIdorg.slf4j/groupId
  artifactIdslf4j-log4j12/artifactId
  version1.7.7/version
/dependency
dependency
  groupIdlog4j/groupId
  artifactIdlog4j/artifactId
  version1.2.17/version
/dependency


dependency
  groupIdorg.apache.camel/groupId
  artifactIdcamel-test-spring/artifactId
  version2.13.2/version
  scopetest/scope
/dependency

dependency
groupIdorg.apache.camel/groupId
artifactIdcamel-http/artifactId
version2.13.2/version
/dependency
dependency
groupIdorg.apache.camel/groupId
artifactIdcamel-cxf/artifactId
version2.13.2/version
/dependency
dependency
groupIdorg.apache.cxf/groupId
artifactIdcxf-rt-frontend-jaxws/artifactId
version3.0.1/version
/dependency
dependency
groupIdorg.apache.cxf/groupId
artifactIdcxf-rt-transports-http/artifactId
version3.0.1/version
/dependency
dependency
groupIdorg.apache.cxf/groupId
artifactIdcxf-rt-transports-http-jetty/artifactId
version3.0.1/version
/dependency
dependency
groupIdjunit/groupId
artifactIdjunit/artifactId
version4.11/version
scopetest/scope
/dependency
dependency
groupIdorg.apache.camel/groupId
artifactIdcamel-test/artifactId
version2.13.2/version
scopetest/scope
/dependency
  /dependencies

  build
defaultGoalinstall/defaultGoal

plugins
  plugin
groupIdorg.apache.maven.plugins/groupId
artifactIdmaven-compiler-plugin/artifactId
version2.5.1/version
configuration
  source1.6/source
  target1.6/target
/configuration
  /plugin
  plugin
groupIdorg.apache.maven.plugins/groupId
artifactIdmaven-resources-plugin/artifactId
version2.6/version
configuration
  encodingUTF-8/encoding
/configuration
  /plugin

  
  plugin
groupIdorg.apache.camel/groupId
artifactIdcamel-maven-plugin/artifactId
version2.13.2/version
  /plugin
  
  plugin

Re: how to deploy a project with a CAMEL-XSTREAM in fuse fabric container

2014-07-11 Thread aioria3077
I use spring-context'll get it but it is better to use blueprint 

I'll check the bundle mentioned by Charles Moulliard and be back to post the
results, thanks



--
View this message in context: 
http://camel.465427.n5.nabble.com/how-to-deploy-a-project-with-a-CAMEL-XSTREAM-in-fuse-fabric-container-tp5753655p5753729.html
Sent from the Camel - Users mailing list archive at Nabble.com.


Re: how to deploy a project with a CAMEL-XSTREAM in fuse fabric container

2014-07-11 Thread aioria3077
Thanks so much.

effectively that was the bundle that I need to, this is a world of camel and
fuse or say



--
View this message in context: 
http://camel.465427.n5.nabble.com/how-to-deploy-a-project-with-a-CAMEL-XSTREAM-in-fuse-fabric-container-tp5753655p5753734.html
Sent from the Camel - Users mailing list archive at Nabble.com.


how to deploy a project with a CAMEL-XSTREAM in fuse fabric container

2014-07-10 Thread aioria3077
they would greatly appreciate your help

my exercise is to convert a CSV separated by | to a XML, in which I'm
using camel-bindy and camel-xstream,

everything works fine if running with mvn camel:run

I show my camel-context

...
...
...
bean id=activemq
class=org.apache.activemq.camel.component.ActiveMQComponent
property name=brokerURL value=tcp://localhost:61618/
property name=userName value=admin/
property name=password value=admin/
/bean

  camelContext xmlns=http://camel.apache.org/schema/spring;

dataFormats
bindy id=bindy type=Csv classType=com.cion.csvBindy.CSVtoXML/
xstream id=xstream
aliases
alias name=movimiento 
class=com.cion.csvBindy.CSVtoXML /
/aliases  
/xstream
/dataFormats

route
  from uri=file:work/input/
split parallelProcessing=true streaming=true
tokenize token=\n group=1/
log message=${body}/
to uri=activemq:colaSplit/
/split
/route

route
from uri=activemq:colaSplit/
log message=salida de la cola: ${body}/
unmarshal ref=bindy/
log message=despues de unmarshal: ${body}/
marshal ref=xstream/
log message=despues de marshal con Xstream: ${body}/
to uri=activemq:colaXML/
/route

/camelContext

*REPEAT is working properly.* 

the problem comes when I have to deployar in a FUSE FABRIC CONTAINER

for this I created a profile with the following characteristics:

parents: mq-client, feature-camel

features: camel, camel-spring, camel-core, camel-bindy, camel-xstream,
activemq-camel

repositories: mvn:org.apache.activemq/features
   mvn:org.apache.camel.karaf/features

and the project as a bundle

THE PROFILE IS PROVISIONED CORRECTLY, the work / input directory is
created within the container

when I insert the file, this is spent correctly, the problem comes in the
second route right on the part of:

marshal ref=xstream/

reviewing the log of the container, the error is as follows:

2014-07-10 13:23:56,497 | WARN  | sumer[colaSplit] | EndpointMessageListener
 
| rg.apache.camel.util.CamelLogger  224 | 113 - org.apache.camel.camel-core
- 2.12.0.redhat-610379 | Execution of JMS message listener failed. Caused
by: [java.lang.NoClassDefFoundError - org/xmlpull/v1/XmlPullParserException]
java.lang.NoClassDefFoundError: org/xmlpull/v1/XmlPullParserException
at com.thoughtworks.xstream.XStream.init(XStream.java:350)
at
org.apache.camel.dataformat.xstream.AbstractXStreamWrapper.createXStream(AbstractXStreamWrapper.java:79)
at
org.apache.camel.dataformat.xstream.AbstractXStreamWrapper.getXStream(AbstractXStreamWrapper.java:66)
at
org.apache.camel.dataformat.xstream.AbstractXStreamWrapper.marshal(AbstractXStreamWrapper.java:204)
at
org.apache.camel.processor.MarshalProcessor.process(MarshalProcessor.java:81)
at
org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:72)
at
org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:398)
at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)
at org.apache.camel.processor.Pipeline.process(Pipeline.java:118)
at org.apache.camel.processor.Pipeline.process(Pipeline.java:80)
at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)
at
org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:105)
at
org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:87)
at
org.apache.camel.component.jms.EndpointMessageListener.onMessage(EndpointMessageListener.java:103)
at
org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:562)[129:org.apache.servicemix.bundles.spring-jms:3.2.8.RELEASE_1]
at
org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:500)[129:org.apache.servicemix.bundles.spring-jms:3.2.8.RELEASE_1]
at
org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:468)[129:org.apache.servicemix.bundles.spring-jms:3.2.8.RELEASE_1]
at
org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)[129:org.apache.servicemix.bundles.spring-jms:3.2.8.RELEASE_1]
at
org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)[129:org.apache.servicemix.bundles.spring-jms:3.2.8.RELEASE_1]
at

Problem with inserting database from camel-context.xml

2014-06-25 Thread aioria3077
hi good day, I'm new to all this.

i have the following

split parallelProcessing=true streaming=true
tokenize token=\n group=1/
unmarshalcsv//unmarshal
transform
simple${body[0]}/simple
/transform
log message=${body}/
to uri=sql:INSERT INTO prueba(id, nombre, sex, num)
VALUES(#,#,#,#)/
..
..

which works correctly when fields of my database are TEXT, but if I have a
field, for example, ID int, not performing insert, 

any solution within the camel-context.xml or have to resort to a java class
that I do the transformation?




--
View this message in context: 
http://camel.465427.n5.nabble.com/Problem-with-inserting-database-from-camel-context-xml-tp5752810.html
Sent from the Camel - Users mailing list archive at Nabble.com.