Hi elizabath,
The error might be when u retrieve the rows from the table
I always get this type of error ...Whatever query u are running thru EJB try to run the query directly with DB ..if it works fine and then start debuggiing your EJBs..and see where this exception is thrown...But for sure this error is with respect to your DB..there is nothing wrong with your EJb.....if u are doing logging functnality...with DB ..see that all the fields are correctly populated....
still the problem is there and then let me know where this exception is thrown....If your are using VAJ..then try to debug with that...its really helpful with that
Deepak