List of usage examples for org.apache.commons.dbcp2 BasicDataSource BasicDataSource
BasicDataSource
From source file:annis.administration.AdministrationDao.java
private BasicDataSource createDataSource(String host, String port, String database, String user, String password, boolean useSSL, String schema) { String url = "jdbc:postgresql://" + host + ":" + port + "/" + database; // DriverManagerDataSource is deprecated // return new DriverManagerDataSource("org.postgresql.Driver", url, user, password); BasicDataSource result = new BasicDataSource(); result.setUrl(url);/*from w w w . j a v a 2 s.c o m*/ if (useSSL) { result.setConnectionProperties("ssl=true"); } result.setUsername(user); result.setPassword(password); result.setValidationQuery("SELECT 1;"); result.setAccessToUnderlyingConnectionAllowed(true); if (schema == null) { schema = "public"; } result.setConnectionInitSqls(Arrays.asList("SET search_path TO \"$user\"," + schema)); result.setDriverClassName("org.postgresql.Driver"); return result; }
From source file:de.rwth.dbis.acis.activitytracker.service.ActivityTrackerService.java
private static DataSource setupDataSource(String dbUrl, String dbUserName, String dbPassword) { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl(dbUrl);/* w w w .j av a2s . c o m*/ dataSource.setUsername(dbUserName); dataSource.setPassword(dbPassword); dataSource.setValidationQuery("SELECT 1;"); dataSource.setTestOnBorrow(true); // test each connection when borrowing from the pool with the validation query dataSource.setMaxConnLifetimeMillis(1000 * 60 * 60); // max connection life time 1h. mysql drops connection after 8h. return dataSource; }
From source file:emma.Emma.java
/** * @param args the command line arguments *//* ww w .j a va 2 s . c om*/ public static void main(String[] args) { try { Measure.start(); // create dbs // memory d_m = new BasicDataSource(); d_m.setDriverClassName("org.hsqldb.jdbc.JDBCDriver"); d_m.setUrl("jdbc:hsqldb:mem:emma"); d_m.setUsername("sa"); d_m.setPassword(""); mem = d_m.getConnection(); s_m = mem.createStatement(); s_m.executeUpdate( "CREATE TABLE entries (entriesindex BIGINT, hash VARCHAR(42), filepath VARCHAR(255), name VARCHAR(255), alt VARCHAR(255), url VARCHAR(255), img VARCHAR(255), actors VARCHAR(2048), f_exists BOOLEAN, desc VARCHAR(2048));"); // persistent d_p = new BasicDataSource(); d_p.setDriverClassName("org.hsqldb.jdbc.JDBCDriver"); d_p.setUrl("jdbc:hsqldb:file:settings"); d_p.setUsername("sa"); d_p.setPassword(""); pers = d_p.getConnection(); s_p = pers.createStatement(); s_p.executeUpdate( "CREATE TABLE IF NOT EXISTS settings (settingsindex BIGINT, key VARCHAR(255), value VARCHAR(255));"); // default settings Settings.setOnce("communicate", "false"); try { String line; Process p = Runtime.getRuntime().exec("sleep 0"); try (BufferedReader input = new BufferedReader(new InputStreamReader(p.getInputStream()))) { while ((line = input.readLine()) != null) { System.out.println(line); } } int c = p.waitFor(); int a = 0; } catch (IOException | InterruptedException err) { //err.printStackTrace(); } /* try { Logger LOG = LoggerFactory.getLogger(Emma.class); org.apache.http.client.HttpClient httpClient = new SimpleHttpClientBuilder().build(); HttpTools httpTools = new HttpTools(httpClient); TmdbFind find = new TmdbFind("ca7d0fb887a7be06bfee3a557f6e2238", httpTools); FindResults result = find.find("tt0468569", ExternalSource.IMDB_ID, "de"); System.out.println(result.toString()); } catch (Exception e) { System.err.println(e.toString()); } */ // build image cache ImageCache.read(); // create http server InetSocketAddress addr = new InetSocketAddress(9980); HttpServer server = HttpServer.create(addr, 0); server.createContext("/", new FileHandler()); server.createContext("/select", new StorageHandler()); server.createContext("/insert", new StorageHandler()); server.createContext("/update", new StorageHandler()); server.createContext("/delete", new StorageHandler()); server.createContext("/config", new ConfigHandler()); server.createContext("/chat", new ChatHandler()); server.createContext("/misc", new MiscHandler()); server.setExecutor(Executors.newFixedThreadPool(12)); server.start(); debug(">" + Measure.resultMs()); } catch (SQLException | IOException e) { System.err.println(e.toString()); } finally { } }
From source file:common.SwingGUI01.java
private DataSource prepareDataSource() { Properties myconf = new Properties(); try {/* w ww .j a v a2 s .c om*/ myconf.load(Agency.class.getResourceAsStream("/myconf.properties")); } catch (IOException ex) { errorMessage = "Error opening properties file"; log.error(errorMessage, ex); showErrorDialog(errorMessage); } BasicDataSource ds = new BasicDataSource(); ds.setUrl(myconf.getProperty("jdbc.url")); ds.setUsername(myconf.getProperty("jdbc.user")); ds.setPassword(myconf.getProperty("jdbc.password")); return ds; }
From source file:net.sp1d.chym.loader.RootConfig.java
@Bean DataSource dataSource() {/* w ww . ja v a2 s . c o m*/ BasicDataSource ds = new BasicDataSource(); ds.setUrl(env.getProperty("db.conn.jdbcUrl")); ds.setUsername(env.getProperty("db.conn.user")); ds.setPassword(env.getProperty("db.conn.password")); ds.setDriverClassName(env.getProperty("db.conn.driverClass")); return ds; }
From source file:net.sp1d.chym.loader.RootConfigDev.java
@Bean DataSource dataSource() {//from w w w.j a va 2 s. c o m BasicDataSource ds = new BasicDataSource(); // ds.setDriverClassName("org.hsqldb.jdbc.JDBCDriver"); //// ds.setUrl("jdbc:hsqldb:mem:db"); // ds.setUrl("jdbc:hsqldb:file:db/db"); // ds.setUsername("SA"); // ds.setPassword("SA"); ds.setUrl(env.getProperty("db.conn.jdbcUrl")); ds.setUsername(env.getProperty("db.conn.user")); ds.setPassword(env.getProperty("db.conn.password")); ds.setDriverClassName(env.getProperty("db.conn.driverClass")); return ds; }
From source file:ninja.jooq.NinjaJooqLifecycle.java
/** * This method reads the configuration properties from * your application.conf file and configures jOOQ accordingly. * //from w w w .ja va2 s. c o m */ public final void startServer() { logger.info("Starting jOOQ Module."); // Setup basic parameters boolean renderSchema = ninjaProperties.getBooleanWithDefault(JOOQ_RENDER_SCHEMA, true); //renderMapping String renderNameStyleString = ninjaProperties.getWithDefault(JOOQ_RENDER_NAME_STYLE, "QUOTED"); RenderNameStyle renderNameStyle = RenderNameStyle.fromValue(renderNameStyleString); String renderKeywordStyleString = ninjaProperties.getWithDefault(JOOQ_RENDER_KEYWORD_STYLE, "LOWER"); RenderKeywordStyle renderKeywordStyle = RenderKeywordStyle.valueOf(renderKeywordStyleString); boolean renderFormatted = ninjaProperties.getBooleanWithDefault(JOOQ_RENDER_FORMATTED, false); String statementTypeString = ninjaProperties.getWithDefault(JOOQ_STATEMENT_TYPE, "PREPARED_STATEMENT"); StatementType statementType = StatementType.valueOf(statementTypeString); boolean executeLogging = ninjaProperties.getBooleanWithDefault(JOOQ_EXECUTE_LOGGING, true); // Execute listeners boolean executeWithOptimisticLocking = ninjaProperties .getBooleanWithDefault(JOOQ_EXECUTE_WITH_OPTIMISTIC_LOCKING, true); boolean attachRecords = ninjaProperties.getBooleanWithDefault(JOOQ_ATTACH_RECORDS, true); String sqlDialectString = ninjaProperties.getWithDefault(JOOQ_SQL_DIALECT, "DEFAULT"); SQLDialect sqlDialect = SQLDialect.valueOf(sqlDialectString); Settings settings = new Settings(); settings.setRenderSchema(renderSchema); settings.setRenderNameStyle(renderNameStyle); settings.setRenderKeywordStyle(renderKeywordStyle); settings.setRenderFormatted(renderFormatted); settings.setStatementType(statementType); settings.setExecuteLogging(executeLogging); settings.setExecuteWithOptimisticLocking(executeWithOptimisticLocking); settings.setAttachRecords(attachRecords); String connectionUrl = ninjaProperties.getOrDie(NinjaConstant.DB_CONNECTION_URL); String connectionUsername = ninjaProperties.getOrDie(NinjaConstant.DB_CONNECTION_USERNAME); String connectionPassword = ninjaProperties.getWithDefault(NinjaConstant.DB_CONNECTION_PASSWORD, ""); BasicDataSource connectionPool = new BasicDataSource(); connectionPool.setUrl(connectionUrl); connectionPool.setUsername(connectionUsername); connectionPool.setPassword(connectionPassword); Configuration configuration = new DefaultConfiguration(); configuration.set(sqlDialect); configuration.set(settings); configuration.set(connectionPool); dslContext = DSL.using(configuration); }
From source file:no.kantega.publishing.common.util.database.dbConnectionFactory.java
public static void loadConfiguration() { try {//from w ww .ja v a 2 s . c o m setConfiguration(); verifyCompleteDatabaseConfiguration(); DriverManagerDataSource rawDataSource = new DriverManagerDataSource(); rawDataSource.setDriverClassName(dbDriver); rawDataSource.setUrl(dbUrl); if (!dbNTMLAuthentication) { rawDataSource.setUsername(dbUsername); rawDataSource.setPassword(dbPassword); } if (dbEnablePooling) { // Enable DBCP pooling BasicDataSource bds = new BasicDataSource(); bds.setMaxTotal(dbMaxConnections); bds.setMaxIdle(dbMaxIdleConnections); bds.setMinIdle(dbMinIdleConnections); if (dbMaxWait != -1) { bds.setMaxWaitMillis(1000 * dbMaxWait); } if (dbDefaultQueryTimeout != -1) { bds.setDefaultQueryTimeout(dbDefaultQueryTimeout); } bds.setDriverClassName(dbDriver); if (!dbNTMLAuthentication) { bds.setUsername(dbUsername); bds.setPassword(dbPassword); } bds.setUrl(dbUrl); if (dbUseTransactions) { bds.setDefaultTransactionIsolation(dbTransactionIsolationLevel); } if (dbCheckConnections) { // Gjr at connections frigjres ved lukking fra database/brannmur bds.setValidationQuery("SELECT max(ContentId) from content"); bds.setTimeBetweenEvictionRunsMillis(1000 * 60 * 2); bds.setMinEvictableIdleTimeMillis(1000 * 60 * 5); bds.setNumTestsPerEvictionRun(dbMaxConnections); if (dbRemoveAbandonedTimeout > 0) { bds.setRemoveAbandonedTimeout(dbRemoveAbandonedTimeout); bds.setLogAbandoned(true); } } ds = bds; } else { ds = rawDataSource; } // Use non-pooled datasource for table creation since validation query might fail ensureDatabaseExists(rawDataSource); if (shouldMigrateDatabase) { migrateDatabase(servletContext, rawDataSource); } if (dbUseTransactions) { log.info("Using transactions, database transaction isolation level set to " + dbTransactionIsolationLevel); } else { log.info("Not using transactions"); } if (debugConnections) { proxyDs = (DataSource) Proxy.newProxyInstance(DataSource.class.getClassLoader(), new Class[] { DataSource.class }, new DataSourceWrapper(ds)); } } catch (Exception e) { log.error("********* could not read aksess.conf **********", e); } }
From source file:olsps.com.healthsoftproject.config.ApplicationConfigClass.java
@Bean(name = "dataSource") public DataSource getDataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("org.apache.derby.jdbc.ClientDriver"); dataSource.setUrl("jdbc:derby://localhost:1527/medicalcenter"); dataSource.setUsername("yusufcassim"); dataSource.setPassword("yusufcassim"); return dataSource; }
From source file:org.adamkrajcik.winecellars.CellarManagerImplTest.java
private static DataSource prepareDataSource() { BasicDataSource bds = new BasicDataSource(); bds.setUrl("jdbc:derby:memory:cellarmanager-test;create=true"); return bds;/*from w ww . j a v a 2 s. com*/ }