On Apr 2, 2013, at 11:37 AM, [email protected] 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 <[email protected]>
> To: Tomcat Users List <[email protected]>
> 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: [email protected]
For additional commands, e-mail: [email protected]
