Runtime errors while getting property file in netbeans 6.5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bansari
    New Member
    • Jul 2010
    • 20

    Runtime errors while getting property file in netbeans 6.5

    This Is My CODE::
    Code:
    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();}
          }
    
    }
    I m facing this runtime errorr::

    java.lang.NullP ointerException
    java.util.Prope rtyResourceBund le@3e25a5
    at java.lang.Class .forName0(Nativ e Method)
    at java.lang.Class .forName(Class. java:169)
    /src/assign21/DataProperty.pr operties
    at assign21.WithPr opertyFile.open (WithPropertyFi le.java:67)

    at assign21.DBConn ection.main(Wit hPropertyFile.j ava:118)

    This is my proprty file::

    POSTGRE org.postgresql. Driver jdbc:postgresql :postgres postgres root4site



    Please help as early as possible.
Working...