Re: camel sql joined query with parameters won't run on sql server

2016-06-25 Thread John Taylor
Hi Ronny, I had the same kind of problem recently and it turned out to be something to do with the driver not correctly returning the number of parameters. I ended up needing to use the parametersCount option. It is described at http://camel.apache.org/sql-component.html Regards, -John Ronny A

camel sql joined query with parameters won't run on sql server

2016-06-25 Thread Ronny Aerts
Hello camel user community, I have strange problem with a Microsoft sql server database joined query where I would like to have some advice. I have 2 spring dsl steps in a route: The siteno and locationno are in a header. Both steps run perfectly good in a firebird database and produce follow

Re: camel salesforce component date time issue

2016-06-25 Thread arno noordover
Hmm, I had the same problem communicating with WCF. I generated classes from a wsdl containing jodatimes and used a simple conversion to convert this to a string. I needed to create a special jodatime-format which didn't contain the seconds part in the time-zone offset. Although it is technically c

camel salesforce component date time issue

2016-06-25 Thread ssatguru
camel salesforce component has issues with dates less than or equal to "November 18th 1883". These dates are serialized to a format unacceptable to SalesForce. For example Date 1800-01-01 is serialized by this component as 1800-01-01T00:00:00.000-05:50:36 Salesforce responds with the follow