Expand|Select|Wrap|Line Numbers
- package assign21;
- import java.io.FileInputStream;
- import java.util.*;
- import java.sql.*;
- public class WithPropertyFile
- {
- String driver=null;
- String url = null;
- String username = null;
- String psword = null;
- String propFile="D:/Bansari_Trainee/bansari_assign/Assign 2/Assign 2.1/assign2.1/src/assign21/DataProperty.properties";
- public static String databaseInfo = "";
- public static Connection connect;
- public static ResultSet result;
- public static ResultSet result1;
- ResultSetMetaData rsMetadata;
- int iColumnCount;
- public static Statement statementObject;
- PropertyResourceBundle pBundle = null;
- public WithPropertyFile() {
- try{
- System.out.println("\n--Properties File Path is ----"+propFile);
- pBundle = new PropertyResourceBundle(new FileInputStream(propFile));
- databaseInfo = (pBundle.handleGetObject("POSTGRE")).toString();
- System.out.println("\nOpening database-------------\n");
- System.out.print(propFile);
- if (!databaseInfo.equals(null)){
- StringTokenizer st = new StringTokenizer(databaseInfo);
- driver = st.nextToken();
- System.out.println("\nDriver =>" + driver);
- url = st.nextToken();
- username = st.nextToken();
- psword = st.nextToken();
- System.out.println("\nurl = " + url + "\npassword = " + psword);
- }
- }
- catch(Exception e){e.printStackTrace();}
- }
- public WithPropertyFile(String propfile){
- propFile=propfile;
- new WithPropertyFile();
- }
- public void open()
- {
- try{
- Class.forName(driver);
- // create connection
- connect = DriverManager.getConnection(url,username,psword);
- statementObject = connect.createStatement();
- // result = statementObject.executeQuery("SELECT * FROM usermaster");
- System.out.println("Your Connection is Established...");
- }
- catch(Exception e)
- {
- e.printStackTrace();
- }
- }
- public void close()
- {
- try{
- connect.close();
- }
- catch(Exception e)
- {
- e.printStackTrace();
- }
- }
- }
- class DBConnection {
- public static void main(String args[]){
- System.out.println("-------- PostgreSQL JDBC Connection Testing ------------");
- // System.out.println(System.getProperty("user.dir"));
- try
- {
- System.out.println("hi");
- PropertyResourceBundle pBundle = null;
- //System.out.println("h32i");
- pBundle = new PropertyResourceBundle(new FileInputStream("D:/Bansari_Trainee/bansari_assign/Assign 2/Assign 2.1/assign2.1/src/assign21/DataProperty.properties"));
- //System.out.println("h32i");
- System.out.print(pBundle);
- String databaseInfo = (pBundle.handleGetObject("POSTGRE")).toString();
- if (!databaseInfo.equals(null))
- {
- WithPropertyFile dbConnect = new WithPropertyFile(pBundle.handleGetObject("POSTGRE").toString());
- dbConnect.open();
- //dbConnect.close();
- System.out.println("Database Connection is Established From Connection Class...");
- }
- else
- System.out.println("\tNo such database found in properties file");
- }
- catch(Exception e){
- e.printStackTrace();}
- }
- }
java.lang.NullPointerException
java.util.PropertyResourceBundle@3e25a5
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
/src/assign21/DataProperty.properties
at assign21.WithPropertyFile.open(WithPropertyFile.ja va:67)
at assign21.DBConnection.main(WithPropertyFile.java:1 18)
This is my proprty file::
POSTGRE org.postgresql.Driver jdbc:postgresql:postgres postgres root4site
Please help as early as possible.