Table/view Does Not Exist On Derby + Netbeans Connect

I am trying to make this connection with Derby in Netbeans for products registration. Connection with Database seems okay, but when I try to insert an object in a statement it retu

Solution 1:

You might be using two different Mercado databases. If you search your hard disk for a folder by the name 'Mercado', I believe you may find two of them:

1. When you connect with the Netbeans IDE, you are accessing the Derby Network Server, which has a "home" directory somewhere on your hard disk, and it is storing the database using the relative pathname Mercado.
2. When you run your standalone program, you are using the Embedded Driver, not the Client/Server Driver, so your standalone program is accessing the database using the relative pathname Mercado

Unless you have very carefully ensured that your standalone test program is running with its current working directory pointed at the same location that is being used by the Derby Network Server as its database home directory, then you have probably created two different Mercado databases and that is why your data is found in one of them and not the other.