derby DB problem

[edi.gotieb]

Ive lately tried doing some stuff with Java data bases. im using derby.
i created a data base through NB and added a testing table.
i tried to create a connection to that DB through java code- but evrey time when it reaches the connection statement it throws an exception:

java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on
 port 1527 with message Connection refused: connect.

the weird thing is that if i connect to the db via the services window and then disconnect, before i start the java code- it works.
i did add the derby and derbyclient jar's to my libraries.
here is some of my code:

 Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/TestDB","edi123","edi123");
java.sql.Statement stmt =  con.createStatement();
try {
       ResultSet rs = stmt.executeQuery("SELECT * FROM App.TestCreate");
        while (rs.next()) {
        String n = rs.getString("Name");
        String p = rs.getString   ("UserName");
        System.out.println(n + "   " + p);
        }}
catch(Exception e) {
    e.printStackTrace();
    System.out.println(e.getMessage());
        System.exit(0);
} }}

does anybody have any idea as to what could be causing this weird problem?
thanks
Edi

[JosAH]

What happens when you try to open a connection to "jdbc:derby:<your database>"? i.e. you are using an embedded driver so there is no use to specifying a host and port number.

kind regards,

Jos

[edi.gotieb]

so there is no use to specifying a host and port umber.

what exactly does it mean that i dont need host and prot number? can i just put the directory straight in?

as i specified in my post when i try to connect i get the exception and the message posted above.

thanks for your reply.

Edi

[edi.gotieb]

i just tried to run with your suggestion and it worked!
thanks a lot!
i'de be glad if you can elaborate on what an embedded driver means?
thanks
Edi

[JosAH]

what exactly does it mean that i dont need host and prot number? can i just put the directory straight in?

as i specified in my post when i try to connect i get the exception and the message posted above.

thanks for your reply.

Edi

Just as I wrote: an embedded driver can only make connections to the db on the same machine so a url "jdbc:derby:TestDB" should be enough. Did you give it a try?

kind regards,

Jos

[edi.gotieb]

i did! and it works! thanks very much.

[edi.gotieb]

hi-
im having a different issue now.
when i creat a database through NB it automatically sets the URL and driver-
to the client driver- and the URL with the host and port.
NB manages to connect to the db when i just leave it but when i change the properties to the ones you showed me (i.e no host and port+ embeeded driver)
NB is unable to connect to the DB.
other then that- what effect does the driver choosing have on the db?
i mean: the data base is the same no matter what driver i use?
+ why is it unable to connect via the IDE but is able in the exact same fashion through the java code?

thanks
Edi

[edi.gotieb]

i solved the problem but would like answers to the questions about databases. :):D

[JosAH]

i solved the problem but would like answers to the questions about databases. :):D

This is ripped straight from the JavaDB documents (you have them installed too if you have Java 1.6 SE installed):

Embedded environment
An embedded environment is an environment in which only a single application can access a database at one time, and no network access occurs.

When an application starts an instance of Derby within its JVM, the application runs in an embedded environment. Loading the embedded driver starts Derby.

for the other driver this is what those docs have to say:

Client/server environment
A client/server environment is an environment in which multiple applications connect to Derby over the network.

Derby runs embedded in a server framework that allows multiple network connections. (The framework itself starts an instance of Derby and runs in an embedded environment. However, the client applications do not run in the embedded environment.)

You can also embed Derby in any Java server framework.

See the Java DB Server and Administration Guide for more information on how to run Derby on a server.

I don't know NetBeans so I don't know why it failed to configure your database driver.

kind regards,

Jos