> Prepared statements in the jvm reuse the query objects but does anyone
know
> if postgresql itself is able to reuse queries?
>
Ever asked yourself if a pstgresql mailinglist could get you better
answers?!
-mw
_
Thanks,
Now I can also use 'prepared statement pooling'.
Use the pooling pattern and you can divide up ererything.
Prepared statements in the jvm reuse the query objects but does anyone know
if postgresql itself is able to reuse queries?
-Original Message-
From: William
A Suresh wrote:
> hi,thanks for the information. could u pls carify me further?i would like to
> know where this prepared statement residesduring the execution of a servlet.
> Is the compiled version ofthe stmt stored in the PreparedStatement obj or is
> it storedin the database server? In either
Paul Szynol wrote:
> hi, all,
>
> does anyone know if it is possible to invoke a servlet that will append,
> rather than replace, the current output of the page?
>
> thanks,
> paul
>
One way to do this would be to have your servlet use
RequestDispatcher.include() to get the contents of the page
hi, all,
does anyone know if it is possible to invoke a servlet that will append,
rather than replace, the current output of the page?
thanks,
paul
___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
//Say you have something like this
Statement statement=con.createStatement ();
for (n=1;n<=10;n++) {
statement.executeQuery("select * from -.");
}
//your query "select * from " is compiled 10 times and executed 10 times.
//Using a prepare statement:
PreparedStatement pre
hi all,
Jason Hunter says "a PreparedStatement is precompiled by the database
for faster execution". What exactly does this mean? Where does the
statement
reside during servlet execution? Code accessing a PreparedStatement
needs
to be synchronized for multiple users? Can anyone elaborate?
