AnsweredAssumed Answered

Efficiently insert data through JDBC

Question asked by chantry on Sep 27, 2016
Latest reply on Sep 27, 2016 by pmartin



I am currently looking to replace the UFL Loader with a daemon that implements the JDBC driver. I have made connection and done simple queries in both DbVisualizer and through my Java program. I have little experience with PI, so the next step is to make sense of all the different tables. From the documentation I gather that I can insert into the `picomp2` table.


I have a few questions.

  1. If I look at picomp and picomp2, picomp has value, svalue, and status columns, whereas picomp2 has _index, value, and status columns. What is the purpose of each of these columns and how do they relate?
  2. My current plan is to build insert statements that act on the picomp2 table. Is this the most efficient way of inserting large amounts of data?
  3. How do I handle inserting datapoints that have different datatypes. Our current possible types in Java are String, Float, and Integer, but this may change.