@Override public DataSource getDataSource() { MysqlConnectionPoolDataSource dataSource = new MysqlConnectionPoolDataSource();// do not use connection pool dataSource.setServerName(this.host); dataSource.setPort(this.port); dataSource.setDatabaseName(this.db); dataSource.setUser(this.user); dataSource.setPassword(this.password); dataSource.setAllowMultiQueries(true); return dataSource; }
public void setConnectTimeout(int timeoutMs) { connectionPoolDataSource.setConnectTimeout(timeoutMs); }
MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource(); ds.setURL("jdbc:mysql://localhost:3306/mydb"); ds.setUser("mydbuser"); ds.setPassword("mydbpass"); dataSources.put("jdbc/mydbname", ds);
private Connection createConnection() { try { MysqlConnectionPoolDataSource dataSource = new MysqlConnectionPoolDataSource(); dataSource.setUser(DB_USER); dataSource.setPassword(DB_PASSWORD); dataSource.setServerName(DB_ADRES); dataSource.setPort(DB_PORT); dataSource.setDatabaseName(DB_NAME); dataSource.setZeroDateTimeBehavior("convertToNull"); dataSource.setUseUnicode(true); return dataSource.getConnection(); } catch (SQLException e) { System.out.println(e.getMessage()); DiscordBot.LOGGER.error("Can't connect to the database! Make sure the database settings are corrent and the database server is running AND the database `" + DB_NAME + "` exists"); Launcher.stop(ExitCode.SHITTY_CONFIG, e); } return null; }
if (dataSource != null) { try { return dataSource.getPooledConnection(); MysqlConnectionPoolDataSource dataSource = new MysqlConnectionPoolDataSource(); dataSource.setUrl(jdbcUrl); dataSource.setConnectTimeout(getMaxConnectionWaitMillis()); dataSource.setInitialTimeout(getMaxConnectionWaitMillis()); dataSource.setDefaultFetchSize(defaultFetchSize); PooledConnection connection = dataSource.getPooledConnection();
@Override public ConnectionPoolDataSource newConnectionPoolDataSource() throws SQLException { return new MysqlConnectionPoolDataSource(); }
.setCommitMarkableResourceRecordDeleteBatchSize(3500); dataSource = new MysqlConnectionPoolDataSource(); .setUrl("jdbc:mysql://tywin.eng.hst.ams2.redhat.com:3306/jbossts?user=dtf11&password=dtf11¶noid=true"); recoveryDataSource = (DataSource) dataSource; } else if (dbType.equals("db2")) {
public void setPassword(String pwd) { this.password = pwd; connectionPoolDataSource.setPassword(pwd); }
public void setUserName(String user) { connectionPoolDataSource.setUser(user); }
public void setDatabaseName(String dbname) { connectionPoolDataSource.setDatabaseName(dbname); }
public void setServerName(String sn) { connectionPoolDataSource.setServerName(sn); }
public void setAllowMultiQueries(boolean property) { connectionPoolDataSource.setAllowMultiQueries(property); }
public static void main(String[] args) throws NamingException { // 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"); ic.createSubcontext("java:comp/env/jdbc"); MysqlConnectionPoolDataSource mysqlConnectionPoolDataSource = new MysqlConnectionPoolDataSource(); mysqlConnectionPoolDataSource.setUser("root"); mysqlConnectionPoolDataSource.setPassword("root"); mysqlConnectionPoolDataSource.setURL("jdbc:mysql://localhost:3306/test_my_database"); ic.bind("java:comp/env/jdbc/test", mysqlConnectionPoolDataSource); }
if (dataSource != null) { try { return dataSource.getPooledConnection(); MysqlConnectionPoolDataSource dataSource = new MysqlConnectionPoolDataSource(); dataSource.setUrl(jdbcUrl); dataSource.setConnectTimeout(getMaxConnectionWaitMillis()); dataSource.setInitialTimeout(getMaxConnectionWaitMillis()); dataSource.setDefaultFetchSize(defaultFetchSize); PooledConnection connection = dataSource.getPooledConnection();
/** * Default constructor for a MySQL Local DataSource. * */ public LocalMCF() { super(new MysqlConnectionPoolDataSource(), new MysqlExceptionSorter()); }
@Override public ConnectionPoolDataSource createConnectionPoolDataSource(Properties props) throws SQLException { MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource(); setProperties(ds, props); return ds; }
public static void main(String[] args) throws Exception{ LocateRegistry.createRegistry(1099); ConnectionPoolDataSource dataSource = createDataSource("root", ""); InitialContext context = createContext(); context.bind("MysqlMyDS", dataSource); System.out.println("context created!"); } private static InitialContext createContext() throws NamingException { Properties env = new Properties(); env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.rmi.registry.RegistryContextFactory"); env.put(Context.PROVIDER_URL, "rmi://localhost:1099"); InitialContext context = new InitialContext(env); return context; } private static ConnectionPoolDataSource createDataSource(String username, String password) { MysqlConnectionPoolDataSource dataSource = new MysqlConnectionPoolDataSource(); dataSource.setUser(username); dataSource.setPassword(password); dataSource.setServerName("localhost"); dataSource.setPort(3306); dataSource.setDatabaseName("test"); return dataSource; }
MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource(); ds.setURL("jdbc:mysql://localhost:3306/SomeDB"); ds.setUser("dbuser"); dataSources.put("jdbc/SomeDataSourceName", ds); MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource(); ds.setURL("jdbc:mysql://localhost:3306/OtherDB"); ds.setUser("dbuser");