Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void contextInitialized(ServletContextEvent sce) {
- Properties serverProp = new Properties();
- try {
- serverProp.load(Files.newInputStream(Paths.get("webapps/webapp-baza/WEB-INF/dbsettings.properties"),
- StandardOpenOption.READ));
- } catch (IOException e) {
- System.out.println("Invalid server.properties file or file path");
- System.exit(1);
- }
- String dbName = serverProp.getProperty("name");
- String host = serverProp.getProperty("host");
- String port = serverProp.getProperty("port");
- String user = serverProp.getProperty("user");
- String password = serverProp.getProperty("password");
- String connectionURL = "jdbc:derby://" + host + ":" + port + "/" + dbName + ";user=" + user + ";" + "password="
- + password;
- ComboPooledDataSource cpds = new ComboPooledDataSource();
- try {
- cpds.setDriverClass("org.apache.derby.jdbc.ClientDriver");
- } catch (PropertyVetoException e1) {
- throw new RuntimeException("Pogreška prilikom inicijalizacije poola.", e1);
- }
- cpds.setJdbcUrl(connectionURL);
- try {
- Connection con = cpds.getConnection();
- SQLConnectionProvider.setConnection(con);
- SQLDAO dao = (SQLDAO) DAOProvider.getDao();
- dao.checkTableExistence();
- } catch (Exception e) {
- throw new IllegalArgumentException(e.getMessage());
- } finally {
- SQLConnectionProvider.setConnection(null);
- }
- sce.getServletContext().setAttribute("hr.fer.zemris.dbpool", cpds);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement