[Proxool-developer] Re: "get connection from pool on create statement" AND "return connection to pool when statement is closed"

[Mark <ma...@te...>]

thank you guys for your replies.  i have decided that we will just get a 
connection from the pool every page and after each page, close the 
connection to return it to the pool.  creating a shortcut will only 
complicate things in the future.  :-D

regards,
mark

>    Connection c = getConnection(); // Either using a wrapper or JDBC 
> direct
>    Statement s = c.prepareStatement(sql);
>    s.execute();
>    s.close();
>    c.close();
>
> (You would do smarter exception handling than that of course).
>
> Cheers,
> Bill
>
>
>
> --__--__--
>
> _______________________________________________
> Proxool-developer mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-developer
>
>
> End of Proxool-developer Digest