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
> > > >
> >
>
