/** Creates a Pooled connection and adds it to the connection pool. */ private void installConnection() throws EmanagerDatabaseException { logger.debug("enter"); PooledConnection connection; try { connection = poolDataSource.getPooledConnection(); connection.addConnectionEventListener(this); connection.getConnection().setAutoCommit(false); synchronized (connectionPool) { connectionPool.add(connection); logger.debug("Database connection added."); } } catch (SQLException ex) { logger.fatal("exception caught while obtaining database " + "connection: ex = " + ex); SQLException ex1 = ex.getNextException(); while (ex1 != null) { logger.fatal("chained sql exception ex1 = " + ex1); SQLException nextEx = ex1.getNextException(); ex1 = nextEx; } String logString; EmanagerDatabaseException ede; logString = EmanagerDatabaseStatusCode.DatabaseConnectionFailure.getStatusCodeDescription() + ex.getMessage(); logger.fatal(logString); ede = new EmanagerDatabaseException( EmanagerDatabaseStatusCode.DatabaseConnectionFailure, logString); throw ede; } }
protected boolean insertComment() throws SQLException { try { String dburl = getServletContext().getInitParameter("DBUrl"); String dbuser = getServletContext().getInitParameter("DBUser"); String dbpasswd = getServletContext().getInitParameter("DBPasswd"); Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection(dburl, dbuser, dbpasswd); String sqlqry = "INSERT INTO feedback (name, email, feedback) VALUES (?,?,?)"; pstmt = conn.prepareStatement(sqlqry); pstmt.setString(1, name); pstmt.setString(2, email); pstmt.setString(3, comment); if (pstmt.executeUpdate() > 0) return true; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block logger.error(e); e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block logger.error(e); e.printStackTrace(); } finally { conn.close(); pstmt.close(); } return false; }
protected void processData(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, SQLException { try { String dispatchUrl = "/feedback.jsp"; name = request.getParameter("txtName"); email = request.getParameter("txtEmail"); comment = request.getParameter("txtComment"); if (!insertComment()) { logger.error("Error. Could not insert comment"); request.setAttribute("status", "fail"); } else { request.setAttribute("status", "success"); } RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(dispatchUrl); dispatcher.include(request, response); } catch (SQLException e) { // TODO Auto-generated catch block logger.error(e); e.printStackTrace(); } finally { conn.close(); pstmt.close(); } }
/** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub try { processData(request, response); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }
/** * Gets the ConnectionID attribute of the SybaseConnector class * * @param connection * @return The ConnectionID value */ public static long getConnectionID(Connection connection) { try { Statement stmt = connection.createStatement(); ResultSet res = stmt.executeQuery("select connection_property('Number')"); res.next(); return res.getLong(1); } catch (SQLException ex) { logger.error("SQL exception retrieving connection ID:" + ex.getMessage()); } return InvalidConnectionId; }
/** * @return Connection * @roseuid 3F3A5FFD0338 */ public Connection getConnection() throws EmanagerDatabaseException { long connectionId; Connection connection; PooledConnection pooledConnection; connection = null; pooledConnection = null; connectionId = InvalidConnectionId; try { synchronized (connectionPool) { if (!connectionPool.isEmpty()) { try { boolean connectionClosed; connectionClosed = false; pooledConnection = (PooledConnection) connectionPool.remove(0); connection = pooledConnection.getConnection(); connection.clearWarnings(); connectionId = getConnectionID(connection); connectionClosed = connection.isClosed(); if (connectionId == InvalidConnectionId || connectionClosed == true) { logger.debug("Pooled connection closed."); connection = null; } } catch (SQLException sqe) { logger.debug("Pooled connection closed."); connection = null; } } } if (connection == null) { logger.debug("Getting a new connection."); pooledConnection = poolDataSource.getPooledConnection(); pooledConnection.addConnectionEventListener(this); connection = pooledConnection.getConnection(); connection.clearWarnings(); connectionId = getConnectionID(connection); } } catch (SQLException sqe) { String logString; EmanagerDatabaseException ede; logString = EmanagerDatabaseStatusCode.UnableToGetPooledConnection.getStatusCodeDescription() + sqe.getMessage(); logger.error(logString); ede = new EmanagerDatabaseException( EmanagerDatabaseStatusCode.UnableToGetPooledConnection, logString); throw ede; } if (connectionId == InvalidConnectionId) { EmanagerDatabaseException ede; ede = new EmanagerDatabaseException( EmanagerDatabaseStatusCode.UnableToGetPooledConnection, EmanagerDatabaseStatusCode.UnableToGetPooledConnection.getStatusCodeDescription()); throw ede; } logger.debug( "\n*****************************" + "\nPooled Connection Init" + "\nCon ID:" + connectionId + "\nCon Object:" + pooledConnection + "\nPool Object:" + connection + "\n*****************************"); return connection; }