- PreparedStatement ps = null;\r
- try {\r
- DB db = new DB();\r
- @SuppressWarnings("resource")\r
- Connection conn = db.getConnection();\r
- ps = conn.prepareStatement("insert into NODES (NODEID, NAME, ACTIVE) values (?, ?, 1)");\r
- ps.setInt(1, nextid);\r
- ps.setString(2, node);\r
- ps.execute();\r
- ps.close();\r
- db.release(conn);\r
- } catch (SQLException e) {\r
- intLogger.error("PROV0005 doInsert: " + e.getMessage(),e);\r
- } finally {\r
- try {\r
- if(ps!=null){\r
- ps.close();\r
- }\r
- } catch (SQLException e) {\r
- intLogger.error("Error in closing PreparedStatement: " + e.getMessage(),e);\r
- }\r
- }\r