Roller DataSource test

<%-- simple test page to test your Roller datasource setup --%> <%@ page import="javax.naming.InitialContext" %> <%@ page import="javax.sql.DataSource" %> <%@ page import="java.sql.Connection" %> Roller DataSource test

<% String msg = null; Connection con = null; try { InitialContext ic = new InitialContext(); DataSource ds = (DataSource)ic.lookup("java:comp/env/jdbc/rollerdb"); con = ds.getConnection(); msg = "SUCCESS: Got datasource and connection, class is "+ds.getClass().getName(); } catch (Exception e) { msg = "FAILURE: exception thrown "+e.getClass().getName(); e.printStackTrace( new java.io.PrintWriter(out) ); } finally { if (con != null) con.close(); } %> <%= msg %>