problems with JDBC Servlet Demo

[Bhaskar]

Hi all

I m facing problems in servlet demo installation.
for which I have downloaded JFreeServlet-0.9.2-v2.war and changed the web.xml for my custom oracle entries. these are the following entries i have done in web.xml.
<context-param>
<param-name>DBserver.type</param-name>
<param-value>0</param-value>
</context-param>
<context-param>
<param-name>DBdriver</param-name>
<param-value>oracle.jdbc.driver.OracleDriver</param-value>
</context-param>
<context-param>
<param-name>DBpwd</param-name>
<param-value>mtdl</param-value>
</context-param>
<context-param>
<param-name>DBschema</param-name>
<param-value></param-value>
</context-param>
<context-param>
<param-name>DBurl</param-name>
<param-value>jdbc:oracle:thin:@PTHCHASE:1521:mtdltio</param-value>
</context-param>
<context-param>
<param-name>DBuser</param-name>
<param-value>mtdl_user</param-value>
</context-param>

In case of JDBC servlet example i am getting the following Exception.

Servlet ImageSelectSQL - Debug : true
Servlet ImageSelectSQL - Driver : oracle.jdbc.driver.OracleDriver
Servlet ImageSelectSQL - Database : jdbc:oracle:thin:@PTHCHASE:1521:mtdltio
Servlet ImageSelectSQL - Schema :
Servlet ImageSelectSQL - User : mtdl_user
Servlet ImageSelectSQL - Password : #######
Servlet ImageSelectSQL - Cannot find database JDBC drivers - check CLASSPATH
Servlet ImageSelectSQL - : generating output IMAGE
Servlet ImageSelectSQL - doImage output starting
Creating chart of type 25
There is no database to execute the query.

where as my own custom servlet is running fine with same database settings. plz let me know the remedy.


thanx
bhaskar

[Bryan]

Bhaskar

Are the oracle libraries in either of (examples are tomcat 4.1.2 based)
a) in the webapp library directory
$TOMCAT_HOME/webapp/JFreeServlet/WEB-INF/lib

or

b) in tomcats common container
$TOMCAT_HOME/common/lib

Bryan

[bhaskar]

Hi bryan

I am using tomcat 1.0.4b and I have put all oracle driver zip files in class path as well as in the D:\Tomcat\jakarta-tomcat-4.0-b1\lib and I also tried same by putting the oracle driver files in to $TOMCAT_HOME/webapp/JFreeServlet/WEB-INF/lib

but both cases are not working it seems it is configuration problem may be with Apache it self.

plz do let me know if u have any idea.

thanx for ur reply
bhaskar

[Bryan]

Bhaskar

A quick question, have you renamed classes12.zip to classes12.jar?

Bryan