Neven, After fixing the case sensitive properties in my context.xml resource element per Konstantin that error disappeared from the catalina.out log. I now get this error when trying to navigate through the site. Note. Some of the pages sometimes load but without the data driven elements and others just display this error. I don't get anything in Catalina.out except messages like these. HOME >> reinitializing data ABOUT US >> reinitializing data
I'm looking at the Tomcat docs to see if maybe I need to up the logging level to get a more descriptive error of what is happening here. type Exception report message Servlet execution threw an exception description The server encountered an internal error that prevented it from fulfilling this request. exception javax.servlet.ServletException: Servlet execution threw an exception root cause java.lang.NoClassDefFoundError: Could not initialize class com.systemsmadesimple.hibernate.HibernateUtil com.systemsmadesimple.hibernate.DatabaseManager.getAdHocData(DatabaseManager.java:171) com.systemsmadesimple.struts.action.ServicesAction.execute(ServicesAction.java:48) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) I tried to use your test app but kept getting some error messages back like these. I don't know if I missed something when creating the .jsp file or if there is just some missing code. org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 8 in the jsp file: /test.jsp javax.sql.Connection cannot be resolved to a type 5: <pre> 6: <% 7: javax.naming.InitialContext naming = null; 8: javax.sql.Connection connection = null; 9: try { 10: naming = new javax.naming.InitialContext(); 11: datasource = (DataSource)naming.lookup("java:comp/env/jdbc/smswebdb"); An error occurred at line: 11 in the jsp file: /test.jsp datasource cannot be resolved to a variable 8: javax.sql.Connection connection = null; 9: try { 10: naming = new javax.naming.InitialContext(); 11: datasource = (DataSource)naming.lookup("java:comp/env/jdbc/smswebdb"); 12: connection = datasource.getConnection(); 13: connection.close(); 14: out.println("Connection has successfully obtained from datasource.connection=" + connection); An error occurred at line: 11 in the jsp file: /test.jsp DataSource cannot be resolved to a type 8: javax.sql.Connection connection = null; 9: try { 10: naming = new javax.naming.InitialContext(); 11: datasource = (DataSource)naming.lookup("java:comp/env/jdbc/smswebdb"); 12: connection = datasource.getConnection(); 13: connection.close(); 14: out.println("Connection has successfully obtained from datasource.connection=" + connection); An error occurred at line: 12 in the jsp file: /test.jsp datasource cannot be resolved 9: try { 10: naming = new javax.naming.InitialContext(); 11: datasource = (DataSource)naming.lookup("java:comp/env/jdbc/smswebdb"); 12: connection = datasource.getConnection(); 13: connection.close(); 14: out.println("Connection has successfully obtained from datasource.connection=" + connection); 15: } catch (javax.naming.NamingException ne) { An error occurred at line: 18 in the jsp file: /test.jsp javax.sql.SQLException cannot be resolved to a type 15: } catch (javax.naming.NamingException ne) { 16: ne.printStackTrace(); 17: out.println("Datasource is not bound to JNDI: " + ne); 18: } catch (javax.sql.SQLException sqle) { 19: sqle.printStackTrace(); 20: out.println("Problem with a SQL connection: " + sqle); 21: } catch (Exception e) { Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:103) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:331) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:468) org.apache.jasper.compiler.Compiler.compile(Compiler.java:378) org.apache.jasper.compiler.Compiler.compile(Compiler.java:353) org.apache.jasper.compiler.Compiler.compile(Compiler.java:340) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:646) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:357) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.37 logs. Apache Tomcat/7.0.37 Thank You for any help you or anyone else can provide. David -----Original Message----- From: Neven Cvetkovic <neven.cvetko...@gmail.com> To: Tomcat Users List <users@tomcat.apache.org> Sent: Mon, Apr 1, 2013 8:23 pm Subject: Re: Trouble loading MS SQl Server database driver in Tomcat 7.0.37 Excellent point Mark. David, you have to decide how your database connections are managed: