Thread: jdbc and HSQL database

I am trying to connect to HSQL database using jdbc
I want to create a properties file with url, username, password and driver.
I am not sure what to put for the url and driver though, is it just the name of the driver or does it need the path?

Originally Posted by newbie

jbdc.url=jdbc:hsqldb:file:DBNAME
jbdc.username=sa
jbdc.password=
jbdc.driver=org.hsqldb.jdbcDriver

Something like this perhaps?
Be sure to read your laboratory documentation thoroughly, as they usually contain the answers.

I have used what you suggested, when trying to connect to the database however, i get this error.

Exception in thread "main" java.sql.SQLException: The url cannot be null
	at java.sql.DriverManager.getConnection(DriverManager.java:554)
	at java.sql.DriverManager.getConnection(DriverManager.java:185)
	at SimpleDataSource.getConnection(SimpleDataSource.java:48)
	at TestDB.main(TestDB.java:18)
Java Result: 1

The error seems to be coming from here "SimpleDataSource.getConnection(SimpleDataSource.j ava:48)"

    public static Connection getConnection() throws SQLException
    {
        return DriverManager.getConnection(url, username, password);
    }

The url, username and password are all read in from the properties file.

Also at java-forums.org

Originally Posted by copeg

See post 4 - and pay special attention to the word 'documentation'. A simple google search pulled up the following documentation page:
Chapter12.Properties
Have you tried what is described in that page and the API docs?

Edit: Thread moved from "Whats wrong with my code"

Thank you, I think I may have spotted my mistake after looking through that link. I will update here tomorrow when I have chance to edit and test the new code.

I still have no luck with establishing a connection.
All files are layed out below, I am following Horstmann's example to establish a connection.
database.properties

jbdc.url=jdbc:hsqldb:myHSQLDB;
jbdc.username=sa
jbdc.password=
jbdc.driver=org.hsqldb.jdbcDriver

SimpleDataSource to collect database properties from file

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;
 
public class SimpleDataSource 
{
    private static String url;
    private static String username;
    private static String password;
 
    public static void init(String database)
            throws IOException, ClassNotFoundException
    {
        Properties props = new Properties();
        FileInputStream in = new FileInputStream(database);
        props.load(in);
 
        String driver = props.getProperty("jdbc.driver");
        url = props.getProperty("jdbc.url");
        username = props.getProperty("jdbc.username");
        if(username == null) 
        {
            username = "";
        }
        password = props.getProperty("jdbc.password");
        if(password == null) 
        {
            password = "";
        }
 
 
    }
 
    public static Connection getConnection() throws SQLException
    {
        return DriverManager.getConnection(url, username, password);
    }
 
}

TestDB attempts to establish a connection to the database

import java.sql.Connection;
public class TestDB 
{
    public static void main(String[] args) throws Exception
    {
        Connection conn = SimpleDataSource.getConnection();
        conn.close();
    }
}

When i try to establish a connection i get this message.

Exception in thread "main" java.sql.SQLException: The url cannot be null
	at java.sql.DriverManager.getConnection(DriverManager.java:564)
	at java.sql.DriverManager.getConnection(DriverManager.java:221)
	at SimpleDataSource.getConnection(SimpleDataSource.java:48)
	at TestDB.main(TestDB.java:18)
Java Result: 1

It is a file, Yes i have also tried jbdc.url=jdbc:hsqldb:file:myHSQLDB
But this comes up with the same result. I have also tried using a full pathname but again this returns the same result. My understanding is that the database will be automatically created if it does not exist using the name myHSQLDB which is what i am trying to do. Assuming the rest is correct, shouldn't this work how i have described in the start of this post.