Advertisement
Guest User

Untitled

a guest
Mar 11th, 2016
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. try {
  2. Class.forName("oracle.jdbc.OracleDriver");
  3.  
  4. InputStream isr = this.getClass().getResourceAsStream("/"+"dbConfig.properties");
  5. Properties prop = new Properties();
  6. if (isr != null){
  7. InputStreamReader isrProperties = new InputStreamReader(isr);
  8. prop.load(isrProperties);
  9. }
  10.  
  11. String dbURL = "jdbc:oracle:thin:@"+prop.getProperty("dbhost")+":"+prop.getProperty("dbport")+":"+prop.getProperty("dbname");
  12. System.out.println("TRACE : getdbConfig --> "+dbURL);
  13. String username = prop.getProperty("dbuser");
  14. String password = prop.getProperty("dbpass");
  15.  
  16. dbConn = DriverManager.getConnection(dbURL, username, password);
  17. if(dbConn != null){
  18. System.out.println("TRACE : Connected to "+dbURL);
  19. }
  20. }
  21. catch (SQLException ex) {
  22. System.out.println("Error Message : getConnection Failed --> "+ex.getSQLState());
  23. ex.printStackTrace();
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement