Return-Path: 
 <issues-return-25068-apmail-camel-issues-archive=camel.apache.org@camel.apache.org>
X-Original-To: apmail-camel-issues-archive@minotaur.apache.org
Delivered-To: apmail-camel-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id A527817403
	for <apmail-camel-issues-archive@minotaur.apache.org>;
 Sat, 23 May 2015 03:10:17 +0000 (UTC)
Received: (qmail 97169 invoked by uid 500); 23 May 2015 03:10:17 -0000
Delivered-To: apmail-camel-issues-archive@camel.apache.org
Received: (qmail 97123 invoked by uid 500); 23 May 2015 03:10:17 -0000
Mailing-List: contact issues-help@camel.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@camel.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@camel.apache.org>
List-Post: <mailto:issues@camel.apache.org>
List-Id: <issues.camel.apache.org>
Reply-To: dev@camel.apache.org
Delivered-To: mailing list issues@camel.apache.org
Received: (qmail 97114 invoked by uid 99); 23 May 2015 03:10:17 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 May 2015 03:10:17 +0000
Date: Sat, 23 May 2015 03:10:17 +0000 (UTC)
From: =?utf-8?Q?=E9=BB=84=E9=A2=9C=E6=9C=A8_=28JIRA=29?= <jira@apache.org>
To: issues@camel.apache.org
Message-ID: <JIRA.12832118.1432288986000.15551.1432350617388@Atlassian.JIRA>
In-Reply-To: <JIRA.12832118.1432288986000@Atlassian.JIRA>
References: <JIRA.12832118.1432288986000@Atlassian.JIRA>
 <JIRA.12832118.1432288986505@arcas>
Subject: [jira] [Updated] (CAMEL-8792)
 org.apache.camel.language.bean.RuntimeBeanExpressionException: Failed to
 invoke method:
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


     [ https://issues.apache.org/jira/browse/CAMEL-8792?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

=E9=BB=84=E9=A2=9C=E6=9C=A8 updated CAMEL-8792:
-----------------------
    Description:=20
1. when just use sqlComponents ,its okay.=20
2. I try to just run the sql one times,so add timer//foo?repeatCount=3D1
error happend. =20

my code goes here:
---------------------------------------------------------------------------=
-
...
 42
 43   <bean id=3D"categoryBean" class=3D"com.ofbizian.CategoryBean"/>
 44
...
 53     <route id=3D"encoderCategory-route">
 54       <!-- =E4=BB=85=E8=BF=90=E8=A1=8C=E4=B8=80=E6=AC=A1-->
 55       <from uri=3D"timer://foo?repeatCount=3D1"/>
 56       <to uri=3D"sql:{{sql.selectCategory}}?outputClass=3Dcom.ofbizian.=
CategoryBean"/>
...
=20
---------------------------------------------------------------------------=
----
CategoryBean.java
  1 package com.ofbizian;
  2
  3 public class CategoryBean{
  4 private String mainid;
...
  8
  9 public String getMainid(){
 10   return mainid;
 11 }
 12
 13 public void setMainid(String mainid){
 14   this.mainid=3Dmainid;
 15 }
 16
 ...
 40 }
    =20



  was:
1. when just use sqlComponents ,its okay.=20
2. I try to just run the sql one times,so add timer//foo?repeatCount=3D1
error happend. =20

my code goes here:
 <beans xmlns=3D"http://www.springframework.org/schema/beans"
 19        xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance"
 20        xmlns:camel=3D"http://camel.apache.org/schema/spring"
 21        xsi:schemaLocation=3D"
 22        http://www.springframework.org/schema/beans http://www.springfra=
mework.org/schema/beans/spring-beans.xsd
 23        http://camel.apache.org/schema/spring http://camel.apache.org/sc=
hema/spring/camel-spring.xsd">
 24
 25   <!-- this is the JDBC data source which uses an Oracle database -->
 26   <bean id=3D"dataSource" class=3D"org.apache.commons.dbcp.BasicDataSou=
rce" destroy-method=3D"close">
 27     <property name=3D"driverClassName" value=3D"oracle.jdbc.driver.Orac=
leDriver"/>
 28     <property name=3D"url" value=3D"jdbc:oracle:thin:@xxxx.xxx.xxx.xxx:=
1521:test"/>
 29     <property name=3D"username" value=3D"xxx"/>
 30     <property name=3D"password" value=3D"xxx"/>
 31   </bean>
 32
 33   <!-- configure the Camel SQL component to use the JDBC data source --=
>
 34   <bean id=3D"sql" class=3D"org.apache.camel.component.sql.SqlComponent=
">
 35     <property name=3D"dataSource" ref=3D"dataSource"/>
 36   </bean>
 37
 38   <!-- ofbiz remote dispatcher -->
 39   <bean id=3D"ofbizDispatcher" class=3D"com.ofbizian.OfbizDispatcher">
 40     <constructor-arg ref=3D"remoteDispatcher"/>
 41   </bean>
 42
 43   <bean id=3D"categoryBean" class=3D"com.ofbizian.CategoryBean"/>
 44
 45   <!-- here is Camel configured with a number of routes -->
 46   <camelContext xmlns=3D"http://camel.apache.org/schema/spring">
 47      <!-- use Camel property placeholder loaded from the given file -->
 48      <propertyPlaceholder id=3D"placeholder" location=3D"classpath:sql.=
properties"/>
 49
 50     <!-- ofbiz remote deispatcher -->
 51     <proxy id=3D"remoteDispatcher" serviceInterface=3D"org.ofbiz.servic=
e.rmi.RemoteDispatcher" serviceUrl=3D"direct:ofbiz"/>
 52
 53     <route id=3D"encoderCategory-route">
 54       <!-- =E4=BB=85=E8=BF=90=E8=A1=8C=E4=B8=80=E6=AC=A1-->
 55       <from uri=3D"timer://foo?repeatCount=3D1"/>
 56       <to uri=3D"sql:{{sql.selectCategory}}?outputClass=3Dcom.ofbizian.=
CategoryBean"/>
 57       <log message=3D"${in.body.mainid} :: ${in.body.typename} :: ${in.=
body.typeparent}"/>
 58       <setHeader headerName=3D"Ofbiz.ServiceName">
 59         <constant>createEncoderCategory</constant>
 60       </setHeader>
 61       <setHeader headerName=3D"Ofbiz.Param.productCategoryId">
 62         <simple>${in.body.mainid}</simple>
 63       </setHeader>
 64       <setHeader headerName=3D"Ofbiz.Param.categoryName">
 65         <simple>${in.body.typename}</simple>
 66       </setHeader>
 67       <setHeader headerName=3D"Ofbiz.Param.parentProductCategoryId">
 68         <simple>${in.body.typeparent}</simple>
 69       </setHeader>
 70       <setHeader headerName=3D"Ofbiz.Param.primaryParentCategoryId">
 71         <simple>${in.body.typeparent}</simple>
 72       </setHeader>
 73       <setHeader headerName=3D"Ofbiz.Param.productCategoryTypeId">
 74         <constant>CATALOG_CATEGORY</constant>
 75       </setHeader>
 76       <process ref=3D"ofbizDispatcher"/>
 77     </route>
 78     <route>
 79       <from uri=3D"direct:ofbiz"/>
 80       <to uri=3D"rmi://192.168.36.20:1099/RMIDispatcher"/>
 81       <log message=3D"ofbiz create note:${body}"/>
 82     </route>
 83     <!-- END SNIPPET: e2 -->
 84 </camelContext>
 85 </beans>
