----------------------------------------------------------------
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!!!
----------------------------------------------------------------
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:
> ----------------------------------------------------------------
> 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!!!
> ----------------------------------------------------------------
>
> 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]
--
Daniel B. Vigil
Principal Consultant
Oracle Service Industries
CRM Consulting Practice
--
--------------------------------------------------------------
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]
