This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JSF and the fly likes DB operations and java.lang.RuntimeException: No columns in table: X Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSF
Bookmark "DB operations and java.lang.RuntimeException: No columns in table: X" Watch "DB operations and java.lang.RuntimeException: No columns in table: X" New topic
Author

DB operations and java.lang.RuntimeException: No columns in table: X

Kovan Akrei
Greenhorn

Joined: Aug 31, 2006
Posts: 1
Hi people
This is my first post here at saloon javaranch forums. I have had a problem for a couple of days now and I can't find a solutions to it. I'm trying to develop the user management section of a webapplication. I have a page for adding users and a page for view users. In the view page I use a table which is binded to a Cached Row Set through a data provider called userDataProvider. I have added a column of type checkbox to the table and command buttons for deleting, updating and so on. Everything seemed to be working fine before, but not any more. I do the update operation through JDBC and it works fine. Deleting and insertion is done through the data provider.

I think the problems accured after I had altered the db table a couple of time (added and removed columns), but I'm not sure. Now I cann't commit add nor delete rows. I get the following message:

java.lang.RuntimeException: No columns in table: user

I'm using Sun studio creator 2 update 1 and mysql 5 and I have used the tutorial in jsf-fieldguide on regard to db insert,update, delete and ckeckboxed inside tables.

Could somebody help me please. Many thanks in advance.


Kovan
[ August 31, 2006: Message edited by: Kovan Akrei ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: DB operations and java.lang.RuntimeException: No columns in table: X
 
Similar Threads
How to store data in an application which will be distributed
Enabling links according to user's authorization
help with methods in jsp
lost in Dynamic Authorization
JSP and Database tables