DaniWeb Forum Index > Web Development > JSP

load database info in a JSP using a config file

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2009

Posts: 2

Reputation: ash2401 is an unknown quantity at this point

Solved Threads: 0

ash2401

Offline

Newbie Poster

load database info in a JSP using a config file

Sep 22nd, 2009

I am new to JSPs. I would like to know how can I get the database info (drivername, url, username, password etc.) to load from a config file into the JSP rather than hard coding the values there.

Thank you everyone in advance.

•

Join Date: Dec 2007

Posts: 1,672

Reputation: javaAddict is a name known to all

Solved Threads: 225

javaAddict javaAddict is offline

Offline

Posting Virtuoso

Re: load database info in a JSP using a config file

Sep 23rd, 2009

Check the Read Me post at the top of the jsp forum:
JSP database connectivity according to Model View Controller (MVC) Model 2

Check out my New Bike at my Public Profile at the "About Me" tab

•

Join Date: Sep 2009

Posts: 2

Reputation: ash2401 is an unknown quantity at this point

Solved Threads: 0

ash2401

Offline

Newbie Poster

Re: load database info in a JSP using a config file

Sep 23rd, 2009

This is what I am trying to do

 Help with Code Tags 
 java Syntax (Toggle Plain Text) 
Properties properties = new Properties();
		try {
			properties.load(new FileInputStream("database.properties"));
		      } catch (IOException e) 
			 {
			 System.err.println(e.getMessage());
			 }
Properties properties = new Properties();
		try {
			properties.load(new FileInputStream("database.properties"));
		      } catch (IOException e) 
			 {
			 System.err.println(e.getMessage());
			 }

but this is apparently not retrieving any data from the properties file. Can someone tell me where exactly does the .properties file needs to be placed (the directory structure).

Last edited by peter_budo; Sep 25th, 2009 at 4:37 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Dec 2007

Posts: 2

Reputation: emnidhi is an unknown quantity at this point

Solved Threads: 0

emnidhi

Offline

Newbie Poster

Re: load database info in a JSP using a config file

Sep 25th, 2009

Step1: import java.sql.*;[/B]
Step 2: use ResourceBundle sql= ResourceBundle.getBundle("resource.propertiesFileName");
Step 3: use sql.getString("dbUrlStringInPropertiesFile") etc to get values of url, user and pwd.