> So my question is: why do I not see the new 54 table2 records that my > program says have been created? > > Perhaps you didn't COMMIT the 54 records in your test program?
Perhaps your test program is using a different Derby database than you're looking at with NetBeans? Perhaps your test program uses an in-memory database, and your records were committed to the in-memory database, then that database was lost when your program exited from its in-memory configuration? Perhaps your connection information is slightly different, so you are using two different SCHEMA settings in the two configurations, so that you have two different sets of tables, in two different SCHEMA? There are many possible ways in which one Derby configuration can be looking at a different set of database tables than another, all of which are intentional, but which are easy configurations to find yourself in accidentally. thanks, bryan