This Is My CODE::
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.
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();} } }
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.