What is this Exception i got and Help me out?

Question

package jdbc.examples;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class PropertiesDemo {
    private static Connection conn;
    private static Statement st;
    private static ResultSet rs;

    public static void main(String[] args) throws Exception{
        Properties p = new Properties();
        FileInputStream fis = new FileInputStream("db.properties");
        p.load(fis);
        String driver = (String)p.getProperty("driver");
        String url = (String)p.getProperty("url");
        String user = (String)p.getProperty("user");
        String pwd = (String)p.getProperty("pwd");

            Class.forName(driver);
            conn = DriverManager.getConnection(url, user, pwd);
            st = conn.createStatement();
            rs = st.executeQuery("select ename, sal, deptno from emp");

        while(rs.next()) {
            System.out.println(rs.getString(1)+"  "+rs.getDouble(2)+"  "+rs.getInt(3));
        }

        rs.close();
        st.close();
        conn.close();
    }

}

output:

Exception in thread "main" java.io.FileNotFoundException: db.properties (The system cannot find the file specified)     
at java.base/java.io.FileInputStream.open0(Native Method)   
at java.base/java.io.FileInputStream.open(Unknown Source)   
at java.base/java.io.FileInputStream.<init>(Unknown Source)     
at j

What? The error message says "The system cannot find the file specified" in this case "db.properties". The code says "new FileInputStream("db.properties")" - so there must be a file with that name; and `getProperty("driver")` with a key-value pair like "driver = ..." in the file — user85421, Mar 11 '19 at 18:38
Stackoverflow generally isn't for debugging help, please read [How To Ask](https://stackoverflow.com/help/how-to-ask) and [How to create an MCVE](https://stackoverflow.com/help/mcve) so you do not make the same mistakes in the future. — Mercury Platinum, Mar 11 '19 at 18:40

score 0 · Answer 1 · answered Mar 11 '19 at 18:41

0

File that you're trying to open doesn't exist.The line below is the cause of your problem. Most likely the file is in another folder or has different name, so i would check that first.

FileInputStream fis = new FileInputStream("db.properties");

answered Mar 11 '19 at 18:41

ferals

19
2

I saved that file in same folder and with same name – Rabindra nath Reddy Mar 11 '19 at 18:46
Try using absolute path to the file to check if the problem still occurs. – ferals Mar 11 '19 at 19:00

score 0 · Accepted Answer · answered Mar 11 '19 at 18:51

Like @Carlos & @PM77-1 mentioned the answer is straight forward "File is not found", In simpler term,

FileInputStream fis = new FileInputStream("db.properties");

The above line search for the file db.properties in the same folder of the java code but it is not found.

Solution : you may have to move the property file or you have to mention absolute/relative path

FileInputStream fis = new FileInputStream("c:\myFile\db.properties");

What is this Exception i got and Help me out?

2 Answers2