connect to database use properties file in java web application

Question

I write a code to connect to database from servlet.I want to use properties.but it does not work.i think i my code or properties file has problem.please help me to correct it.

try
        {
            Properties prop=new Properties();
            FileInputStream in = new FileInputStream(System.getProperty("WEB-INF/dbConnection.properties"));
            prop.load(in);
            in.close();

            String drivers = prop.getProperty("jdbc.drivers");
            String connectionURL = prop.getProperty("jdbc.url");
            String username = prop.getProperty("jdbc.username");
            String password = prop.getProperty("jdbc.password");
            Class.forName(drivers);
            con=DriverManager.getConnection(connectionURL,username,password);
            System.out.println("Connection Successful");

..

and this is my properties file

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@192.168.101.84:1521:orcl
jdbc.username=user1
jdbc.password=123

Load the properties file using getResourceAsStream() . Check this. — AllTooSir
– AllTooSir, Commented Jul 23, 2013 at 7:51
use this InputStream inputStream = this.getClass().getClassLoader() .getResourceAsStream("dbConnection.properties"); — Veera
– Veera, Commented Jul 23, 2013 at 7:54

Mark M · Accepted Answer · 2013-07-23 08:44:29Z

1

Instead of

FileInputStream in = new FileInputStream(System.getProperty("WEB-INF/dbConnection.properties"));

use

InputStream in = getClass().getResourceAsStream("dbConnection.properties");

edited Jul 23, 2013 at 8:44

answered Jul 23, 2013 at 7:54

Mark M

1,60010 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

John Over a year ago

in both of instruction 'in' will be null !

John Over a year ago

i create a dbConnection.properties in WEB-INF and put my info. there.so when i debug my project when it Achieve to this command it puts nothing in "in" and give me exception

Mark M Over a year ago

Try removing WEB-INF/ and see what happens. Or try to find the actual path, I can't see your system so I can't help on that part.

nickRise Over a year ago

getClass().getClassLoader().getResourceAsStream("dbConnection.properties") should work

Suraj Rao · Accepted Answer · 2018-11-17 10:04:50Z

try  {
    FileReader reader = new FileReader("Full Path");
    Properties prop = new Properties();
    prop.load(reader);

    String drivers = prop.getProperty("jdbc.driverClassName");
    String connectionURL = prop.getProperty("jdbc.url");
    String username = prop.getProperty("jdbc.username");
    String password = prop.getProperty("jdbc.password");
    Class.forName(drivers);
    Connection con = DriverManager.getConnection(connectionURL, username, password);
    System.out.println("Connection Successful");
} catch (SQLException sqle) {
    // TODO: Add catch code
    sqle.printStackTrace();
} catch (FileNotFoundException fnfe) {
    // TODO: Add catch code
    fnfe.printStackTrace();
} catch (IOException ioe) {
    // TODO: Add catch code
    ioe.printStackTrace();
} catch (ClassNotFoundException cnfe) {
    // TODO: Add catch code
    cnfe.printStackTrace();
}catch (Exception e) {
    // TODO: Add catch code
    e.printStackTrace();
}

mel3kings · Accepted Answer · 2013-07-23 08:54:06Z

0

This part:

(System.getProperty("WEB-INF/dbConnection.properties"));

is actually referring to your classpath, try removing WEB-INF/ or just leave /, for checking root folder.

Or you can specify the fully qualified name, i.e : "C:\\foo\\test\\...\\dbConnection.properties" or "/app/blah/.../dbConnectionProperties"

answered Jul 23, 2013 at 8:54

mel3kings

9,4703 gold badges65 silver badges70 bronze badges

Comments

KingFeming · Accepted Answer · 2014-08-29 10:49:41Z

0

For Class name, in the properties file you have defined the driver as 'jdbc.driverClassName'

but when passing variable you just pass as 'jdbc.drivers'

answered Aug 29, 2014 at 10:49

KingFeming

1,09110 silver badges22 bronze badges

Collectives™ on Stack Overflow

connect to database use properties file in java web application

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related