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

Reply via email to