Re: jsp optimization for db driver load and connection

[Mikolaj Rydzewski]

Miller, Steve wrote:

                Connection conn = ds.getConnection();
                Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
                ResultSet rs = stmt.executeQuery(query1);
                //....run iterator loop and display stuff
                ResultSet rs = stmt.executeQuery(query2);
                //....run iterator loop and display stuff
                .....
                .....

                rs.close();
                conn.close();

Why don't you use jakarta commons-dbutils? Very small library and makes direct JDBC coding piece of cake.

--
Mikolaj Rydzewski      <[EMAIL PROTECTED]>        http://ceti.pl/~miki/
                   PGP KeyID: 8b12ab02
There are three kinds of people: men, women and unix.

smime.p7s
Description: S/MIME Cryptographic Signature