This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Help using CachedRowSet

 
Joe Wilkes
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am making a todo list for my java class and even the teacher can not help me so I though I would turn to the experts. I am using a cachedRowSet to make an array list to add my todo items. They include taskID(the primary key & auto increment), taskDesc(The todo text), DueDate(sql date format), & completed(boolean). I can get them to list everything except the taskID. It is always 0 and I can not figure out why. Here is some of my code, Here is the code part of the JSP.



Now, that will return everything in the database except the taskID.
Here is my java code


Thanks for any light you guys can shed. I need the ID so that I can link it to the delete ToDo button that will be added at a later time.
 
Joe Wilkes
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there something else I should try instead of this? Does anyone have any ideas at all?
 
Purushoth Thambu
Ranch Hand
Posts: 425
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you debug the code? What was the result of todoId if ResultSet is used?. You can try to populate the CachedRowSet object using populate(ResultSet) method (just to check).
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!