DataBase Exception: No Suitable driver found

[M.Tariq]

I have recently switched from C# to Java that why I am very new to java programming. I am trying to write program to learn database connections in java but the I am getting following exceptions while executing my program.

No suitable driver found for jdbc:derby://localhost:1727/dtbs

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package javaconsole;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 *
 * @author Prince
 */
public class JavaConsole {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        String host="jdbc:derby://localhost:1727/dtbs";
        String user="root";
        String password="root";
        try{
            Connection cnn=DriverManager.getConnection(host,user,password);
            System.out.println("Connection Established Successfully!");
        }
        catch(SQLException se){
            System.out.println(se.getMessage());
        }
    }
}

I am using NetBeans IDE.

[Toll]

I don't use NetBeans, so I'm not sure if it's installed by default, but you probably have to download and install the Derby JDBC. A quick Google found this page: Derby JDBC driver

[quad64bit]

Toll is correct - no DB connectors come by default. Grab the jar file Tolls mentions, and add it to the Library section of the project properties. This references the libs you need for building and runtime. If you wish to deploy your app somewhere, you will need to bundle the jdbc and any other libs you use with the jar.

[M.Tariq]

NetBeans service browser show a data base (or data source as in C#) tree containing my database 'dtbs'. And the driver subtree contains a node named "MySQL Connector (J Driver)". Also in the NetBeans's plugin dialog box contains a plugin for JDB. So it seems that the base IDE it self contains the driver but still I did What you told to me. I downloaded the latest derby driver and included the jar file as well as the complete folder in the project properties but the result is same Exception.

[Tolls]

That's Netbeans, not your project.
Your project needs the driver as well.

[M.Tariq]

You mean some thing like this:

Well this is again not working. You can read the exception in output window in the

[Toll]

I think the Derby driver is called derbyclient.jar, not derby.jar. See if you've got a file like that to include.

[M.Tariq]

Yeah I think I am a step forward now! here is a new exception encountered!

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

[JosAH]

A DriverManager doesn't know where to look for jdbc drivers; those drivers have to register themselves at the manager; do something like this before you ask the DriverManager to hand you over a driver:

Class.forName("org.apache.derby.jdbc.<XXX>Driver");

where <XXX> is "Embedded" or "Client" depending on your needs.

kind regards,

Jos

[M.Tariq]

Sorry! I dont understand what you want to say. Can you please explain this in a bit detail. Actually I am new to java.

[Toll]

With that last error message, it seems the driver is working at least. One thing I noticed though: In your screenshot, the port is 1527. The error message says 1727. Make sure you're not using the wrong port.

[M.Tariq]

Yes that was my mistake! But Now I got the same error with the same port i.e. 1527.

[Tolls]

A DriverManager doesn't know where to look for jdbc drivers; those drivers have to register themselves at the manager; do something like this before you ask the DriverManager to hand you over a driver:

Class.forName("org.apache.derby.jdbc.<XXX>Driver");

That's no longer the case, not since 1.6.
They get registered automatically if they are JDBC4 compliant.

[JosAH]

That's no longer the case, not since 1.6.
They get registered automatically if they are JDBC4 compliant.

But how does a DriverManager know what driver to install? If a JDBC implementation has a DataSource available no DriverManager is needed, but otherwise I don't understand how it should be done ...

kind regards,

Jos

[Tolls]

From the DriverManager API:
"
The DriverManager methods getConnection and getDrivers have been enhanced to support the Java Standard Edition Service Provider mechanism. JDBC 4.0 Drivers must include the file META-INF/services/java.sql.Driver. This file contains the name of the JDBC drivers implementation of java.sql.Driver.
"
It basically trawls the classpath.

[JosAH]

Ah, of course; I should've known; thanks. That's the same mechanism they use for those ScriptEngines ...

kind regards.

Jos