This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
While working through the NetBeans tutorial, "Using Java Persistence API Within a Visual Web JSF Application," it is necessary to first create a users table in the Derby sample database. A program exception, "Result Set not open," is generated when the database Tables folder is refreshed after running the script to create and populate the table.
Correction version is NetBeans 6.5Beta. The following attachment contains the exception output and the detailed steps necessary to reproduce the problem.
Created attachment 67747 [details] Stack trace, steps to reproduce.
Thank you for the clear instructions to reproduce. Very helpful. An exception occurred for me to but somewhat different but related to some problem with the ResultSet. I'll attach the exception.
Created attachment 67762 [details] invalid cursor position
I tried the steps again today and could not reproduce, but I wonder if there was a related bug that just got fixed.
Roman, could you please try to reproduce also
Just to satisfy my own curiosity and confirm that the problem was not limited to my heavily abused work environment, I installed Java JDK 1.6.0_07 (32-bit) and the NetBeans 6.5 Beta to a machine running 64-bit Windows XP. This is a home machine that has otherwise nothing running on it except a mail client and a word processor. The steps previously posted to reproduce this problem were followed precisely, and thankfully for me anyway, the very same "ResultSet not open" exception occurred. The problem seems to be repeatable. The Derby server version for what it's worth is "Apache Derby Network Server - 10.2.2.1 - (538595) started and ready to accept connections on port 1527 at 2008-08-21 02:46:49.875 GMT" when started.
I wasn't able to reproduce this issue on my Mac OS X.
thanks Roman. It's possible a bug was fixed since beta but I'll need to try some more using the same environment as the reporter
Finally, the Result set exception occurred, but only when I tried to delete the USERS table after it was created. May be some race condition?
I tested using the latest trunk build and could not reproduce the exception, even when deleting the table. http://bits.netbeans.org/download/trunk/nightly/latest/bundles/netbeans-trunk-nightly-200808210201-java-windows.exe I'll ask to find out if any changes were made in the area where the exception occurred. Also, if the reporter could try the latest trunk build to see if the exception still occurs.
Created attachment 68071 [details] log file with exception
The development build NetBeans 6.5, 200808210102, was installed. The problem could not be reproduced after many attempts although it continues to exist in the 6.5 Beta version.
nthompson, thank you very much for trying out the latest nightly build. I'll mark this issue as fixed. If you run into this again you can reopen this issue. Thanks and sorry it wasn't fixed in beta