On Sunday, June 10, 2018, Chuck Davis <
cjgunzel@gmail.com> wrote:
try {
result = stat.execute("select exists (select 1 from
information_schema.tables where table_name = 'entities')");
System.out.println("the checkEntity returned a result of "
+ result);
} catch (SQLException ex) {
Logger.getLogger(ClientConstants.class.getName()).log(Level.SEVERE,
null, ex);
result = false;
return result;
}
Your query is putting "false" into cell (0,0) of a ResultSet. You are failing to even look at the resultset to see if it holds a true or false.
The query should never fail since you aren't using the table name directly but are checking for it as a value in another table that always exists. The inner query returns zero records when the table doesn't exist and the EXISTS construct converts that to false.
David J.
