Thread: Yet another beginer help post...

I'm reading this book, Java 6 21 days. I have just gotten to the part where you make a JavaDB database.

I'm using netbeans 6.9 - this I think is part of the problem

Here's the problem: This program http://workbench.cadenhead.org/book/...residents.java Throws this error

Error -- java.sql.SQLException: Table/View 'CONTACTS' already exists in Schema 'APP'.

I realize that its not a java compiler error but an error with the database's creation. I Googled for the error the best i could, and all i could find was this

Whatever JPA provider you're using, I suspect that it is configured to generate and export the database objects corresponding to your mappings... and those already exist.
 
Depending on your configuration, on the JPA provider, on the exact message (EclipseLink logs such messages as warning AFAIK), this might be just normal or a "configuration mistake".
 
If you want more details, please tell us what provider you're using and show your persistence.xml.
 
Update: As suspected, you are using EclipseLink and these message are "normal" (they are logged as warning if you look closely at the message IIRC)

at
java.sql.SQLException: Table/View 'SEQUENCE' already exists in Schema 'ADMIN'. - Stack Overflow

What do i have to configure, or change to get this example program working?

The error states the table already exists, so my guess is you are trying to create a table or view but can't because it has already been created. So 1) drop the existing table/view (not good if it is a table and has important data in it) or 2) forget creating the table as it already exists, so just insert the data (not good if you do not know the schema). Hope this helps

Chances are you ran the program once, successfully, and the table was created. As noted by copeg, you can't create the same table in the same schema over and over again.

db

Oo, i see. You guys were correct.
Here i was thinking it was some NetBeans setting lol
I had mine edited to just do them in sequential order =( For some reason i had to delete the database and re run the program to get it running as you guys said.

thanks for the help guys!