Not able to connect to a Derby database on the Services tab on Netbeans 6.8

[jaihind]

Hi All,

Whenever I try to connect to a Derby database through the embedded Derby driver on the Services tab of the Netbeans IDE, I get the following error:

"Unable to add conection. Cannot establish a connection to jdbc:derby:mydatabasename using org.apache.derby.jdbc.EmbeddedDriver (Database 'mydatabasename' not found.)."

I have ensured that the correct database location is specified in the "Java DB Properties" dialog box that is accessed by right-clicking the "Java DB" node under the Services tab.

I would be grateful for any help that you can offer in this regard.

Regards,
Dinesh Bajaj

[javydreamercsw]

Did you make sure the Java DB server is running? Services>Database>Java DB>Start Server

On Thu, Apr 8, 2010 at 4:51 AM, jaihind <address-removed ([email]address-removed[/email])> wrote:

[emiddio]

you connect to an existing database -- sounds like you have not created the database yet.

gary

[Javier.Ortiz]

Also you can also create it if not created using:

jdbc:derby:mydatabasename;create=true

Javier A. Ortiz Bultr

[jaihind]

Hi Folks,

Thanks to all of you for your replies.

The database is already created, and I am able to access it through my Java application without any problem. Also, I ensure to start the Java DB server prior to try connecting to the database through the Services tab.

If this may help to tell that the system is 64-bit. I have no issues connecting to the database through the Services tab on a 32-bit system.

Thanks again in anticipation of your further assistance.

[jaihind]

Never mind. I have managed to establish the connection to the database using the DB Network driver (though the Database server and the database are located on the same system.)

It is that the Netbeans can't establish the connection using the Embedded driver? If yes, then for educational purpose I would be interested in knowing why is it so.