----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Ben: I agree with you but there's a problem: I don't know how to create a database
pooling, I mean I know products like Bea Weblogic or Allaire JRun manage it, but my
budget is not enough to adquire it.
My question to you is: How can I improve a db pooling using only these resources
(Apache & Jserv & Jconnect & Java)?
Thanks
Sergio Ríos
-----Mensaje original-----
"Daniel B. Vigil" wrote:
Do you use database pooling? Or are your databse connections dynamic,
that is, you open a connection when you need to and then close it when
you are done? If you are using dynamic, I would move over to database
pooling. Not only may this help your intermittent problem, you might
also see a speed boost (no open/close connection overhead).
Ben Ricker
Senior Web Administrator
US-Rx, inc.
> I ran into the same problem with Oracle, the solution was to create a lot of
>JServ's, I had 25 per instance and shut and startup each JServ every hour or so;
>depending on your load.
>
> ~dbv
>
> Sergio Ríos Mendoza wrote:
> > Hi !
> > My environment is as follows
> > Linux 6.2 Red Hat distribution running on a Dell box
> > Apache 1.3.12
> > Jserv latest version (1.1.1)
> > Sybase' JDBC configured and running
> > I already have running a little application which accesses Sybase's tables in
>order to get info about my company's suppliers.
> > It worked excellent at test time, even first weeks after we released that page.
> > But now, there is a problem.
> > My scenario is as follows: suppliers (whit login & password) can review their
>bills & account info by setting starting and ending dates.
> > When a supplier experiments with a large period, the query crashes, but it is not
>per communication with database, it is per cummunication between server & client. I
>mean, my servlet request query through JDBC to the databse, Database answers with
>lots of info to my servlets and it tries to show this info. But Fails. After that the
>only option is to return to login screen and re-enter that info. What happens? my
>servlet tries to connect to the database but there is no communication.
> > If I review database logs, there is nothing strange. There are no locked
>processes, there are no hanged users.
> > If I review Apache's error_log there are a lot of entries that says "Exception
>creating the server socket: java.net.BindException: Address already in use"
> > As I don't know what is the meanning of that error, the solution is shutdown &
>restart Apache. After that, everiyhing is ok until next suppier trying to get too
>much information.
> > We think it is a problem between Jserv and JDBC because Apache serves ok HTML
>pages and any other non JDBC related servlets
> > And Sybase databse runs ok.
> > I really don't expect technical help, I expect any reference to similar cases with
>any solution.
> >
> > Thanks in advance
> > ------------------------------------------------
> > Sergio Ríos Mendoza
> > Departamento de Sistemas
> > Nuevos Proyectos
> > Comercial Mexicana
> > Tel: 53.71.71.50
> > Fax: 53.71.72.94
> > e-mail: [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
