Actually there is a record. If I will print the debug of
ResultSet rs = dtset.getDataSet(this.conn, " Select * from oss_users ", ""
, " order by id");
It will return me something like this.... So I am really lost where is the
problem;
There is no need to check the value of rs.last because it will return an
exception if no row has been fetch.
SQL Statement : Select * from oss_users order by id
Total record found :3
Name : ID VALUE : 1
Name : USERNAME VALUE : joseph
Name : PASSWORD VALUE : 1234
Name : FNAME VALUE : Joseph
Name : LNAME VALUE : Bautista
Name : MNANE VALUE : Dela Cruz
Name : EMAIL VALUE : [EMAIL PROTECTED]
Name : POSITION VALUE : Sr. ERTYUSD
Name : AGE VALUE : 27
Name : ID VALUE : 2
Name : USERNAME VALUE : josephcb
Name : PASSWORD VALUE : 1234
Name : FNAME VALUE : Joseph
Name : LNAME VALUE : Bautista
Name : MNANE VALUE : Dela Cruz
Name : EMAIL VALUE : [EMAIL PROTECTED]
Name : POSITION VALUE : Sr. Analyst
Name : AGE VALUE : 27
Name : ID VALUE : 3
Name : USERNAME VALUE : mrlynx
Name : PASSWORD VALUE : 1234
Name : FNAME VALUE : Joseph
Name : LNAME VALUE : Bautista
Name : MNANE VALUE : Dela Cruz
Name : EMAIL VALUE : [EMAIL PROTECTED]
Name : POSITION VALUE : Engineer
Name : AGE VALUE : 27
On Wed, Jul 2, 2008 at 11:11 AM, Eduardo Dela Rosa <
[EMAIL PROTECTED]> wrote:
> What you can do is to put debug statement, i.e.,
>
> boolean *isThereARow* = rs.last();
>
> *isThereARow* variable should be true if there are records from your
> query.
>
> If you are not getting any exceptions or stack trace, I would suppose that
> everything is okay EXCEPT that your QUERY is not returning any records at
> all.
>
> hth
> On Wed, Jul 2, 2008 at 4:39 PM, Joseph Bautista <
> [EMAIL PROTECTED]> wrote:
>
>> Hi,
>>
>> Thanks for the reply. I tried but to no avail (see below). Is there a
>> way for me to dump the value of ${dtSet} in jsp like a Data::Dumper in CGI?
>>
>> dataset dtset = new dataset();
>> ResultSet rs = dtset.getDataSet(this.conn, " Select * from oss_users
>> ", "" , " order by id");
>> ArrayList userList = new ArrayList();
>> users user = new users();
>> try {
>>
>> rs.last();
>> int last = rs.getRow();
>> int ctr = 0;
>> rs.first();
>>
>> for (ctr = 0; ctr < last; ctr++ ){
>> user.setId(rs.getString("ID"));
>> user.setPassword(rs.getString("PASSWORD"));
>> user.setUsername(rs.getString("USERNAME"));
>> user.setFname(rs.getString("FNAME"));
>> user.setMname(rs.getString("MNAME"));
>> user.setLname(rs.getString("LNAME"));
>> user.setEmail(rs.getString("EMAIL"));
>> user.setPosition(rs.getString("POSITION"));
>> user.setAge(rs.getString("AGE"));
>> userList.add(user);
>> rs.next();
>> }
>>
>> } catch (SQLException e){
>> e.printStackTrace();
>> }
>> sce.getServletContext().setAttribute("dtSet", userList);
>> }
>> Regards,
>> Joseph
>> On Wed, Jul 2, 2008 at 10:05 AM, Eduardo Dela Rosa <
>> [EMAIL PROTECTED]> wrote:
>>
>>> I think this line
>>>
>>> for (ctr = 0; ctr < *rs.getRow()*; ctr++ )
>>>
>>> will keep your code from loading contents of your ResultSet into your
>>> List.
>>>
>>> rs.getRow() returns the current row pointer (which is ZERO) and will
>>> never be greater than your counter.
>>>
>>> hth.
>>>
>>> On Wed, Jul 2, 2008 at 2:42 PM, Joseph Bautista <
>>> [EMAIL PROTECTED]> wrote:
>>>
>>>> Hello,
>>>>
>>>> Can someone shed light please?
>>>>
>>>> Regards
>>>>
>>>> On Fri, Jun 27, 2008 at 8:58 AM, Joseph Bautista <
>>>> [EMAIL PROTECTED]> wrote:
>>>>
>>>>> Hello Gurus,
>>>>>
>>>>> I've been fixing this "Nothing to display" problem for week now but
>>>>> to no avail. Can somebody please help?? See code below...
>>>>>
>>>>> public void contextInitialized(ServletContextEvent sce) {
>>>>>
>>>>> dataset dtset = new dataset();
>>>>> ResultSet rs = dtset.getDataSet(this.conn, " Select * from
>>>>> oss_users ", "" , " order by id"); This returning the list
>>>>> ArrayList userList = new ArrayList();
>>>>> users user = new users();
>>>>> try {
>>>>>
>>>>> rs.last();
>>>>> int ctr = 0;
>>>>> rs.first();
>>>>>
>>>>> for (ctr = 0; ctr < rs.getRow(); ctr++ ){
>>>>> user.setId(rs.getString("ID"));
>>>>> user.setPassword(rs.getString("PASSWORD"));
>>>>> user.setUsername(rs.getString("USERNAME"));
>>>>> user.setFname(rs.getString("FNAME"));
>>>>> user.setMname(rs.getString("MNAME"));
>>>>> user.setLname(rs.getString("LNAME"));
>>>>> user.setEmail(rs.getString("EMAIL"));
>>>>> user.setPosition(rs.getString("POSITION"));
>>>>> user.setAge(rs.getString("AGE"));
>>>>> userList.add(user);
>>>>> rs.next();
>>>>> }
>>>>>
>>>>> } catch (SQLException e){
>>>>> e.printStackTrace();
>>>>> }
>>>>> sce.getServletContext().setAttribute("dtSet", userList);
>>>>> }
>>>>> In my jsp:
>>>>>
>>>>> <display:table name="${dtSet}" export="true" id="row" class="dataTable"
>>>>> defaultsort="1" defaultorder="ascending"
>>>>> pagesize="16" cellspacing="0" >
>>>>> <display:column property="ID"
>>>>> title="ID" class="hidden" headerClass="hidden" media="html" />
>>>>> <display:column property="USERNAME"
>>>>> title="Username" sortable="true" class="username" headerClass="username"
>>>>> />
>>>>> <display:column property="PASSWORD"
>>>>> title="password" class="hidden" headerClass="hidden" media="html" />
>>>>> <display:column property="FNAME"
>>>>> title="First Name" sortable="true" class="fname" headerClass="fname" />
>>>>> <display:column property="LNAME"
>>>>> title="Last Name" sortable="true" class="lname" />
>>>>> <display:column property="MNAME"
>>>>> title="Middle Name" sortable="true" class="mname" headerClass="mname" />
>>>>> <display:column property="EMAIL"
>>>>> title="Email Address" sortable="true" class="email" headerClass="email" />
>>>>> <display:column property="POSITION"
>>>>> title="Position" sortable="false" class="position" headerClass="position"
>>>>> />
>>>>> <display:column property="AGE"
>>>>> title="AGE" sortable="false" class="age" headerClass="age" />
>>>>> </display:table>
>>>>> In my web.xml,
>>>>>
>>>>> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee";
>>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
>>>>> xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
>>>>> http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd";>
>>>>> <welcome-file-list>
>>>>> <welcome-file>users.jsp</welcome-file>
>>>>> </welcome-file-list>
>>>>> <listener>
>>>>> <listener-class>oss.service.dataloader</listener-class>
>>>>> </listener>
>>>>>
>>>>> </web-app>
>>>>>
>>>>> Regards,
>>>>>
>>>>> Joseph
>>>>> --
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Joseph DC Bautista
>>>>
>>>> Senior Activation Analyst - OSS
>>>> Tel +971 4 369 2063
>>>> Mobile +971 55 953 1596
>>>> www.du.ae
>>>>
>>>>
>>>>
>>>> -------------------------------------------------------------------------
>>>> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
>>>> Studies have shown that voting for your favorite open source project,
>>>> along with a healthy diet, reduces your potential for chronic lameness
>>>> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>>>> _______________________________________________
>>>> displaytag-user mailing list
>>>> displaytag-user@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/displaytag-user
>>>>
>>>>
>>>
>>>
>>> --
>>> Eduardo Dela Rosa
>>> -------------------------------------------------------------------------
>>> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
>>> Studies have shown that voting for your favorite open source project,
>>> along with a healthy diet, reduces your potential for chronic lameness
>>> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>>> _______________________________________________
>>> displaytag-user mailing list
>>> displaytag-user@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/displaytag-user
>>>
>>>
>>
>>
>> --
>> Joseph DC Bautista
>>
>> Senior Activation Analyst - OSS
>> Tel +971 4 369 2063
>> Mobile +971 55 953 1596
>> www.du.ae
>>
>>
>> -------------------------------------------------------------------------
>> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
>> Studies have shown that voting for your favorite open source project,
>> along with a healthy diet, reduces your potential for chronic lameness
>> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
>> _______________________________________________
>> displaytag-user mailing list
>> displaytag-user@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/displaytag-user
>>
>>
>
>
> --
> Eduardo Dela Rosa
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> displaytag-user mailing list
> displaytag-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/displaytag-user
>
>
--
Joseph DC Bautista
Senior Activation Analyst - OSS
Tel +971 4 369 2063
Mobile +971 55 953 1596
www.du.ae
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