---------------------------------------------------------------------------=
----
CategoryBean.java
  1 package com.ofbizian;
  2
  3 public class CategoryBean{
  4 private String mainid;
  5 private String typename;
  6 private String typeparent;
  7 private String typecategory;
  8
  9 public String getMainid(){
 10   return mainid;
 11 }
 12
 13 public void setMainid(String mainid){
 14   this.mainid=3Dmainid;
 15 }
 16
 17 public String getTypename(){
 18   return typename;
 19 }
 20
 21 public void setTypename(String typename){
 22   this.typename=3Dtypename;
 23 }
 24
 25 public String getTypeparent(){
 26   return typeparent;
 27 }
 28
 29 public void setTypeparent(String typeparent){
 30   this.typeparent=3Dtypeparent;
 31 }
 32
 33 public String getTypecategory(){
 34   return typecategory;
 35 }
 36
 37 public void setTypecategory(){
 38   this.typecategory=3Dtypecategory;
 39 }
 40 }
                                                     =20





Message History
---------------------------------------------------------------------------=
------------------------------------------------------------
RouteId              ProcessorId          Processor                        =
                                                Elapsed (ms)
[encoderCategory-ro] [encoderCategory-ro] [timer://foo?repeatCount=3D1     =
                                                ] [      1256]
[encoderCategory-ro] [to1               ] [sql:select MAINID,TYPENAME,TYPEP=
ARENT,TYPECATEGORY  from spg_material_type whe] [      1162]
[encoderCategory-ro] [log1              ] [log                             =
                                              ] [        81]

