New to NetBeans and Programming

[RSASKA]

Hello,

I am trying to learn Java programming within NetBeans IDE 6.8 Beta for work, and have been followign NetBeans tutorials. I am having difficulty with the following tutorial:

Working with the Java DB (Derby) Database
http://www.netbeans.org/kb/docs/ide/java-db.html

Everythings works till I try to insert information into table

INSERT INTO "NBUSER"."FRIENDS" VALUES (1,'Theodore','Bagwell','T-Bag','2004-12-25','tbag@foxriver.com')

I get the following error:

Error code -1, SQL state 42Y07: Schema 'NBUSER' does not exist


I tried uninstalling and reinstalling NetBeans and JavaDB. When I tried creating a database "contact" with nbuser as username and password, I get error so instead I created database "contacts" with nbuser as username and password. However when I go through tutorial and reach

INSERT INTO "NBUSER"."FRIENDS" VALUES (1,'Theodore','Bagwell','T-Bag','2004-12-25','tbag@foxriver.com')

I still get the same error:

Error code -1, SQL state 42Y07: Schema 'NBUSER' does not exist

Tried googling help, but in vain.


Please help.

V/r
RSA

[shags_j]

Change it to "APP"."FRIENDS" should work. I had the same problem.

Now I just can't get the new app window to find the table in the database.

[RSASKA]

Thanks shags_j, it now works!


Not sure of what you have been trying to get the new app window to view the table but just now, I was able to view data by right-clicking on Friends, select "View Data" then an SQL Editor appears with

select * from APP.FRIENDS

From there, the table displays.

[shags_j]

My problem is getting it to show in the new desktop application databse wizard. WHen I select the database it says the database has no tables. When I view it in the systems page I can view the table and the data in the table...