Hi, @Etienne many thanks for your link, I will read it later.
@Julian can you give us a link to help me understand that? Hi @Willem Jiang (the IoTDB mentor and the Camel committer), how do you think about that? Best. ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Robinet, Etienne <[email protected]> 于2020年3月3日周二 下午10:25写道： > Hi Julian, > you're thinking about creating a Camel component? > > Le mar. 3 mars 2020 à 15:24, Julian Feinauer <[email protected] > > > 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" <[email protected]>: > > > > 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 <[email protected]> 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 <[email protected]> 于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" <[email protected]> > > > > > 发送时间: 2020-03-03 20:55:43 (星期二) > > > > > 收件人: [email protected] > > > > > 抄送: > > > > > 主题: Re: Prepared Statements/ Commit > > > > > > > > > > Hi, > > > > > Can I use this session API in combination with camel? > > > > > > > > > > Le mar. 3 mars 2020 à 13:54, Jialin Qiao < > > [email protected]> > > > 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" <[email protected]> > > > > > > > 发送时间: 2020-03-03 20:35:56 (星期二) > > > > > > > 收件人: [email protected] > > > > > > > 抄送: > > > > > > > 主题: 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 > > > > > > > > > > > > > > > > > > > >