Exchange
---------------------------------------------------------------------------=
------------------------------------------------------------
Exchange[
        Id                  ID-localhost-localdomain-59312-1432288083959-0-=
2
        ExchangePattern     InOnly
        Headers             {breadcrumbId=3DID-localhost-localdomain-59312-=
1432288083959-0-1, CamelRedelivered=3Dfalse, CamelRedeliveryCounter=3D0, Ca=
melSqlRowCount=3D16, firedTime=3DFri May 22 17:48:06 CST 2015}
        BodyType            java.util.ArrayList
        Body                [com.ofbizian.CategoryBean@bbf16e, com.ofbizian=
.CategoryBean@e79a45, com.ofbizian.CategoryBean@14135cf, com.ofbizian.Categ=
oryBean@33d7d7, com.ofbizian.CategoryBean@19f6fa4, com.ofbizian.CategoryBea=
n@5a8b48, com.ofbizian.CategoryBean@6e273a, com.ofbizian.CategoryBean@1d162=
7e, com.ofbizian.CategoryBean@1997685, com.ofbizian.CategoryBean@343d90, co=
m.ofbizian.CategoryBean@1b5c453, com.ofbizian.CategoryBean@6c45d2, com.ofbi=
zian.CategoryBean@5bf9e7, com.ofbizian.CategoryBean@73ed80, com.ofbizian.Ca=
tegoryBean@ed93a9, com.ofbizian.CategoryBean@179565e]
]

Stacktrace
---------------------------------------------------------------------------=
------------------------------------------------------------
org.apache.camel.language.bean.RuntimeBeanExpressionException: Failed to in=
voke method: .mainid on null due to: org.apache.camel.language.bean.Runtime=
BeanExpressionException: Failed to invoke method: mainid on null due to: or=
g.apache.camel.component.bean.MethodNotFoundException: Method with name: ma=
inid not found on bean: [com.ofbizian.CategoryBean@bbf16e, com.ofbizian.Cat=
egoryBean@e79a45, com.ofbizian.CategoryBean@14135cf, com.ofbizian.CategoryB=
ean@33d7d7, com.ofbizian.CategoryBean@19f6fa4, com.ofbizian.CategoryBean@5a=
8b48, com.ofbizian.CategoryBean@6e273a, com.ofbizian.CategoryBean@1d1627e, =
com.ofbizian.CategoryBean@1997685, com.ofbizian.CategoryBean@343d90, com.of=
bizian.CategoryBean@1b5c453, com.ofbizian.CategoryBean@6c45d2, com.ofbizian=
.CategoryBean@5bf9e7, com.ofbizian.CategoryBean@73ed80, com.ofbizian.Catego=
ryBean@ed93a9, com.ofbizian.CategoryBean@179565e] of type: java.util.ArrayL=
ist. Exchange[Message: [com.ofbizian.CategoryBean@bbf16e, com.ofbizian.Cate=
goryBean@e79a45, com.ofbizian.CategoryBean@14135cf, com.ofbizian.CategoryBe=
an@33d7d7, com.ofbizian.CategoryBean@19f6fa4, com.ofbizian.CategoryBean@5a8=
b48, com.ofbizian.CategoryBean@6e273a, com.ofbizian.CategoryBean@1d1627e, c=
om.ofbizian.CategoryBean@1997685, com.ofbizian.CategoryBean@343d90, com.ofb=
izian.CategoryBean@1b5c453, com.ofbizian.CategoryBean@6c45d2, com.ofbizian.=
CategoryBean@5bf9e7, com.ofbizian.CategoryBean@73ed80, com.ofbizian.Categor=
yBean@ed93a9, com.ofbizian.CategoryBean@179565e]]
        at org.apache.camel.language.bean.BeanExpression.evaluate(BeanExpre=
ssion.java:117)



> org.apache.camel.language.bean.RuntimeBeanExpressionException: Failed to =
invoke method:=20
> -------------------------------------------------------------------------=
---------------
>
>                 Key: CAMEL-8792
>                 URL: https://issues.apache.org/jira/browse/CAMEL-8792
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-core, camel-sql
>    Affects Versions: 2.15.2
>         Environment: windows7 jdk1.7
>            Reporter: =E9=BB=84=E9=A2=9C=E6=9C=A8
>
> 1. when just use sqlComponents ,its okay.=20
> 2. I try to just run the sql one times,so add timer//foo?repeatCount=3D1
> error happend. =20
> my code goes here:
> -------------------------------------------------------------------------=
---
> ...
>  42
>  43   <bean id=3D"categoryBean" class=3D"com.ofbizian.CategoryBean"/>
>  44
> ...
>  53     <route id=3D"encoderCategory-route">
>  54       <!-- =E4=BB=85=E8=BF=90=E8=A1=8C=E4=B8=80=E6=AC=A1-->
>  55       <from uri=3D"timer://foo?repeatCount=3D1"/>
>  56       <to uri=3D"sql:{{sql.selectCategory}}?outputClass=3Dcom.ofbizia=
n.CategoryBean"/>
> ...
> =20
> -------------------------------------------------------------------------=
------
> CategoryBean.java
>   1 package com.ofbizian;
>   2
>   3 public class CategoryBean{
>   4 private String mainid;
> ...
>   8
>   9 public String getMainid(){
>  10   return mainid;
>  11 }
>  12
>  13 public void setMainid(String mainid){
>  14   this.mainid=3Dmainid;
>  15 }
>  16
>  ...
>  40 }
>     =20



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)