Help finding database.properties file in Eclipse

Hello,

I am using MySQL 5 and Eclipse 3.1 on OS X Tiger.

Created the following file (TestDB.java), in Eclipse:

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
 
/**
 *  This program tests that the database 
 *  and the JDBC driver are correctly
 *  configured.  
 */
 
public class TestDB
{
    public static void main (String args [])
    {
        try 
        {
            runTest();
            
        }
        
        catch (SQLException ex)
        {
            while (ex != null)
            {
                ex.printStackTrace();
                ex = ex.getNextException();
            }
        }
        
        catch (IOException e)
        {
            e.printStackTrace();
        }
    }
 
    /**
     *  Runs a test by creating a table, 
     *  adding a value, showing the 
     *  table's contents, and removing 
     *  table.
     */
    public static void runTest()
    throws SQLException, IOException
    {
        Connection conn = getConnection();
        
        try 
        {
            Statement stat = conn.createStatement();
            stat.execute("Create Table GREETINGS (Message CHAR(20))");
            stat.execute("INSERT INTO TABLE GREETINGS VALUES ('Hello, World')");
            
            ResultSet result = stat.executeQuery("SELECT * FROM GREETINGS");
            result.next();
            System.out.println(result.getString(1));
            stat.execute("DROP TABLE GREETINGS");
        }
        
        finally 
        {
            conn.close();
        }
    }
    
    /**
     *  Gets a connection from the properties file.
     *  @return the database connection
     */
    public static Connection getConnection()
    throws SQLException, IOException
    {
        Properties props = new Properties();
        FileInputStream in = new FileInputStream("database.properties");
        props.load(in);
        in.close();
        
        String drivers = props.getProperty("jdbc.drivers");
        if (drivers != null)
        {
            System.setProperty("jdbc.drivers", drivers);
        }
        
        String url = props.getProperty("jdbc.url");
        String username = props.getProperty("jdbc.username");
        String password = props.getProperty("jdbc.password");
        
        return DriverManager.getConnection(url, username, password);
    }
}

I also added a database.properties file (using Eclipse):

Now, when I right mouse clicked on my project and went to 'Java Build Path',
I added the following jar:

mysql-connector-java-3.1.12-bin.jar

When I tried to run the program using "Run As Java Application", I got the following exception in the Console:

java.io.FileNotFoundException: database.properties (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
at TestDB.getConnection(TestDB.java:78)
at TestDB.runTest(TestDB.java:50)
at TestDB.main(TestDB.java:22)

Why couldn't Eclipse detect this file? I created it in Eclipse, so I wonder why it couldn't find its location...

Many, many thanks!

That is strange.

Does the database.properties file reside in the project folder or the source folder

If it is the latter try moving it to the project folder.

A better solution would be to put it into your source folder and get your input stream using this.class.getResourceAsStream("/database.properties");

-Rajagopal