'VertX SQLtemplate forQuery() method is returning null even after I specified a return statement in the SQL query
My program is supposed to batch insert a lot of unique account ID, and other customer properties, from a CSV file. Sometimes these account IDs are mistakenly duplicated, so I am trying to handle that by using the ON CONFLICT statement in postgreSQL. The problem I am having is that that after I specify the value the SQL query should return, which is the conflicting ID, there is no way to access it because I think the forQuery method in the vertx sql query template returns null. Code attached as photograph please help.image of vertx sql template code and sql statement
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|