You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Thor Tall <ta...@yahoo.com> on 2002/03/02 07:32:49 UTC

tomcat 4.0.2 and oracles XDK (xsql) Urgent

I am trying to install some *.xsql pages under tomcat
4.0.2 with out luck. 

I am using : 
Oracle 9.0.1 rdbms 
Oracle XSQL Servlet Page Processor 9.0.1.0.0
(Production) 
from the 9.0.1 Linux distribution. 
Redhat 7.2 
Java - j2sdk1.4.0 

I have: 
1. copied classes12.jar, oraclexsql.jar, xsu12.jar and
xmlparserv2.jar to <tomcathome>/common/lib 
2. copied XSQLConfig.xml to
<tomcathome>/common/classes 
I have used the same XSQLConfig.xml with Apache/JServ
and it works. 
3. added the following two sections to the
<tomcathome>/conf/web.xml file: 

<!-- Oracle xsql processing --> 
<servlet> 
<servlet-name>xsql</servlet-name> 
<servlet-class>oracle.xml.xsql.XSQLServlet</servlet-class>

</servlet> 

<servlet-mapping> 
<servlet-name>xsql</servlet-name> 
<url-pattern>*.xsql</url-pattern> 
</servlet-mapping> 

4. copied helloworld.xsql into
<tomcathome>/webapps/ROOT/ 

5. started tomcat with the new files. 


Now when I access the example as: 
http://myhost:8180/helloworld.xsql 

I get : 
Oracle XSQL Servlet Page Processor 9.0.1.0.0
(Production) 

XSQL-007: Cannot acquire a database connection to
process page. 
java.lang.ClassNotFoundException:
oracle.jdbc.driver.OracleDriver 


What could possibly be wrong ??? 

Thanks 
Thor

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com

--
To unsubscribe:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>