I am using JDBC connection to execute the VQL commands from my application. Let's say I want to create a role or modify the description of the role using 'Create /Alter command query' as shown in example below
Create role testrole; -- Creating new testrole in Denodo
Alter role "testrole" 'description of testrole'; -- Updating the description of the testrole.
When I read the response using JDBC executeUpdate() routine. I receive the response message as 0 rows affected and role is getting created/updated succesfully in Denodo.
Ideally I would expect the VQL response message either "Role create succesfully" or "Role modified sucessfuly" as it does when we execute this VQL command in Denodo Tools => VQL Shell.
But when we connect Denodo using JDBC connection and execute the vql queries, response returns as '0' rows affected. Do we have any concrete way to identify success/failure case to execute VQL command metadata information and it returns correct response like "Role create succesfully" or "Role modified sucessfuly" ?
Thanks in Advance.