Hi Claus, Thank you for the advice, I will make a try and feedback later
On Fri, May 3, 2013 at 1:26 PM, Claus Ibsen <claus.ib...@gmail.com> wrote: > Hi > > You have to check the logs to see what goes on. And also make sure the > SQL query is not returning very big data as then it takes a long time. > > And you can also look on the Oracle side what goes on, if it has > received the SQL and is executing it etc. > > On Thu, May 2, 2013 at 11:07 AM, 黄骞 <huangq...@supermap.com> wrote: > > Hi, > > > > Thank you very much for the suggestion! I think I missed some code in my > > first letter. > > > > The real code is > > > > <route> > > <from uri="jms:queue:FEATURES.JSON"/> > > <setBody> > > <constant>select * from GEO_FEATURE</constant> > > </setBody> > > <log message = "start db"/> > > <to uri="jdbc:dataSource"/> > > <log message = "stop db"/> > > <to uri="jms:queue:FEATURES.JSON3"/> > > </route> > > > > However, I can get the "start db" log, but cannot get "stop db" log. > > > > Can you give me some further suggestin? > > > > > > Thank you ! > > > > > > 黄骞/Huang Qian > > 超图分布式地理信息研究室主任/ Director of SuperMap Distributed GIS Lab > > 超图GIS研究所高级研究员/ Senior Researcher at SuperMap GIS Institute > > 地址：北京市朝阳区酒仙桥北路甲10号电子城IT产业园201楼E门4层，100015 > > Add: 4/F Unit E, Building 201, No. A10, Jiuxianqiaobei Road, Chaoyang > > District, Beijing, 100015, CHINA > > 电话/Tel：+86-10- 010-59896522 > > 传真/Fax：+86-10-59896666 > > 手机/Mobile：15901268883 > > 电子邮件/Mail: huangq...@supermap.com > > 网址/Website: http://www.supermap.com.cn > > > > > > On Thu, May 2, 2013 at 4:27 PM, Claus Ibsen <claus.ib...@gmail.com> > wrote: > >> > >> Hi > >> > >> You need to the route to start with a <from> > >> > >> <route> > >> <from uri="timer:foo?period=5000"/> > >> <setBody> > >> <constant>select * from GEO_FEATURE</constant> > >> </setBody> > >> <to uri="jdbc:dataSource"/> > >> <to uri="log:response"/> > >> </route> > >> > >> eg you can also see this by the examples on the jdbc doc page > >> http://camel.apache.org/jdbc > >> > >> > >> On Thu, May 2, 2013 at 10:20 AM, skysw...@gmail.com <skysw...@gmail.com > > > >> wrote: > >> > Hi everyone, > >> > > >> > I want to do some search in Oracle 11g with the following xml. > >> > > >> > <bean id="dataSource" > >> > class="org.springframework.jdbc.datasource.DriverManagerDataSource"> > >> > <property name="driverClassName" > >> > value="oracle.jdbc.driver.OracleDriver"/> > >> > <property name="url" value="jdbc:oracle:thin:@ip:port:dbname" /> > >> > <property name="username" value="xxx" /> > >> > <property name="password" value="xxx" /> > >> > </bean> > >> > > >> > <route> > >> > <setBody> > >> > <constant>select * from GEO_FEATURE</constant> > >> > </setBody> > >> > <to uri="jdbc:dataSource"/> > >> > </route> > >> > > >> > However I got response and no error log, is there any possible reason > >> > or > >> > some suggested debug method for me? > >> > > >> > Thanks a lot! > >> > >> > >> > >> -- > >> Claus Ibsen > >> ----------------- > >> Red Hat, Inc. > >> FuseSource is now part of Red Hat > >> Email: cib...@redhat.com > >> Web: http://fusesource.com > >> Twitter: davsclaus > >> Blog: http://davsclaus.com > >> Author of Camel in Action: http://www.manning.com/ibsen > > > > > > > > -- > Claus Ibsen > ----------------- > Red Hat, Inc. > FuseSource is now part of Red Hat > Email: cib...@redhat.com > Web: http://fusesource.com > Twitter: davsclaus > Blog: http://davsclaus.com > Author of Camel in Action: http://www.manning.com/ibsen >
