Re: help - tomcat/dbcp deployment

[Rasputin]

* Paul Yunusov <[EMAIL PROTECTED]> [0127 19:27]:
> On Sunday 12 January 2003 02:50 pm, David Durst wrote:
> > > Well, to get DBCP working was not difficult at all. I just followed
> > > Tomcat how-to docs. And, as I learned from other people, it's being used
> > > on a production level.
 >
> > I have been trying to get this damn thing working w/ postgres for about
> > a week now.

> > I got it working on 1 machine (MY DESKTOP) from a completely fresh install
> > of 4.1.18 w/ J2SDK 1.4.

> > I attempted to duplicate the enviroment on the development server, and I
> > think I have achieved duplication, BUT it still doesn't work.

> > It seems not not be able to find the JDBC driver, it thinks the
> > driverClassName I am passing through is NULL.
 
> Try putting the driver's jar file in $JAVA_HOME/jre/lib/ext 

I put the j2ee jarfile for postgresql in $catalina_home/common/lib/,
that worked fine. Get the latest jar from jdbc.postgresql.org and try that.
If the OP still has trouble and wants to compare notes, post again - this was a
doddle with my setup. 

I'm using PgSQL 7.2.3 ( upgrading to 7.3.1 as I type this),
tomcat 4.1.18 and suns 1.3.1 jdk. Only snag I had was using md5 passwords to
authenticate tomcat itself, I fixed that by using the 7.3 postgresql jarfile.

-- 
Rasputin :: Jack of All Trades - Master of Nuns

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: help - tomcat/dbcp deployment

[Paul Yunusov]

On Sunday 12 January 2003 02:50 pm, David Durst wrote:
> > Well, to get DBCP working was not difficult at all. I just followed
> > Tomcat how-to docs. And, as I learned from other people, it's being used
> > on a production level.
> >
> > My Tomcat's version is 4.1.12.
> >
> > Thank you.
> > Igor TN
>
> I have been trying to get this damn thing working w/ postgres for about
> a week now.
>
> I got it working on 1 machine (MY DESKTOP) from a completely fresh install
> of 4.1.18 w/ J2SDK 1.4.
>
> I attempted to duplicate the enviroment on the development server, and I
> think I have achieved duplication, BUT it still doesn't work.
>
> It seems not not be able to find the JDBC driver, it thinks the
> driverClassName I am passing through is NULL.

Try putting the driver's jar file in $JAVA_HOME/jre/lib/ext 

Paul

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: help - tomcat/dbcp deployment

[David Durst]

> Well, to get DBCP working was not difficult at all. I just followed
> Tomcat how-to docs. And, as I learned from other people, it's being used
> on a production level.
>
> My Tomcat's version is 4.1.12.
>
> Thank you.
> Igor TN

I have been trying to get this damn thing working w/ postgres for about
a week now.

I got it working on 1 machine (MY DESKTOP) from a completely fresh install
of 4.1.18 w/ J2SDK 1.4.

I attempted to duplicate the enviroment on the development server, and I
think I have achieved duplication, BUT it still doesn't work.

It seems not not be able to find the JDBC driver, it thinks the
driverClassName I am passing through is NULL.



--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: help - tomcat/dbcp deployment

[Igor I. Tovstopyat-Nelip]

Well, to get DBCP working was not difficult at all. I just followed Tomcat
how-to docs. And, as I learned from other people, it's being used on a
production level.

My Tomcat's version is 4.1.12.

Thank you.
Igor TN


