Yes, why not? This should not be too hard to do... Camels API is quite friendly.

What do you think?

Julian

Am 03.03.20, 15:25 schrieb "Robinet, Etienne" <43...@etu.he2b.be>:

    Hi Julian,
    you're thinking about creating a Camel component?
    
    Le mar. 3 mars 2020 à 15:24, Julian Feinauer <j.feina...@pragmaticminds.de>
    a écrit :
    
    > Hi,
    >
    > another alternative would be to add a "native" IoTDB Integration like .e.g
    > we did in PLC4X. Its not that hard and should be easy for the IoTDB
    > community.
    >
    > What about that?
    >
    > Julian
    >
    > Am 03.03.20, 14:35 schrieb "Robinet, Etienne" <43...@etu.he2b.be>:
    >
    >     Hi,
    >     sadly I am pretty new at using camel and never worked with NoSQL DB
    > but I
    >     found this:
    >
    > https://rterp.wordpress.com/2014/07/25/writing-to-a-nosql-db-using-camel/
    >
    >      Also, here is a blueprint I used with Oracle DB:
    >     <?xml version="1.0" encoding="UTF-8"?>
    >     <blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0";
    >                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
    >                xmlns:cm="
    >     http://aries.apache.org/blueprint/xmlns/blueprint-cm/v1.1.0";
    >                xsi:schemaLocation="
    >              http://www.osgi.org/xmlns/blueprint/v1.0.0
    >     https://www.osgi.org/xmlns/blueprint/v1.0.0/blueprint.xsd
    >              http://camel.apache.org/schema/blueprint
    >     http://camel.apache.org/schema/blueprint/camel-blueprint.xsd
    >              http://aries.apache.org/blueprint/xmlns/blueprint-cm/v1.1.0
    >     http://aries.apache.org/schemas/blueprint-cm/blueprint-cm-1.1.0.xsd";>
    >
    >
    >     <camelContext id="TestContext" xmlns="
    >     http://camel.apache.org/schema/blueprint";>
    >
    >     <route id="Route1">
    >
    >     <from uri="file://c:/test/in?delete=true"/>
    >     <setBody><simple>Route1 :: ${body}</simple></setBody>
    >           <to uri="sql:insert into test1_t(text)
    >     values(:#${body})?dataSource=my-db"/>
    >     </route>
    >
    >     </camelContext>
    >
    >
    >     <!-- The container provides a DataSource service connected to the
    > database
    >     -->
    >     <reference id="my-db" interface="javax.sql.DataSource" filter="(
    >     osgi.jndi.service.name=testDB)"/>
    >
    >
    >     </blueprint>
    >
    >     Le mar. 3 mars 2020 à 14:09, Xiangdong Huang <saint...@gmail.com> a
    > écrit :
    >
    >     > Hi Etienne,
    >     >
    >     > Can you share an example for integration Camel with some other DB
    > (NoSQL is
    >     > better)?
    >     > It will be helpful to let us evaluate how to integrate with IoTDB.
    >     >
    >     > Best,
    >     > ----------------------------------
    >     > Xiangdong Huang
    >     > School of Software, Tsinghua University
    >     >
    >     >  黄向东
    >     > 清华大学 软件学院
    >     >
    >     >
    >     > Jialin Qiao <qj...@mails.tsinghua.edu.cn> 于2020年3月3日周二 下午9:04写道:
    >     >
    >     > > Hi,
    >     > >
    >     > > If you only need a java api, the Session API is enough and better
    > than
    >     > > JDBC.
    >     > >
    >     > > There is an example about Session API:
    >     > >
    >     > >
    >     >
    > 
https://github.com/apache/incubator-iotdb/blob/master/example/session/src/main/java/org/apache/iotdb/SessionExample.java
    >     > >
    >     > > I'm not familiar with Camel, but when integrating with rocketmq or
    > kafka,
    >     > > the consumer could use Session API to write data into IoTDB.
    >     > >
    >     > > Thanks,
    >     > > --
    >     > > Jialin Qiao
    >     > > School of Software, Tsinghua University
    >     > >
    >     > > 乔嘉林
    >     > > 清华大学 软件学院
    >     > >
    >     > > > -----原始邮件-----
    >     > > > 发件人: "Robinet, Etienne" <43...@etu.he2b.be>
    >     > > > 发送时间: 2020-03-03 20:55:43 (星期二)
    >     > > > 收件人: dev@iotdb.apache.org
    >     > > > 抄送:
    >     > > > 主题: Re: Prepared Statements/ Commit
    >     > > >
    >     > > > Hi,
    >     > > > Can I use this session API in combination with camel?
    >     > > >
    >     > > > Le mar. 3 mars 2020 à 13:54, Jialin Qiao <
    > qj...@mails.tsinghua.edu.cn>
    >     > a
    >     > > > écrit :
    >     > > >
    >     > > > > Hi,
    >     > > > >
    >     > > > > PreparedStatement is not supported now. Instead, you could use
    >     > Session
    >     > > > > API, which also avoids the sql parser.
    >     > > > >
    >     > > > > Thanks,
    >     > > > > --
    >     > > > > Jialin Qiao
    >     > > > > School of Software, Tsinghua University
    >     > > > >
    >     > > > > 乔嘉林
    >     > > > > 清华大学 软件学院
    >     > > > >
    >     > > > > > -----原始邮件-----
    >     > > > > > 发件人: "Etienne Robinet" <43...@etu.he2b.be>
    >     > > > > > 发送时间: 2020-03-03 20:35:56 (星期二)
    >     > > > > > 收件人: dev@iotdb.apache.org
    >     > > > > > 抄送:
    >     > > > > > 主题: Prepared Statements/ Commit
    >     > > > > >
    >     > > > > > Hi all,
    >     > > > > > could it be that IoTDB doesn't support prepared statements?
    > When I
    >     > > try
    >     > > > > to use the SQL component of Camel, this is the error I get:
    >     > > > > https://i.imgur.com/HOJgh0H.png
    >     > > > > >
    >     > > > > > when I use JDBC component I get an error message "Not 
support
    >     > > Commit". I
    >     > > > > am confused now on how to use camel with IoTDB.
    >     > > > > > Etienne
    >     > > > >
    >     > >
    >     >
    >
    >
    >
    

Reply via email to