MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setUser("scott"); dataSource.setPassword("tiger"); dataSource.setServerName("myDBHost.example.org");
private DataSource getRawMysqlDataSource(final String dbName, final String user, final String pwd) { final com.mysql.jdbc.jdbc2.optional.MysqlDataSource rawSource = new com.mysql.jdbc.jdbc2.optional.MysqlDataSource(); rawSource.setDatabaseName(dbName); rawSource.setUser(user); rawSource.setPassword(pwd); rawSource.setPort(3306); rawSource.setURL("jdbc:mysql://localhost:3306/killbill?createDatabaseIfNotExist=true&allowMultiQueries=true"); return rawSource; }
@Inject public MysqlDaoProvider(DbResourceGroupConfig config) { requireNonNull(config, "DbResourceGroupConfig is null"); MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(requireNonNull(config.getConfigDbUrl(), "resource-groups.config-db-url is null")); this.dao = Jdbi.create(dataSource) .installPlugin(new SqlObjectPlugin()) .onDemand(ResourceGroupsDao.class); }
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setConnectTimeout(CONNECT_TIMEOUT_MS); dataSource.setSocketTimeout(CONNECT_TIMEOUT_MS); dataSource.setUser(config.getUser()); dataSource.setPassword(config.getPwd()); dataSource.setLoginTimeout(1); dataSource.setServerName(ip.getIp()); dataSource.setPort(ip.getPort()); connection = dataSource.getConnection(); CONNECTION_POOL.put(key, connection);
public Storage(Logger logger, String host, int port, String database, boolean usessl, String user, String pass, String prefix) { this.logger = logger; this.prefix = prefix; this.dataSource = new MysqlDataSource(); this.dataSource.setUser(user); this.dataSource.setPassword(pass); this.dataSource.setServerName(host); this.dataSource.setPort(port); this.dataSource.setDatabaseName(database); this.dataSource.setUseSSL(usessl); }
@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; }
MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource(); ds.setURL("jdbc:mysql://localhost:3306/mydb"); ds.setUser("mydbuser"); ds.setPassword("mydbpass"); dataSources.put("jdbc/mydbname", ds);
@Override public DataSource newDataSource() throws SQLException { return new MysqlDataSource(); }
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //... MysqlDataSource mysql = (MysqlDataSource) context.lookup("jdbc/MySQLDataSource"); mysql.setRewriteBatchedStatements(true); Connection conn = mysql.getConnection();
@Override public XADataSource newXADataSource() throws SQLException { return new MysqlXADataSource(); } }
public void setResultSetSizeThreshold(int threshold) { xaDataSource.setResultSetSizeThreshold(threshold); } /**
public boolean getAllowMultiQueries() { return connectionPoolDataSource.getAllowMultiQueries(); }
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setDatabaseName("xyz"); dataSource.setUser("xyz"); dataSource.setPassword("xyz"); dataSource.setServerName("xyz.yourdomain.com");
@Override public void initialize() throws IOException { dataSource = new MysqlDataSource(); dataSource.setDatabaseName(databaseName); dataSource.setUser(username); dataSource.setPassword(password); dataSource.setPort(port); // See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html dataSource.setURL(jdbcConnectionString); }
MysqlDataSource ds = new MysqlDataSource(); ds.setDatabaseName("DATABASE"); ds.setUser("USERNAME"); ds.setPassword("USER PASSWORD"); ds.setServerName("localhost"); ds.setPort(3306); connection = ds.getConnection();
@Override public void initialize() throws IOException { dataSource = new MysqlDataSource(); dataSource.setDatabaseName(databaseName); dataSource.setUser(username); dataSource.setPassword(password); dataSource.setPort(port); // See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html dataSource.setURL(jdbcConnectionString); }
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName("localhost"); ds.setPort("3306"); ds.setDatabaseName("testdb"); ds.setUser("root"); ds.setPassword(""); Connection connection = ds.getConnection();
private DataSource getRawMysqlDataSource(final String dbName, final String user, final String pwd) { final com.mysql.jdbc.jdbc2.optional.MysqlDataSource rawSource = new com.mysql.jdbc.jdbc2.optional.MysqlDataSource(); rawSource.setDatabaseName(dbName); rawSource.setUser(user); rawSource.setPassword(pwd); rawSource.setPort(3306); rawSource.setURL("jdbc:mysql://localhost:3306/killbill?createDatabaseIfNotExist=true&allowMultiQueries=true"); return rawSource; }
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName(serverName); ds.setDatabaseName(mydatabase); ds.setUser(username); ds.setPassword(password); connection = ds.getConnection();
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setServerName("localhost"); dataSource.setDatabaseName("inventry"); dataSource.setPortNumber(3306); dataSource.setUser("root"); dataSource.setPassword(""); // blank password is a terrible idea Connection connection = dataSource.getConnection();