protected boolean createTable(String name, Map<String, Class<?>> types) { String create = dialect.getCreateTableCommand(name, types); log.debug("Trying to create table '{}':\n{}", name, create); try { Connection con = openConnection(); Statement stmt = con.createStatement(); log.debug("Running create: {}", create); int rc = stmt.executeUpdate(create); log.debug("create returned: {}", rc); stmt.close(); con.close(); return true; } catch (Exception e) { e.printStackTrace(); return false; } }
protected boolean createTable(String name, Map<String, Class<?>> types) { String create = dialect.getCreateTableCommand(name, types); log.debug("Trying to create table '{}':\n{}", name, create); try { Connection con = openConnection(); Statement stmt = con.createStatement(); log.debug("Running create: {}", create); int rc = stmt.executeUpdate(create); log.debug("create returned: {}", rc); stmt.close(); con.close(); return true; } catch (Exception e) { e.printStackTrace(); return false; } }
protected boolean createTable(String name, Map<String, Class<?>> types) { String create = dialect.getCreateTableCommand(name, types); log.debug("Trying to create table '{}':\n{}", name, create); try { Connection con = openConnection(); Statement stmt = con.createStatement(); log.debug("Running create: {}", create); int rc = stmt.executeUpdate(create); log.debug("create returned: {}", rc); stmt.close(); con.close(); return true; } catch (Exception e) { e.printStackTrace(); return false; } }
protected boolean hasTable(String name) { Statement stmt = null; boolean tableExists = false; Connection con = null; try { con = openConnection(); stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM " + name); if (rs.next()) { tableExists = true; } rs.close(); } catch (Exception e) { log.error("Error: {}", e.getMessage()); } finally { try { stmt.close(); } catch (Exception e) { } } close(con); return tableExists; } }
protected boolean hasTable(String name) { Statement stmt = null; boolean tableExists = false; Connection con = null; try { con = openConnection(); stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM " + name); if (rs.next()) { tableExists = true; } rs.close(); } catch (Exception e) { log.error("Error: {}", e.getMessage()); } finally { try { stmt.close(); } catch (Exception e) { } } close(con); return tableExists; } }
protected boolean hasTable(String name) { Statement stmt = null; boolean tableExists = false; Connection con = null; try { con = openConnection(); stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM " + name); if (rs.next()) { tableExists = true; } rs.close(); } catch (Exception e) { log.error("Error: {}", e.getMessage()); } finally { try { stmt.close(); } catch (Exception e) { } } close(con); return tableExists; } }