Hi Use dataSource=#infor.DataSource instead of dataSourceRef
On Sat, May 4, 2013 at 2:50 PM, kalber <[email protected]> wrote: > Hi, > > upgrading to 2.11 in the lib/optional directory aren't spring release 3.0.7 > jars : > spring-beans-3.0.7.RELEASE.jar > spring-core-3.0.7.RELEASE.jar > spring-jdbc-3.0.7.RELEASE.jar > spring-tx-3.0.7.RELEASE.jar > > > I can use these on ? > > Doing this i get this error what with 2.10 works well : > > org.apache.camel.FailedToCreateRouteException: Failed to create route route2 > at: >>> To[sql:select obj_code, > cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'CODSOLAR') > solari_code,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'IPNLDISP') > device_type > ,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'SERIGRAP') > serigraphy, obj_category > ,nvl(cust_obj.getPropertyNum(obj_obtype,obj_code,obj_org,'IPNLDELP'),0) > delete_passage_after from r5objects where obj_class = 'IPNL' and > obj_obrtype = 'A' order by obj_location, > obj_code?dataSourceRef=infor.DataSource] <<< in route: > Route(route2)[[From[direct:infor.select.iPnl.objects]] -> [T... because of > Failed to resolve endpoint: > sql://select%20obj_code,%20cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'CODSOLAR')%20solari_code,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'IPNLDISP')%20device_type%20,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'SERIGRAP')%20serigraphy,%20obj_category%20,nvl(cust_obj.getPropertyNum(obj_obtype,obj_code,obj_org,'IPNLDELP'),0)%20delete_passage_after%20from%20r5objects%20%20where%20obj_class%20=%20'IPNL'%20and%20obj_obrtype%20=%20'A'%20order%20by%20obj_location,%20obj_code?dataSourceRef=infor.DataSource > due to: Failed to resolve endpoint: > sql://select%20obj_code,%20cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'CODSOLAR')%20solari_code,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'IPNLDISP')%20device_type%20,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'SERIGRAP')%20serigraphy,%20obj_category%20,nvl(cust_obj.getPropertyNum(obj_obtype,obj_code,obj_org,'IPNLDELP'),0)%20delete_passage_after%20from%20r5objects%20%20where%20obj_class%20=%20'IPNL'%20and%20obj_obrtype%20=%20'A'%20order%20by%20obj_location,%20obj_code?dataSourceRef=infor.DataSource > due to: There are 1 parameters that couldn't be set on the endpoint. Check > the uri if the parameters are spelt correctly and that they are properties > of the endpoint. Unknown parameters=[{dataSourceRef=infor.DataSource}] > at > org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:883) > at > org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:176) > at > org.apache.camel.impl.DefaultCamelContext.startRoute(DefaultCamelContext.java:750) > at > org.apache.camel.impl.DefaultCamelContext.startRouteDefinitions(DefaultCamelContext.java:1829) > at > org.apache.camel.impl.DefaultCamelContext.doStartCamel(DefaultCamelContext.java:1609) > at > org.apache.camel.impl.DefaultCamelContext.doStart(DefaultCamelContext.java:1478) > at > org.apache.camel.support.ServiceSupport.start(ServiceSupport.java:61) > at > org.apache.camel.impl.DefaultCamelContext.start(DefaultCamelContext.java:1446) > at > it.sad.sii.solari.loadPassages.build.DeviceMappingProcess.start(DeviceMappingProcess.java:50) > at it.sad.lib.batch.ProcessHandler.process(ProcessHandler.java:39) > at > it.sad.sii.solari.loadPassages.build.DeviceMappingProcess.main(DeviceMappingProcess.java:40) > Caused by: org.apache.camel.ResolveEndpointFailedException: Failed to > resolve endpoint: > sql://select%20obj_code,%20cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'CODSOLAR')%20solari_code,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'IPNLDISP')%20device_type%20,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'SERIGRAP')%20serigraphy,%20obj_category%20,nvl(cust_obj.getPropertyNum(obj_obtype,obj_code,obj_org,'IPNLDELP'),0)%20delete_passage_after%20from%20r5objects%20%20where%20obj_class%20=%20'IPNL'%20and%20obj_obrtype%20=%20'A'%20order%20by%20obj_location,%20obj_code?dataSourceRef=infor.DataSource > due to: Failed to resolve endpoint: > sql://select%20obj_code,%20cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'CODSOLAR')%20solari_code,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'IPNLDISP')%20device_type%20,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'SERIGRAP')%20serigraphy,%20obj_category%20,nvl(cust_obj.getPropertyNum(obj_obtype,obj_code,obj_org,'IPNLDELP'),0)%20delete_passage_after%20from%20r5objects%20%20where%20obj_class%20=%20'IPNL'%20and%20obj_obrtype%20=%20'A'%20order%20by%20obj_location,%20obj_code?dataSourceRef=infor.DataSource > due to: There are 1 parameters that couldn't be set on the endpoint. Check > the uri if the parameters are spelt correctly and that they are properties > of the endpoint. Unknown parameters=[{dataSourceRef=infor.DataSource}] > at > org.apache.camel.impl.DefaultCamelContext.getEndpoint(DefaultCamelContext.java:508) > at > org.apache.camel.util.CamelContextHelper.getMandatoryEndpoint(CamelContextHelper.java:62) > at > org.apache.camel.model.RouteDefinition.resolveEndpoint(RouteDefinition.java:191) > at > org.apache.camel.impl.DefaultRouteContext.resolveEndpoint(DefaultRouteContext.java:108) > at > org.apache.camel.impl.DefaultRouteContext.resolveEndpoint(DefaultRouteContext.java:114) > at > org.apache.camel.model.SendDefinition.resolveEndpoint(SendDefinition.java:61) > at > org.apache.camel.model.SendDefinition.createProcessor(SendDefinition.java:55) > at > org.apache.camel.model.ProcessorDefinition.makeProcessor(ProcessorDefinition.java:479) > at > org.apache.camel.model.ProcessorDefinition.addRoutes(ProcessorDefinition.java:197) > at > org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:880) > ... 10 more > Caused by: org.apache.camel.ResolveEndpointFailedException: Failed to > resolve endpoint: > sql://select%20obj_code,%20cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'CODSOLAR')%20solari_code,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'IPNLDISP')%20device_type%20,cust_obj.getPropertyChar(obj_obtype,obj_code,obj_org,'SERIGRAP')%20serigraphy,%20obj_category%20,nvl(cust_obj.getPropertyNum(obj_obtype,obj_code,obj_org,'IPNLDELP'),0)%20delete_passage_after%20from%20r5objects%20%20where%20obj_class%20=%20'IPNL'%20and%20obj_obrtype%20=%20'A'%20order%20by%20obj_location,%20obj_code?dataSourceRef=infor.DataSource > due to: There are 1 parameters that couldn't be set on the endpoint. Check > the uri if the parameters are spelt correctly and that they are properties > of the endpoint. Unknown parameters=[{dataSourceRef=infor.DataSource}] > at > org.apache.camel.impl.DefaultComponent.validateParameters(DefaultComponent.java:183) > at > org.apache.camel.impl.DefaultComponent.createEndpoint(DefaultComponent.java:133) > at > org.apache.camel.impl.DefaultCamelContext.getEndpoint(DefaultCamelContext.java:488) > ... 19 more > 04-05-2013 14:47:28 INFO [main] DeviceMappingProcess: End: 2013-05-04 > 14:47:28, elapsed seconds 1 > > > > > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Upgrade-from-2-10-2-11-0-tp5732017.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen ----------------- Red Hat, Inc. FuseSource is now part of Red Hat Email: [email protected] Web: http://fusesource.com Twitter: davsclaus Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen
