ds.setURL("jdbc:mysql://localhost:3306/mydb"); ds.setUser("mydbuser"); ds.setPassword("mydbpass"); dataSources.put("jdbc/mydbname", ds);
public void setPassword(String pwd) { this.password = pwd; connectionPoolDataSource.setPassword(pwd); }
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); }
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; }
@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; }