-----Original Message-----
From: George Chatzigeorgiou [mailto:bandit76@c...]
Sent: 25 June 2000 16:21
To: support@w...
Subject: PROFESSIONAL JSP 3625


I really need help!!!

First if i enter the line include c:\...........\tomcat-apache.conf 
then the apache server won't start , throwing an err message "alias takes 
two arquments, a fakename and a real name"

if i use the tomcat.conf file everything seems to be ok. 

I install the jdbc mySQL driver(using mysql_comp.jar. I searched the entire 
site and i could nowhere find a mysql_2_comp.jar).

I install the pooling driver and here is the best part. When i try to 
execute dbqueryP.jsp the tomcat servers shutsdown and i get i server not
found error.

Do i have to run both tomcat and apache???

Tomcat.log contains the following...

Context log: path="wroxjdbc" File not found C:\Program Files\Apache 
Group\jakarta-tomcat\wroxjdbc\WEB-INF\web.xml, using only defaults
Starting endpoint port="8080" 
handler="org.apache.tomcat.service.http.HttpConnectionHandler"
Starting endpoint port="8007" 
handler="org.apache.tomcat.service.connector.Ajp12ConnectionHandler"
Context log: path="/projsp" Error in jsp service() : Unable to compile 
class for JSPC:\Program Files\Apache 
Group\jakarta-tomcat\work\localhost_8080%2Fprojsp\_0002fch_00030_00037_0002fdbinfempP_0002ejspdbinfempP_jsp_0.java:69: 
Class ch_00030_00037.SQLManager not found.
                  SQLManager myMan = SQLManager.getInstance();
                  ^
C:\Program Files\Apache 
Group\jakarta-tomcat\work\localhost_8080%2Fprojsp\_0002fch_00030_00037_0002fdbinfempP_0002ejspdbinfempP_jsp_0.java:69: 
Class ch_00030_00037.SQLManager not found.
                  SQLManager myMan = SQLManager.getInstance();
                                     ^
C:\Program Files\Apache 
Group\jakarta-tomcat\work\localhost_8080%2Fprojsp\_0002fch_00030_00037_0002fdbinfempP_0002ejspdbinfempP_jsp_0.java:69: 
Undefined variable or class name: SQLManager
                  SQLManager myMan = SQLManager.getInstance();
                                     ^
3 errors

 org.apache.jasper.JasperException: Unable to compile class for 
JSPC:\Program Files\Apache 
Group\jakarta-tomcat\work\localhost_8080%2Fprojsp\_0002fch_00030_00037_0002fdbinfempP_0002ejspdbinfempP_jsp_0.java:69: 
Class ch_00030_00037.SQLManager not found.
                  SQLManager myMan = SQLManager.getInstance();
                  ^
C:\Program Files\Apache 
Group\jakarta-tomcat\work\localhost_8080%2Fprojsp\_0002fch_00030_00037_0002fdbinfempP_0002ejspdbinfempP_jsp_0.java:69: 
Class ch_00030_00037.SQLManager not found.
                  SQLManager myMan = SQLManager.getInstance();
                                     ^
C:\Program Files\Apache 
Group\jakarta-tomcat\work\localhost_8080%2Fprojsp\_0002fch_00030_00037_0002fdbinfempP_0002ejspdbinfempP_jsp_0.java:69: 
Undefined variable or class name: SQLManager
                  SQLManager myMan = SQLManager.getInstance();
                                     ^
3 errors

 at org.apache.jasper.compiler.Compiler.compile(Compiler.java:247)
 at org.apache.jasper.runtime.JspServlet.loadJSP(JspServlet.java:413)
 at 
org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:149)
 at 
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:161)
 at 
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
 at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at 
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
 at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
 at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
 at 
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
 at java.lang.Thread.run(Unknown Source)
Context log: path="/projsp"  Error in custom error handler 
java.lang.NullPointerException
Context log: path="/projsp" <b>Internal Servlet Error:</b><br>
<pre>
java.lang.NullPointerException
 at 
org.apache.tomcat.core.ContextManager.handleError(ContextManager.java:736)
 at 
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:527)
 at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
 at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
 at 
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
 at java.lang.Thread.run(Unknown Source)
</pre>


This tomcat server shutdown is only caused by the dbqueryP.jsp . All the 
other jsp files just endup to a http 500 error.

The odbc works fine, but i guess there is no pooling

Pls help