Java interfaces (newbie)

Community Support
1

I’m just starting to try out Kdb+ and I’m trying to access it from
Java. I see that there is a “c” and a JDBC
interface. From reading it seems that the “c” is preferred. Is that
true? I didn’t see any real examples
of using the “c” interface. How would I do something simple like:

PreparedStatement ps = c.prepareStatement(“insert into t
values(?,?)”; // I know it should be in q
ps.setDouble(1,1.0);
ps.setDouble(2,5.0);
ps.execute();

How is the binding operation handled in the “c” interface? Does Kdb+
even have the concept?
Thanks in advance.

Barry

2

You can simulate prepared statements with lambdas, but it’s not really going to save you anything. Unless you filter the data kdb+ will return as much as you ask for. The recommendation is to do all of the work on the server itself and return a small result set. Obviously, if you need to do further enrichment you return what you need to, but just use caution.