i have made some changes, with a positive result, namely, i am getting an
error message instead of the mere echoeing of source code.  It looks like
there is still an issue of Tomcat finding the xsql jar files.
how do i add the oracle xsql jar files to tomcat such that tomcat knows
where to find them???

i have specified these xsql jar files in 3 places so far,
1-o/s classpath
2-workers2.properties file where java instance parameters defined
3-have physically copied them into [tomcat_home]\common\lib  , which is also
where the jdbc driver jar files are

what i have done is as follows, and the error message is provided as well:

1)

adding following to workers2.properties Apache configuration file:

[uri:/*.xsql]

this suppose to forward .xsql files received by Apache, to Tomcat


2)

adding following to web.xml file for ROOT web app application,

   <servlet>
      <servlet-name>oracle-xsql-servlet</servlet-name>
      <servlet-class>oracle.xml.xsql.XSQLServlet</servlet-class>
   </servlet>
    <servlet-mapping>
      <servlet-name>oracle-xsql-servlet</servlet-name>
      <url-pattern> *.xsql </url-pattern>
   </servlet-mapping>

this looks to me like it is associating the .xsql file type with the .jar
class

3)---------------------------------------Tomcat error page:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it
from fulfilling this request.

exception

javax.servlet.ServletException: Error allocating a servlet instance

...

root cause

java.lang.NoClassDefFoundError: javax/servlet/http/HttpServlet

----------------------------------------------------------------------------
----



----- Original Message ----- 
From: "Paul" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 04, 2004 10:46 AM
Subject: Tomcat 4x, configuring for XSLT or XSQL


i am trying to run some Oracle .xsql pages.  I have the xslt jar files, but
am not sure how to add them to the servlet engine so that Tomcat can find
them when it processes an .xsql file.  Any help would be much appreciated.

software system is as follows:

 windows 2000
 java jdk 1.4
jakarta-tomcat-4.1.27-LE-jdk14.exe
apache_2.0.48-win32-x86-no_ssl.msi
 jk2 connector
 oracle jdbc driver 9.x

class path for Java set in workers2.properties file as follows:

[vm:]
info=Parameters used to load a JVM in the server process
#JVM=C:\jdk\jre\bin\hotspot\jvm.dll
OPT=-Djava.class.path=C:/Tomcat41/bin/tomcat-jni.jar;C:/Tomcat41/server/lib/
commons-logging.jar;E:/oracle/ora92/lib/xsu12.jar;E:/oracle/ora92/lib/xmlpar
serv2.jar;E:/oracle/ora92/lib/oraclexsql.jar;E:/oracle/ora92/xdk/admin
OPT=-Dtomcat.home=${TOMCAT_HOME}
OPT=-Dcatalina.home=${TOMCAT_HOME}
OPT=-Xms64M
OPT=-Xmx64M
OPT=-Duser.language=en
OPT=-Duser.region=US
#OPT=-Djava.compiler=NONE
disabled=0

however, xsql pages are still not processed, but rather, when run, the
source code is merely echoed to the screen.

also, i do not know where or how to map the file extension .xsql to the jar
file or class

-paul.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to