Hi!
I'm not sure I follow.
The servlet looks like:
public class finder extends HttpServlet {
..
..
String _dbURL = "jdbc:interbase://localhost/nexttier://lb/data/lb.gdb";
String _InitialQuery = "select * from employee";
java.sql.Driver _Driver = null;
java.sql.Connection _Connection = null;
java.sql.Statement _Statement = null;
java.sql.ResultSet _ResultSet = null;
..
..
public void doit1(HttpServletRequest request,HttpServletResponse response,
String action)throws ServletException, IOException {
// Open _Connection with global params for each time I come here
// Some queries
// Write some results to response
// Close _Connection, _Resultset and all of the others so that they may be
opened again on next call to "service"
}
public void doit2(HttpServletRequest request,HttpServletResponse response,
String action)throws ServletException, IOException {
// Open _Connection with global params for each time I come here
// Some queries
// Write some results to response
// Close _Connection, _Resultset and all of the others so that they may be
opened again on next call to "service"
}
public void service(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException {
// get parameters that were sent with the request
// based on those parameters call one of my functions above
}
}
Can You explain how your idea would apply to this code?
Thanks for your time!
Regds
//OLAS
Wim Ceulemans skrev:
> Ola Samuelson wrote:
> >
> > Hi!
> > First, thanks to all that makes java/jserv work on linux.
> >
> > Hope this is right for this forum.
> >
> > I have following:
> > * x86 machines
> > * Interbase 5.6 on Redhat 6.1(2.2.13)/interserver/interclient 1.51JRE1.2
> >
> > * Interbase Interclient1.51 on Redhat 6.1(2.2.14)/Blackdown jdk
> > 1.2.2rc3/Sun
> > JSDK2.0/Jserv 1.1b3/Apache 1.3.9
> > * Loads of memory, SMP kernel on all machines
> > * Everything starts ok and seems to work. I can run all test servlets
> > and java
> > on all machines. All logs show a complete startup and
> > tells me that installation seems to be ok.
> >
> > Problems:
> > 1. Interclient(jdbc) reports "Broken pipe on connection ...". But ONLY
> > if
> > leaving the local machine(ie db url to other machine).
> > Strange thing is that if coming with jdbc from Windows to same
> > machine there
> > is NEVER a problem(Broken pipe).
> > So it's Interclient OR Java on linux, right? A failed call to
> > Interclient
> > screws it up.
> > 3. I use prepared statements and "normal" statements and after the
> > queries are
> > executed i use a while resultset.next to position first
> > to first record and then through out the set.
> > But sometimes this statement does not only produce false - it
> > actually
> > produces the error "Operation on closed resultset".
> > And I definitely does not close it at this point in execution. Why?
> > 4. Looking at processes I sometimes see something like: "Java
> > [defunct]". What
> > is this?
> > 5. Can anyone recommend a jdbc connection pool for servlets that is easy
> >
> > to use,
> > stable and FREE? Thanks!
>
> Just an idea. Can it be that your connection object or something else is
> garbage collected? Make sure your main program keeps a reference to your
> Connection object.
>
> Regards
> Wim
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
