Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

A Very little problem in h:dataTable implementation

 
Adnan Gondal
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all! I'm having a bean class employee having attributes id,name along with public getters and setters.

I'm using following bean for db connection and getting values from database table.

TableBean.java:



Following is jsf page:



Kindly reply.
Thanks in advance.
 
Stefan Evans
Bartender
Posts: 1721
10
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually I would say that your problem is in your data layer.

Question: What do you expect the ResultSet returned from this method to do?

Fun fact #1: You cannot access data in a result set that is closed
Fun fact #2: You close the results set in the finally statement of your method which returns the result set.

I suspect that might be the technical source of your problem.

In general, returning a ResultSet from a method is normally a bad idea.
The standard practice is to iterate of all the results in the result set, store them into a List of Beans, close the result set, and return the List of beans.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic