Is your connection pool cacheing results - for example Poolman can cache
results
----- Original Message -----
From: "Brandon Goodin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 2:22 PM
Subject: Options population from a Database
> I am running into a bit of a problem and I wondered if others have had
this
> too. I am populating an options tag by creating a bean collection using
> values from a resultset and then calling that collection from the options
> tag using property="value" and labelProperty="label" which are of course
the
> getters in the the beans of the bean collection. My problem happens when I
> add to the database and the change should reflect in the results of the
bean
> collection refreshing the bean collection. It does not. I does however
> reflect the additional tables that have been written to the database when
I
> restart tomcat. I have encapsulated the code that creates the bean
> collection into a tag that handles the sql call, bean population and
> collection population.
> -------------------------------------------------------
> The code in the tag is as follows:
> -------------------------------------------------------
> package ws.phase.storeadmin.tags;
>
> import ws.phase.sql.*;
> import ws.phase.beantools.*;
> import ws.phase.logging.*;
> import com.codestudio.sql.*;
> import java.sql.*;
> import javax.sql.*;
>
> import javax.servlet.jsp.*;
> import javax.servlet.jsp.tagext.*;
> import javax.servlet.*;
> import java.io.*;
> import java.util.*;
> /**
> *
> * @author Administrator
> * @version
> */
> public class CatOrderList extends TagSupport{
>
>
> public int doStartTag() throws JspTagException {
> return EVAL_BODY_INCLUDE;
> }
>
> public int doEndTag() throws JspTagException {
> try{
> String property;
> String value;
>
> Connection conn = null;
> Statement stmtread = null;
> String sql = "";
>
> sql = "SELECT NAME FROM CATEGORY";
> conn = ConnectionPool.getConnection();
> stmtread =
>
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ
> _ONLY);
> ResultSet rs = stmtread.executeQuery(sql);
> int count=0;
> ArrayList list = new ArrayList();
>
> while(rs.next()){
> count=count + 1;
> list.add(new
> LabelValueBean(String.valueOf(count),String.valueOf(count)));
> }
> count=count + 1;
> list.add(new
> LabelValueBean(String.valueOf(count),String.valueOf(count)));
> pageContext.setAttribute("catlist", list);
> conn.close();
>
> } catch (SQLException ex) {
> } catch (IOException ex) {
> }
>
> return EVAL_PAGE;
> }
> }
>
> -------------------------------------------------------
> The select and option tags are as follows
> -------------------------------------------------------
> <html:select property="type"><html:options collection="catlist"
> property="value" labelProperty="label" /></html:select>
>
> -------------------------------------------------------
> Problem recap
> -------------------------------------------------------
>
> - My page works great the first time it is called the select/option tag
> produces a drop down from the database results (which are just numbers
that
> define a display sequence for the addition of a category)
>
> - Once a category is added and I return to the add a category page the
drop
> sequence drop down does not reflect that an additional record has been
added
> and produces the same amout of numbers in the sequence dropdown
> (selec/options dropdown).
>
> -------------------------------------------------------
> Question
> -------------------------------------------------------
>
> If I call the population of the bean collection from the top of the jsp
page
> and make a call to the database then why doesn't it update the results of
my
> sequence options dropdown.
>
>
