On Apr 2, 2013, at 11:37 AM, dvosbu...@aol.com wrote: > 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)
Seems like this class "com.systemsmadesimple.hibernate.HibernateUtil" cannot be found? Where do you have it deployed? > > 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) { > These are all programming errors. For example, it's "java.sql.Connection", not "javax". http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html This is not an issue with Tomcat, you just need to correct the code. Dan > > 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: > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org