ic.createSubcontext("java:comp"); ic.createSubcontext("java:comp/env"); ic.createSubcontext("java:comp/env/jdbc"); final PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setUrl("jdbc:postgresql://localhost:5432/mydb"); ds.setUser("postgres"); ds.setPassword("pg"); ic.bind("java:comp/env/jdbc/mydb", ds);
@Override public void initialize() throws IOException, SQLException { super.initialize(); dataSource = new PGSimpleDataSource(); ((PGSimpleDataSource) dataSource).setDatabaseName(databaseName); ((PGSimpleDataSource) dataSource).setUser(username); ((PGSimpleDataSource) dataSource).setPassword(password); ((PGSimpleDataSource) dataSource).setUrl(jdbcConnectionString); }
try { // Create initial context System.setProperty(Context.INITIAL_CONTEXT_FACTORY, "org.apache.naming.java.javaURLContextFactory"); System.setProperty(Context.URL_PKG_PREFIXES, "org.apache.naming"); InitialContext ic = new InitialContext(); ic.createSubcontext("java:"); ic.createSubcontext("java:comp"); ic.createSubcontext("java:comp/env"); // Construct DataSource for staging // Construct DataSource for wfms PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setUrl("jdbc:postgresql://localhost:5432/maintenanceDB");//you might get this from context ds.setUser("paul");//you might get this from context ds.setPassword("1234");//you might get this from context ic.bind("java:comp/env/maintenanceDB", wfmsds); } catch (NamingException ex) { ex.printStackTrace(); }
public static synchronized void INIT() { PGSimpleDataSource ds = new PGSimpleDataSource(); ds.setUrl(PG_URL); try (final Connection cnx = ds.getConnection(); final Statement st = cnx.createStatement()) { st.execute(TestSuite.getResourceAsString(PG_SQL)); } catch (Exception ex) { throw new RuntimeException(ex); } TestSuite.setupSessionFactoryBuilder(ds); } }
@BeforeClass public static void init() throws SQLException, IOException { PGSimpleDataSource pgDs = new PGSimpleDataSource(); pgDs.setUrl(PG_URL); sessionFactory = JsonHandlersTestApi.setUpDb(pgDs, PG_SQL); }