Realtime insert/update operation with JDBC on roxie

[adityac]

Hi Team,

After research I came to know that HPCC can process million of data in real time with less time. I am trying to evaluate a process to do real time data insert or modify with jdbc driver in java. But no luck to crack for real time data writing using jdbc driver. I did it for read/select operation and it works.

Can any one please help here to workout.

We are working with JDBC driver to fetch data from logical file in java.

Below are snap from our code-

String sqlQuery ="select * from tutorial::yn::transactions";
org.hpccsystems.ws.client.utils.Connection connection = new Connection("http://localhost:8510");
HPCCWsSQLClient mywssqlclient = HPCCWsSQLClient.get(connection);
System.out.println(mywssqlclient.getResults(mywssqlclient.executeSQLWUIDResponse(sqlQuery, "roxie", ""), 0, 50));

Till now we are ok with fetching data from file but we have real time requirement of INSERT/UPDATE operations on existing data of file.

Can someone please suggest us that we can support realtime INSERT/UPDATE operation on logical file?
If yes then how can we fulfill our requirements?