Greetings,
We are using the dbConnectionBroker object from javaexchange.com
It works well, but we are getting rather slow response time.
If you are using this object, we were wondering ...
1) What do you have your minConns, maxConns, & maxConnTime set at?
We are using minConns=3, maxConns=5, maxConnTime=1.
2) How many hits-per-unitOfTime are you experiencing?
Are you providing inquiry&update services?
3) Do you close the result set & statement objects after each sql
request?
Below is how we are doing it ...
Connection myConnection = null;
Statement myStatement = null;
try {
myConnection = fswDbBroker.getConnection();
myStatement = myConnection.createStatement();
String mySql =
"select stock_order_id, ref_id, first_name, last_name " +
" from stock_order " +
" where order_stat = '" + orderStat + "' ";
ResultSet rset = myStatement.executeQuery (mySql);
while ( rset.next() ) {
orderId = rset.getString(1);
refId = rset.getString(2);
firstName = rset.getString(3);
lastName = rset.getString(4);
body.append("<tr>");
body.append("<td align='center'> <input type='radio'
name=item value='i" + orderId + "'> </td>");
body.append("<td align='center'> " + refId + " </td>");
body.append("<td align='left'> " + firstName + " " +
lastName + " </td>");
// ...
}
rset.close();
myStatement.close();
} catch ( java.sql.SQLException e ) {
} finally {
fswDbBroker.freeConnection(myConnection);
}
Thanks for the help.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
