[
https://issues.apache.org/jira/browse/CAMEL-13362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrea Cosentino resolved CAMEL-13362.
--------------------------------------
Resolution: Invalid
Please ask on the users mailing list.
> Property value is not access.
> -----------------------------
>
> Key: CAMEL-13362
> URL: https://issues.apache.org/jira/browse/CAMEL-13362
> Project: Camel
> Issue Type: Task
> Components: camel-core-xml
> Affects Versions: 2.23.1
> Reporter: Lee sung Kyu
> Priority: Major
>
> Hi, guys.
> I'm beginner for camel. I have some problem.
> We are implementing file transfer system using camel.
> I set property from external property file.
> But application is not accessed to this property file. We cannot use
> propertyplaceholder because the value will be changed at runtime.
>
> We implemented it like below.
> +camelContext.xml+
>
> {code:java}
> <bean id="myProperties" class="java.util.Properties"/>
> <bean id="propertylist"
> class="org.apache.camel.component.properties.PropertiesComponent">
> <property name="cache" value="true"/>
> <property name="location" value="classpath:camelap.properties"/>
> <property name="overrideProperties" ref="myProperties"/>
> </bean>
> <camelContext id="camelContext-f611cb6c-d516-4346-9adc-5512d327a88d"
> trace="false" xmlns="http://camel.apache.org/schema/spring";>
> <camel:route id="initial_info">
> <camel:from id="_initial" uri="direct:sqlParam"/>
> <camel:to id="_selectReference"
> uri="sql:{{sql.referenceInfo}}?dataSource=dataSource"/>
> <camel:process id="_process1" ref="tempBean"/>
> <camel:log id="_aaaa" loggingLevel="WARN" message="tttttttt ::: {{test}} :::
> ${header.sourceDirectory}"/>
> </camel:route>{code}
> +camelap.properties+ : path : target/classes
> {code:java}
> file.uri=/home/WRK/KR/SND/DAT
> test=OLD_VALUE
> file.pattern=SLPNPM*,SPLNCC*,SLPNCM*,SLPNPC*
> file.target.path1=/home/WRK/KR/SND/NRAT
> file.target.path2=/home/WRK/KR/SND/KDAP
> ############################################
> ## SQL Statement ##
> ############################################
> sql.referenceInfo=SELECT DISTINCT \
> A.WFLOW_INST_ID ,\
> TO_CHAR(A.EFCT_ST_DT,'YYYYMMDDHH24MISS') EFCT_ST_DT, \
> B.NE_ID , \
> B.NE_TYPE_ID , \
> B.CDR_FILE_COLEC_DIR_NM , \
> B.ORIGIN_FMT_ID , \
> B.TRM_DIR_NM , \
> D.CDR_FILE_NMNG_RULE_SBST, \
> D.FILE_NM_LEN , \
> B.FNS_FILE_CRET_YN , \
> B.FNS_FILE_DIV_CD \
> FROM TB_WFLOW_INFO A, \
> TB_CDRSEND_BASE_INFO B, \
> TB_FILE_FMT_INFO D \
> WHERE A.WFLOW_INST_ID = 'P1_IPTVKR' \
> AND B.NE_ID = 'KRLPPM10' \
> AND now() BETWEEN A.EFCT_ST_DT AND A.EXP_DT \
> AND now() BETWEEN B.EFCT_ST_DT AND B.EXP_DT \
> AND A.WFLOW_INST_ID = B.WFLOW_INST_ID \
> AND B.ORIGIN_FMT_ID = D.CDR_FILE_FMT_ID;
> {code}
> Error Log.
> {code:java}
> org.apache.camel.RuntimeCamelException:
> org.apache.camel.FailedToCreateRouteException: Failed to create route
> initial_info at: >>> To[sql:{{sql.referenceInfo}}?dataSource=dataSource] <<<
> in route: Route(initial_info)[[From[direct:sqlParam]] -> [To[sql:{{sql...
> because of Property with key [sql.referenceInfo] not found in properties from
> text: sql:{{sql.referenceInfo}}?dataSource=dataSource
> at
> org.apache.camel.util.ObjectHelper.wrapRuntimeCamelException(ObjectHelper.java:1826)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.spring.SpringCamelContext.start(SpringCamelContext.java:136)
> ~[camel-spring-2.23.1.jar:2.23.1]
> at
> org.apache.camel.spring.CamelContextFactoryBean.start(CamelContextFactoryBean.java:370)
> ~[camel-spring-2.23.1.jar:2.23.1]
> at
> org.apache.camel.spring.CamelContextFactoryBean.onApplicationEvent(CamelContextFactoryBean.java:417)
> ~[camel-spring-2.23.1.jar:2.23.1]
> at
> org.apache.camel.spring.CamelContextFactoryBean.onApplicationEvent(CamelContextFactoryBean.java:95)
> ~[camel-spring-2.23.1.jar:2.23.1]
> at
> org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172)
> ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
> at
> org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165)
> ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
> at
> org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139)
> ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:402)
> ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:359)
> ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:896)
> ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
> at
> org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.finishRefresh(ServletWebServerApplicationContext.java:163)
> ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
> ~[spring-context-5.1.5.RELEASE.jar:5.1.5.RELEASE]
> at
> org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142)
> ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
> at
> org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775)
> ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
> at
> org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
> ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
> at org.springframework.boot.SpringApplication.run(SpringApplication.java:316)
> ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
> at
> org.springframework.boot.SpringApplication.run(SpringApplication.java:1260)
> ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
> at
> org.springframework.boot.SpringApplication.run(SpringApplication.java:1248)
> ~[spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE]
> at com.ktds.openmzn.OpenmznApplication.main(OpenmznApplication.java:25)
> ~[classes/:na]
> Caused by: org.apache.camel.FailedToCreateRouteException: Failed to create
> route initial_info at: >>>
> To[sql:{{sql.referenceInfo}}?dataSource=dataSource] <<< in route:
> Route(initial_info)[[From[direct:sqlParam]] -> [To[sql:{{sql... because of
> Property with key [sql.referenceInfo] not found in properties from text:
> sql:{{sql.referenceInfo}}?dataSource=dataSource
> at
> org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:1352)
> ~[camel-core-2.23.1.jar:2.23.1]
> at org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:212)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext.startRoute(DefaultCamelContext.java:1140)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext.startRouteDefinitions(DefaultCamelContext.java:3735)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext.doStartCamel(DefaultCamelContext.java:3440)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext$4.call(DefaultCamelContext.java:3248)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext$4.call(DefaultCamelContext.java:3244)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext.doWithDefinedClassLoader(DefaultCamelContext.java:3267)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext.doStart(DefaultCamelContext.java:3244)
> ~[camel-core-2.23.1.jar:2.23.1]
> at org.apache.camel.support.ServiceSupport.start(ServiceSupport.java:72)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext.start(DefaultCamelContext.java:3160)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.spring.SpringCamelContext.start(SpringCamelContext.java:133)
> ~[camel-spring-2.23.1.jar:2.23.1]
> ... 18 common frames omitted
> Caused by: java.lang.IllegalArgumentException: Property with key
> [sql.referenceInfo] not found in properties from text:
> sql:{{sql.referenceInfo}}?dataSource=dataSource
> at
> org.apache.camel.component.properties.DefaultPropertiesParser$ParsingContext.getPropertyValue(DefaultPropertiesParser.java:271)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.component.properties.DefaultPropertiesParser$ParsingContext.readProperty(DefaultPropertiesParser.java:157)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.component.properties.DefaultPropertiesParser$ParsingContext.doParse(DefaultPropertiesParser.java:116)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.component.properties.DefaultPropertiesParser$ParsingContext.parse(DefaultPropertiesParser.java:100)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.component.properties.DefaultPropertiesParser.parseUri(DefaultPropertiesParser.java:63)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.component.properties.PropertiesComponent.parseUri(PropertiesComponent.java:235)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.component.properties.PropertiesComponent.parseUri(PropertiesComponent.java:178)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.impl.DefaultCamelContext.resolvePropertyPlaceholders(DefaultCamelContext.java:2547)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.model.ProcessorDefinitionHelper.resolvePropertyPlaceholders(ProcessorDefinitionHelper.java:737)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.model.ProcessorDefinition.makeProcessorImpl(ProcessorDefinition.java:544)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.model.ProcessorDefinition.makeProcessor(ProcessorDefinition.java:530)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.model.ProcessorDefinition.addRoutes(ProcessorDefinition.java:240)
> ~[camel-core-2.23.1.jar:2.23.1]
> at
> org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:1349)
> ~[camel-core-2.23.1.jar:2.23.1]
> ... 29 common frames omitted
> {code}
> Please check and comment.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