> Hi,
>
> I developed a web-app consisting mostly of servlets and JSP, almost no
> static content. The application uses mysql and obtains connections from
> a dbcp connection pool.
>
> Now I'm deploying it for production on Linux (RedHat 7.2) in a tomcat
> standalone configuration. (Almost no static content, no cgi, no virtual
> hosts, no clustering, so I decided Apache httpd is not really needed.)
>
> It works pretty good for some time but ... The next morning the server
> is up and running but I can't obtain connection. When I'm trying to
> login into the app, the LoginServlet which is supposed to get a
> connection from the pool gives me an exception. Unfortunately, I can't
> show it here now, because I didn't copy it, and it will appear next time
> only tomorrow. But it reports something like Connection Failure, so it
> looks like a
> connection cannot be obtained from the pool.
>
> I'm quite positive that all my ResultSet's, Statement's and Connection's
> are closed in all appropriate places, and I'm also using
> 'removeAbandoned' in the server.xml descriptor.
>
> What can be the source of this problem?
>
> Also, immediately after my tomcat server is started, I lookup the
> running processes ( ps -ux ) and see that 25 JVM's is launched. Why so
> many? Is this normal? And what scares me is that all of those 25 JVM's
> are using 6% of memory each ( 25*6% > 100% ! ). At least this is what
> the ps command shows. Can anybody shed some light on this?
>
> Is DBCP good for production? I configured it exactly as the Tomcat docs
> instruct.
>
> I will appreciate any comments and advices.
>
> Thank you.

Wow! you actually got DBCP working
What version of tomcat are you using???






--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: help - tomcat/dbcp deployment

[David Durst]

> Hi,
>
> I developed a web-app consisting mostly of servlets and JSP, almost no
> static content. The application uses mysql and obtains connections from
> a dbcp connection pool.
>
> Now I'm deploying it for production on Linux (RedHat 7.2) in a tomcat
> standalone configuration. (Almost no static content, no cgi, no virtual
> hosts, no clustering, so I decided Apache httpd is not really needed.)
>
> It works pretty good for some time but ... The next morning the server
> is up and running but I can't obtain connection. When I'm trying to
> login into the app, the LoginServlet which is supposed to get a
> connection from the pool gives me an exception. Unfortunately, I can't
> show it here now, because I didn't copy it, and it will appear next time
> only tomorrow. But it reports something like Connection Failure, so it
> looks like a
> connection cannot be obtained from the pool.
>
> I'm quite positive that all my ResultSet's, Statement's and Connection's
> are closed in all appropriate places, and I'm also using
> 'removeAbandoned' in the server.xml descriptor.
>
> What can be the source of this problem?
>
> Also, immediately after my tomcat server is started, I lookup the
> running processes ( ps -ux ) and see that 25 JVM's is launched. Why so
> many? Is this normal? And what scares me is that all of those 25 JVM's
> are using 6% of memory each ( 25*6% > 100% ! ). At least this is what
> the ps command shows. Can anybody shed some light on this?
>
> Is DBCP good for production? I configured it exactly as the Tomcat docs
> instruct.
>
> I will appreciate any comments and advices.
>
> Thank you.

Wow! you actually got DBCP working
What version of tomcat are you using???



--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

help - tomcat/dbcp deployment

[Igor I. Tovstopyat-Nelip]

Hi,

I developed a web-app consisting mostly of servlets and JSP, almost no
static content. The application uses mysql and obtains connections from
a dbcp connection pool.

Now I'm deploying it for production on Linux (RedHat 7.2) in a tomcat
standalone configuration. (Almost no static content, no cgi, no virtual
hosts, no clustering, so I decided Apache httpd is not really needed.)

It works pretty good for some time but ... The next morning the server is
up and running but I can't obtain connection. When I'm trying to login
into the app, the LoginServlet which is supposed to get a connection from
the pool gives me an exception. Unfortunately, I can't show it here now,
because I didn't copy it, and it will appear next time only tomorrow. But
it reports something like Connection Failure, so it looks like a
connection cannot be obtained from the pool.

I'm quite positive that all my ResultSet's, Statement's and Connection's
are closed in all appropriate places, and I'm also using 'removeAbandoned'
in the server.xml descriptor.

What can be the source of this problem?

Also, immediately after my tomcat server is started, I lookup the running
processes ( ps -ux ) and see that 25 JVM's is launched. Why so many? Is
this normal? And what scares me is that all of those 25 JVM's are using 6%
of memory each ( 25*6% > 100% ! ). At least this is what the ps command
shows. Can anybody shed some light on this?

Is DBCP good for production? I configured it exactly as the Tomcat docs
instruct.

I will appreciate any comments and advices.

Thank you.

Igor TN


--
To unsubscribe, e-mail:   
For additional commands, e-mail: