You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jon Shoberg <js...@cbd.net> on 2001/09/21 04:37:44 UTC
JDBC Connection Pool Theory ??
Can anyone suggest or point to readings on JDBC connection pool theory?
Something that covers how a pool is implemented, best case / worst case
scenarios, tips and traps.
My next web application is looking to be very database (mysql) intensive.
I would like a pooling mechanism that is VERY simple to use, VERY light, low
overhead, and portable. Having looked at packages such as poolman, I
decided I need to learn a bit more about JDBC and pooling in general. Any
thoughts ?
Jon
How to Configue Tomcat 4 with IIS 5?
Posted by Leo Lin <yl...@ic.sunysb.edu>.
Hi All,
Does anyone know how to configue Tomcat4 with IIS 5?
So I can send the requests on http://IPADDRESS to
$CATALINA_HOME/webapps/ROOT,
and http://IPADDRESS/example to $CATALINA_HOME/webapps/example so on.
I'm running MSWin2k Server with IIS5 and Tomcat4 on the same machine.
Thank,
Leo
Re: BindException...
Posted by Max Chi <ma...@msa.hinet.net>.
hi,
I also had same problem before.
you may try to change "Apache-Connector Service" port from 8008 to any
other number.
max
----- Original Message -----
From: "Svante Berglund" <sv...@hiq.se>
To: <to...@jakarta.apache.org>
Sent: Friday, September 21, 2001 4:25 PM
Subject: SV: BindException...
> Hi.
> Nope, no other server is running and I´ve tried several different ports.
> Also, tomcat IS able to serve .html-pages, but not able to compile
> .jsp-pages.
>
> Thanks for answering!
> Svante
>
> -----Ursprungligt meddelande-----
> Från: G.Nagarajan [mailto:gnagarajan@dkf.de]
> Skickat: den 21 september 2001 10:22
> Till: tomcat-user@jakarta.apache.org
> Ämne: RE: BindException...
>
>
> Hi,
> If you are running NT, check if IIS is running. If windows 95x is running,
> check if Personal web server is running. Or change the http port to
> something like 8888 in server.xml and restart tomcat. If tomcat runs, then
> it means that some other server is running.
>
> Regards,
> Nagarajan.
>
> -----Original Message-----
> From: Svante Berglund [mailto:svante.berglund@hiq.se]
> Sent: Friday, September 21, 2001 10:13 AM
> To: tomcat-user@jakarta.apache.org
> Subject: BindException...
>
>
> Hi all.
>
> I recive an error message at startup from tomcat 3.2.3(see below). After
> that tomcat is only able to process .html-pages but fails to compile
> .jsp-pages. Do you have any clues why? No other server is running on the
> machine.
>
> /cheers
> Svante
>
> FATAL:java.net.BindException: Address in use: JVM_Bind
> java.net.BindException: Address in use: JVM_Bind
> at java.net.PlainSocketImpl.socketBind(Native Method)
> at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:405)
> at java.net.ServerSocket.<init>(ServerSocket.java:170)
> at java.net.ServerSocket.<init>(ServerSocket.java:121)
> at
> org.apache.tomcat.net.DefaultServerSocketFactory.createSocket(Default
> ServerSocketFactory.java:97)
> at
> org.apache.tomcat.service.PoolTcpEndpoint.startEndpoint(PoolTcpEndpoi
> nt.java:239)
> at
> org.apache.tomcat.service.PoolTcpConnector.start(PoolTcpConnector.jav
> a:188)
> at
> org.apache.tomcat.core.ContextManager.start(ContextManager.java:527)
> at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:202)
> at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
> D:\tomcat\bin>
>
>
SV: BindException...
Posted by Svante Berglund <sv...@hiq.se>.
Hi.
Nope, no other server is running and I´ve tried several different ports.
Also, tomcat IS able to serve .html-pages, but not able to compile
.jsp-pages.
Thanks for answering!
Svante
-----Ursprungligt meddelande-----
Från: G.Nagarajan [mailto:gnagarajan@dkf.de]
Skickat: den 21 september 2001 10:22
Till: tomcat-user@jakarta.apache.org
Ämne: RE: BindException...
Hi,
If you are running NT, check if IIS is running. If windows 95x is running,
check if Personal web server is running. Or change the http port to
something like 8888 in server.xml and restart tomcat. If tomcat runs, then
it means that some other server is running.
Regards,
Nagarajan.
-----Original Message-----
From: Svante Berglund [mailto:svante.berglund@hiq.se]
Sent: Friday, September 21, 2001 10:13 AM
To: tomcat-user@jakarta.apache.org
Subject: BindException...
Hi all.
I recive an error message at startup from tomcat 3.2.3(see below). After
that tomcat is only able to process .html-pages but fails to compile
.jsp-pages. Do you have any clues why? No other server is running on the
machine.
/cheers
Svante
FATAL:java.net.BindException: Address in use: JVM_Bind
java.net.BindException: Address in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:405)
at java.net.ServerSocket.<init>(ServerSocket.java:170)
at java.net.ServerSocket.<init>(ServerSocket.java:121)
at
org.apache.tomcat.net.DefaultServerSocketFactory.createSocket(Default
ServerSocketFactory.java:97)
at
org.apache.tomcat.service.PoolTcpEndpoint.startEndpoint(PoolTcpEndpoi
nt.java:239)
at
org.apache.tomcat.service.PoolTcpConnector.start(PoolTcpConnector.jav
a:188)
at
org.apache.tomcat.core.ContextManager.start(ContextManager.java:527)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:202)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
D:\tomcat\bin>
RE: BindException...
Posted by "G.Nagarajan" <gn...@dkf.de>.
Hi,
If you are running NT, check if IIS is running. If windows 95x is running,
check if Personal web server is running. Or change the http port to
something like 8888 in server.xml and restart tomcat. If tomcat runs, then
it means that some other server is running.
Regards,
Nagarajan.
-----Original Message-----
From: Svante Berglund [mailto:svante.berglund@hiq.se]
Sent: Friday, September 21, 2001 10:13 AM
To: tomcat-user@jakarta.apache.org
Subject: BindException...
Hi all.
I recive an error message at startup from tomcat 3.2.3(see below). After
that tomcat is only able to process .html-pages but fails to compile
.jsp-pages. Do you have any clues why? No other server is running on the
machine.
/cheers
Svante
FATAL:java.net.BindException: Address in use: JVM_Bind
java.net.BindException: Address in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:405)
at java.net.ServerSocket.<init>(ServerSocket.java:170)
at java.net.ServerSocket.<init>(ServerSocket.java:121)
at
org.apache.tomcat.net.DefaultServerSocketFactory.createSocket(Default
ServerSocketFactory.java:97)
at
org.apache.tomcat.service.PoolTcpEndpoint.startEndpoint(PoolTcpEndpoi
nt.java:239)
at
org.apache.tomcat.service.PoolTcpConnector.start(PoolTcpConnector.jav
a:188)
at
org.apache.tomcat.core.ContextManager.start(ContextManager.java:527)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:202)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
D:\tomcat\bin>
BindException...
Posted by Svante Berglund <sv...@hiq.se>.
Hi all.
I recive an error message at startup from tomcat 3.2.3(see below). After
that tomcat is only able to process .html-pages but fails to compile
.jsp-pages. Do you have any clues why? No other server is running on the
machine.
/cheers
Svante
FATAL:java.net.BindException: Address in use: JVM_Bind
java.net.BindException: Address in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:405)
at java.net.ServerSocket.<init>(ServerSocket.java:170)
at java.net.ServerSocket.<init>(ServerSocket.java:121)
at
org.apache.tomcat.net.DefaultServerSocketFactory.createSocket(Default
ServerSocketFactory.java:97)
at
org.apache.tomcat.service.PoolTcpEndpoint.startEndpoint(PoolTcpEndpoi
nt.java:239)
at
org.apache.tomcat.service.PoolTcpConnector.start(PoolTcpConnector.jav
a:188)
at
org.apache.tomcat.core.ContextManager.start(ContextManager.java:527)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:202)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
D:\tomcat\bin>
RE: JDBC Connection Pool Theory ??
Posted by Alexandre Victoor <av...@prisma-presse.com>.
Hello
I would like to know if somebody is using the pool of Turbine, used already
by tomcat. I am affraid that there is no doc on these classes :|
Alexandre
Re: JDBC Connection Pool Theory ??
Posted by Jonathan Eric Miller <je...@uchicago.edu>.
What I want to know is how much of a difference connection pooling really
makes? My application isn't taking a lot of hits, so, maybe if it was, I
would notice the difference, but, right now, I see no need to use connection
pooling.
Jon
----- Original Message -----
From: "Gustavo Saramago" <we...@ig.com.br>
To: <to...@jakarta.apache.org>
Sent: Friday, September 21, 2001 6:23 AM
Subject: Re: JDBC Connection Pool Theory ??
> It's hard to imagine a real world application without database access. The
> JDBC spec delegate the responsability for connection pool implementation
to
> th JDBC driver vendor. This result in proprietary implementations of pools
> that reduce code portability.
>
> General solutions like Poolman are good choices. It's a light piece of
code
> as Jon said, but I have saw people having problems using it with Tomcat.
Our
> lives would be mutch easier if the JDBC spec had defined a standard
> connection pool.
>
> Why Tomcat do not implement a connection pool? Nothing aganist Poolman,
but
> standards are welcome.
>
> ----- Original Message -----
> From: "Jon Shoberg" <js...@cbd.net>
> To: <to...@jakarta.apache.org>
> Sent: Friday, September 21, 2001 12:48 AM
> Subject: RE: JDBC Connection Pool Theory ??
>
>
> >
> >
> > One of the issues would be someting that has been crossing the lists
> > recently. Few people have posted that poolman is broken under TC4.0.
> I'll
> > have to try it myself and see. However, I like to do my own plumbing :)
> >
> > Jon
> >
> > -----Original Message-----
> > From: Vladimir Grishchenko [mailto:vladgri@hotmail.com]
> > Sent: Thursday, September 20, 2001 10:32 PM
> > To: tomcat-user@jakarta.apache.org
> > Subject: Re: JDBC Connection Pool Theory ??
> >
> >
> > "Professional Java server programming " from WROX had a chapter about
it,
> as
> > far as I remember. I can't call it a "comprehensive study", but it had
> some
> > meaningful explanations.
> >
> > What's wrong with poolman btw? IMHO it is as simple as it gets, your
> > application doesn't even know it deals with pooled connections.
Portable?
> As
> > portable as Java itself.
> >
> > My philosophy on such things is take it if it's available and
concentrate
> > on your application domain issues and not the plumbing (plumbing in good
> > sense here...).
> >
> > --V.
> >
> >
> > ----- Original Message -----
> > From: "Jon Shoberg" <js...@cbd.net>
> > To: <to...@jakarta.apache.org>
> > Sent: Thursday, September 20, 2001 7:37 PM
> > Subject: JDBC Connection Pool Theory ??
> >
> >
> > >
> > > Can anyone suggest or point to readings on JDBC connection pool
theory?
> > > Something that covers how a pool is implemented, best case / worst
case
> > > scenarios, tips and traps.
> > >
> > > My next web application is looking to be very database (mysql)
> intensive.
> > > I would like a pooling mechanism that is VERY simple to use, VERY
light,
> > low
> > > overhead, and portable. Having looked at packages such as poolman, I
> > > decided I need to learn a bit more about JDBC and pooling in general.
> Any
> > > thoughts ?
> > >
> > > Jon
> > >
> > >
> >
>
Re: JDBC Connection Pool Theory ??
Posted by "Roy K. Mayr R." <sy...@uapar.edu>.
Hi,
Anybody are using Poolman with Tomcat 4 ?? it works ??
Roy
Re: JDBC Connection Pool Theory ??
Posted by Gustavo Saramago <we...@ig.com.br>.
It's hard to imagine a real world application without database access. The
JDBC spec delegate the responsability for connection pool implementation to
th JDBC driver vendor. This result in proprietary implementations of pools
that reduce code portability.
General solutions like Poolman are good choices. It's a light piece of code
as Jon said, but I have saw people having problems using it with Tomcat. Our
lives would be mutch easier if the JDBC spec had defined a standard
connection pool.
Why Tomcat do not implement a connection pool? Nothing aganist Poolman, but
standards are welcome.
----- Original Message -----
From: "Jon Shoberg" <js...@cbd.net>
To: <to...@jakarta.apache.org>
Sent: Friday, September 21, 2001 12:48 AM
Subject: RE: JDBC Connection Pool Theory ??
>
>
> One of the issues would be someting that has been crossing the lists
> recently. Few people have posted that poolman is broken under TC4.0.
I'll
> have to try it myself and see. However, I like to do my own plumbing :)
>
> Jon
>
> -----Original Message-----
> From: Vladimir Grishchenko [mailto:vladgri@hotmail.com]
> Sent: Thursday, September 20, 2001 10:32 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Re: JDBC Connection Pool Theory ??
>
>
> "Professional Java server programming " from WROX had a chapter about it,
as
> far as I remember. I can't call it a "comprehensive study", but it had
some
> meaningful explanations.
>
> What's wrong with poolman btw? IMHO it is as simple as it gets, your
> application doesn't even know it deals with pooled connections. Portable?
As
> portable as Java itself.
>
> My philosophy on such things is take it if it's available and concentrate
> on your application domain issues and not the plumbing (plumbing in good
> sense here...).
>
> --V.
>
>
> ----- Original Message -----
> From: "Jon Shoberg" <js...@cbd.net>
> To: <to...@jakarta.apache.org>
> Sent: Thursday, September 20, 2001 7:37 PM
> Subject: JDBC Connection Pool Theory ??
>
>
> >
> > Can anyone suggest or point to readings on JDBC connection pool theory?
> > Something that covers how a pool is implemented, best case / worst case
> > scenarios, tips and traps.
> >
> > My next web application is looking to be very database (mysql)
intensive.
> > I would like a pooling mechanism that is VERY simple to use, VERY light,
> low
> > overhead, and portable. Having looked at packages such as poolman, I
> > decided I need to learn a bit more about JDBC and pooling in general.
Any
> > thoughts ?
> >
> > Jon
> >
> >
>
RE: JDBC Connection Pool Theory ??
Posted by Jon Shoberg <js...@cbd.net>.
One of the issues would be someting that has been crossing the lists
recently. Few people have posted that poolman is broken under TC4.0. I'll
have to try it myself and see. However, I like to do my own plumbing :)
Jon
-----Original Message-----
From: Vladimir Grishchenko [mailto:vladgri@hotmail.com]
Sent: Thursday, September 20, 2001 10:32 PM
To: tomcat-user@jakarta.apache.org
Subject: Re: JDBC Connection Pool Theory ??
"Professional Java server programming " from WROX had a chapter about it, as
far as I remember. I can't call it a "comprehensive study", but it had some
meaningful explanations.
What's wrong with poolman btw? IMHO it is as simple as it gets, your
application doesn't even know it deals with pooled connections. Portable? As
portable as Java itself.
My philosophy on such things is take it if it's available and concentrate
on your application domain issues and not the plumbing (plumbing in good
sense here...).
--V.
----- Original Message -----
From: "Jon Shoberg" <js...@cbd.net>
To: <to...@jakarta.apache.org>
Sent: Thursday, September 20, 2001 7:37 PM
Subject: JDBC Connection Pool Theory ??
>
> Can anyone suggest or point to readings on JDBC connection pool theory?
> Something that covers how a pool is implemented, best case / worst case
> scenarios, tips and traps.
>
> My next web application is looking to be very database (mysql) intensive.
> I would like a pooling mechanism that is VERY simple to use, VERY light,
low
> overhead, and portable. Having looked at packages such as poolman, I
> decided I need to learn a bit more about JDBC and pooling in general. Any
> thoughts ?
>
> Jon
>
>
Re: JDBC Connection Pool Theory ??
Posted by Vladimir Grishchenko <vl...@hotmail.com>.
"Professional Java server programming " from WROX had a chapter about it, as
far as I remember. I can't call it a "comprehensive study", but it had some
meaningful explanations.
What's wrong with poolman btw? IMHO it is as simple as it gets, your
application doesn't even know it deals with pooled connections. Portable? As
portable as Java itself.
My philosophy on such things is take it if it's available and concentrate
on your application domain issues and not the plumbing (plumbing in good
sense here...).
--V.
----- Original Message -----
From: "Jon Shoberg" <js...@cbd.net>
To: <to...@jakarta.apache.org>
Sent: Thursday, September 20, 2001 7:37 PM
Subject: JDBC Connection Pool Theory ??
>
> Can anyone suggest or point to readings on JDBC connection pool theory?
> Something that covers how a pool is implemented, best case / worst case
> scenarios, tips and traps.
>
> My next web application is looking to be very database (mysql) intensive.
> I would like a pooling mechanism that is VERY simple to use, VERY light,
low
> overhead, and portable. Having looked at packages such as poolman, I
> decided I need to learn a bit more about JDBC and pooling in general. Any
> thoughts ?
>
> Jon
>
>
Re: JDBC Connection Pool Theory ??
Posted by "C. Schlegelmilch" <c_...@yahoo.com>.
We had our web development class develop their own
software for connection pooling. These are extremely
simple soluitons but they work quite well for the
small to medium traffic they are likely to get.
They are using "Professional Java Server Programming"
as a reference and it has some interesting sections on
Connection Pooling. This is good if you're only
running a simple application. It was also noted that
this resource did not address any synchronization
issues which is very important (the last thing you
want is two seperate threads getting a reference to
the next free connection at the same time). This is
really the only big gottcha that we found in a simple
implementation.
--- Jon Shoberg <js...@cbd.net> wrote: >
> Can anyone suggest or point to readings on JDBC
> connection pool theory?
> Something that covers how a pool is implemented,
> best case / worst case
> scenarios, tips and traps.
>
> My next web application is looking to be very
> database (mysql) intensive.
> I would like a pooling mechanism that is VERY simple
> to use, VERY light, low
> overhead, and portable. Having looked at packages
> such as poolman, I
> decided I need to learn a bit more about JDBC and
> pooling in general. Any
> thoughts ?
>
> Jon
>
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie