tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunhild Copony <sunny.cop...@inovit.de>
Subject Please help! Tomcat 4.0 and XSQL-Servlet from Oracle - Example is not running!!
Date Mon, 21 Jan 2002 11:42:52 GMT
Hi,

maybe someone has a good idea for me - I'm stuck...

I'm using Tomcat 4.0 rc1 on SuSE-Linux (without Apache!) and Oracle
8.1.7 on the same machine, Tomcat on port 8090, Oracle on port 1521.

I want to run the sample "fly" from Oracle and have done the following:

- unpacked the sample in webapps/xsql/fly and generated the data needed
on instance PACS, user pacs, passw pacs.
- unpacked oraclexsql.jar into /home/oracle/product/8.1.7/xdk/xsql/

- entered the Context in server.xml:
       <!-- oracle xsql Context -->
        <Context path="/xsql"
docBase="/home/oracle/product/8.1.7/xdk/xsql/"  debug="99"
reloadable="true"/>
# quite strange, but found it similar in some doc for WinNT
        <!-- Fly Sample Context -->
        <Context path="/xsql/fly" docBase="xsql/fly" debug="99"
reloadable="true"/>

- entered the classpath in cataline.sh:
# oracle xsql
if [ -f "$ORACLE_HOME/xdk/lib/oraclexsql.jar" ] ; then
  CP=$CP:"$ORACLE_HOME/xdk/lib/oraclexsql.jar"
  CP=$CP:"$ORACLE_HOME/xdk/lib/xmlparserv2.jar"
  CP=$CP:"$ORACLE_HOME/xdk/lib"
fi
if [ -f "$ORACLE_HOME/jdbc/lib/classes111.jar" ] ; then
  CP=$CP:"$ORACLE_HOME/jdbc/lib/classes111.jar"
fi

- don't have any web.xml in webapps/xsql/WEB-INF

- changed the XMLConfig.xml
   <connection name="fly">
      <username>pacs</username>
      <password>pacs</password>
      <dburl>jdbc:oracle:thin:@localhost:1521:PACS</dburl>
      <driver>oracle.jdbc.driver.OracleDriver</driver>
    </connection>

- changed "Apache-urls" in index.xsql  into
 <a href="http://localhost:8090/xsql/fly/index.xsql">English</a>
...

What I get in Netscape:
- http://localhost:8090/xsql/ shows the directory listing (no index.html
is existing)
- http://localhost:8090/xsql/fly/index.html shows the entry page where I
can select language and WebServer.
When I'm clicking on English I get an empty page. The page source looks
ok...
- I can connect to the database from the same or from another machine
via sqlplus or Toad and can see all those magnificant flights and
airports...

- in tomcat/logs/localhost_logs I get the following:
2002-01-21 12:20:22 StandardContext[/xsql/fly]: Mapping
contextPath='/xsql/fly' with requestURI='/xsql/fly/index.xsql' and
relativeURI='/index.xsql'
2002-01-21 12:20:22 StandardContext[/xsql/fly]: Decoded
relativeURI='/index.xsql'
2002-01-21 12:20:22 StandardContext[/xsql/fly]:   Trying exact match
2002-01-21 12:20:22 StandardContext[/xsql/fly]:   Trying prefix match
2002-01-21 12:20:22 StandardContext[/xsql/fly]:   Trying extension match

2002-01-21 12:20:22 StandardContext[/xsql/fly]:   Trying default match
2002-01-21 12:20:22 StandardContext[/xsql/fly]:  Mapped to servlet
'default' with servlet path '/index.xsql' and path info 'null' and
update=true
WHY is here servlet 'default' and path info 'null'? What's wrong?
Last try: copied the unpacked classes into
webapps/xsql/WEB-INF/classes/oracle/xml/... but - no change (well didn't
expected really that would help...)


Whould be very happy to get some help!!!

THX,
Sunny


--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message