about connection pooling.

[purak shah <pu...@yahoo.com>]

Hi,
I am using karl moss' book java servlets and involved
in development process of one portal using beans and
jsp.

although ut is the problem of servlets i think i can
paste this problem here because ultimatley i am going
to use this servlet with my jsp.

I want to use ConnectionPooling and for that i am
refering this book.
In the book two servlets  (ConnectionServlet,
FastEmployeeList2) and one class ConnectionPool are
there.

With apache web server 1.3.6 and apache jrun 1.1 i can
run the program nicely.
But when i use tomcat 3.0 or jrun 3.0 beta, it does
not run.

I have checked the conf. file of servlet so that it
can load ConnectionServlet when it starts but when i
run the FastEmployeeList2 program it gives me error
like ConnectionServlet is not loaded.
I am pasting the exception here.

It shows

Error: 500
Location: /javaservlets/FastEmployeeList2
Internal Servlet Error:

javax.servlet.ServletException: ConnectionServlet not
started
        at
javaservlets.db.FastEmployeeList2.query(FastEmployeeList2.java:134)
        at
javaservlets.db.FastEmployeeList2.doGet(FastEmployeeList2.java:64)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
        at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
        at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:160)
        at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
)
        at java.lang.Thread.run(Unknown Source)


At the same time tomcat server's java console shows

Starting tomcat in new window
Using classpath:
d:\devtools\tomcat\classes;d:\devtools\tomcat\lib\webserver.jar
;d:\devtools\tomcat\lib\jasper.jar;d:\devtools\tomcat\lib\xml.jar;d:\devtool
s\to
mcat\lib\servlet.jar;d:\devtools\jdk1.3\lib\tools.jar;;d:\devtools\jdk1.3\li
b\to
ols.jar;d:\devtools\tomcat\lib\servlet.jar;.;..
Context log: path="/examples" Adding context
path="/examples"  docBase="webapps/
examples"
Context log: path="" Adding context path=""
docBase="webapps/ROOT"
Context log: path="/test" Adding context path="/test"
docBase="webapps/test"
Starting tomcat. Check logs/tomcat.log for error
messages
Starting tomcat install="d:\devtools\tomcat"
home="D:\devtools\tomcat" classPath
="d:\devtools\tomcat\classes;d:\devtools\tomcat\lib\webserver.jar;d:\devtool
s\to
mcat\lib\jasper.jar;d:\devtools\tomcat\lib\xml.jar;d:\devtools\tomcat\lib\se
rvle
t.jar;d:\devtools\jdk1.3\lib\tools.jar;;d:\devtools\jdk1.3\lib\tools.jar;d:\
devt
ools\tomcat\lib\servlet.jar;.;.."
Context log: path="/admin" Automatic context load
docBase="D:\devtools\tomcat\we
bapps\admin"
Context log: path="/admin" Adding context
path="/admin"  docBase="D:\devtools\to
mcat\webapps\admin"
Context log: path="/web.xml" Automatic context load
docBase="D:\devtools\tomcat\
webapps\web.xml"
Context log: path="/web.xml" Adding context
path="/web.xml"  docBase="D:\devtool
s\tomcat\webapps\web.xml"
Context log: path="/ConnectionPooling" Automatic
context load docBase="D:\devtoo
ls\tomcat\webapps\ConnectionPooling"
ConnectionPool: JDBCDriver =
sun.jdbc.odbc.JdbcOdbcDriver
ConnectionPool: JDBCConnectionURL =
jdbc:odbc:MyAccessDataSource
ConnectionPool: ConnectionPoolSize = 5
ConnectionPool: ConnectionPoolMax = 100
ConnectionPool: ConnectionUseCount = 5
ConnectionPool: ConnectionTimeout = 2 seconds
ConnectionPool: (JDBC Property) Password = larryboy
ConnectionPool: (JDBC Property) User = karl
ConnectionPool: Registering
sun.jdbc.odbc.JdbcOdbcDriver


This means connectionServlet is loaded but
FastEmployeeList2 is unable to find it.

Pls guide me what should i do.

Regards

Purak