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:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
