Venkat Manne

Thanks for the help.
I just got it, I do not get the exact reasoin.
My query goes like this (.......) union (.....) . The same query worked at the SQL promrt but got struck in JSP.
I got the result when the braces are removed, I am not sure why this is working now.
Venkat

I have a problem while accessing Oracle database from JSP.
The query works fine, when I directly execute at the Oracle 8.1.6, SQL prompt, But it gives the following error when I try the same query from a JSP page.
ORA-01009: Missing mandatory Parameter
Why is this happening? i subsituted the variables wh=ith constants in the JSP page, even then it returns the same error.
I am using Classes12.zip.
Can anybody help me out.
Thanks in advance,
Venkat.

Thanks a lot Mike.
It really worked, I am able to redirect the requests and everything is fine. Hope to talk to you soon.
Thanks again,
Suresh.

Earlier I placed 'mysite' in "\webapps\examples\" and the class files as said in my earlier note. Now "mysite" is shifted to "\htdocs\" of Apache. My class files fails to get imported. I created the seperate directory as shown above by you. Still they are failing. Any suggestions to continue..hope some from you.
Thanks in advance,
Manne.

Hi,
There was not much success this time..and I am repeatedly getting the same error. I placed my Java Class files directory as before ie in "\webapps\examples\WEB-INF\classes" and modified the web.xml file by adding the following lines:
<ContextManager debug="0" workDir="work" showDebugInfo="true" >
<Context path="\mysite"
docBase="c:\Program Files\Apache Group\Apache\htdocs\mysite"
crossContext="false"
debug="0"
reloadable="true" >
</Context>
</ContextManager>
The error I get is:
org.apache.jasper.JasperException: Unable to compile class for JSPD:\jakarta-tomcat-3.2.1\work\localhost_8080%2Falscsite\_0002fsearch_0002fparaSearch_0002ejspparaSearch_jsp_0.java:16: Package pool not found in import.
where "pool" is my folder of class files placed in the directory mentioned earlier.
Please help me out,
Manne.

[This message has been edited by Venkat Manne (edited May 31, 2001).]

Thanks a lot Mike.
It really worked, I am able to direct my request for .jsp to Tomcat. But I am hooked up with another problem in porting it completely. I have some .class files for .jsp . Earlier I placed them in "\webapps\examples\WEB-INF\classes" of Tomcat, It was fine. Where should i place my class files now in Apache to make my Apache+Tomcat serve the .jsp file.
Thanks in advance,
Manne.

Originally posted by Xavier VS:
hi,
U have to download ApacheServModule.dll (not sure about he name)
from jakarta.apache.org
and put in a folder .
read the installation notes for tomcat server.
Xavier

Thanks for ur reply,I have installed ApacheJservModule.dll . I placed my Html and Jsp files in the htdocs directory of Apache. I am not able to redirect the request to Tomcat for serving the dynamic content. My request is being served if I place the Jsp file in Tomcat's webapps/examples/... directory. How could I respond for a request for JSP file without placing it in Tomcat?

I want to integrate Tomcat3.2.1 and Apache1.3.9 to work with JSP and Oracle. I have installed mod_jserv also as server adapter. Appropriate changes were done in the tomcat.conf file in Tomcat and httpd.conf of Apache.
In httd.conf the following lines were added:
include d:/jakarta-tomcat-3.2.1/conf/tomcat-apache.conf
include d:/jakarta-tomcat-3.2.1/conf/tomcat.conf
I start Tomcat and then Apache, in starting Apache I get the syntax error in line where the line is
ApjServManual on
Could you help me out!!!
Thanks in advance,
Suresh.

I want to integrate Tomcat3.2.1 and Apache1.3.9 to work with JSP and Oracle. I have installed mod_jserv also as server adapter. Appropriate changes were done in the tomcat.conf file in Tomcat and httpd.conf of Apache.
In httd.conf the following lines were added:
include d:/jakarta-tomcat-3.2.1/conf/tomcat-apache.conf
include d:/jakarta-tomcat-3.2.1/conf/tomcat.conf
I start Tomcat and then Apache, in starting Apache I get the syntax error in line where the line is
ApjServManual on
Could you help me out!!!
Thanks in advance,
Suresh.

I want to integrate Tomcat3.2.1 and Apache1.3.9 to work with JSP and Oracle. I have installed mod_jserv also as server adapter. Appropriate changes were done in the tomcat.conf file in Tomcat and httpd.conf of Apache.
In httd.conf the following lines were added:
include d:/jakarta-tomcat-3.2.1/conf/tomcat-apache.conf
include d:/jakarta-tomcat-3.2.1/conf/tomcat.conf
I start Tomcat and then Apache, in starting Apache I get the syntax error in line where the line is
ApjServManual on
Could you help me out!!!
Thanks in advance,
Suresh.