MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setUser("scott"); dataSource.setPassword("tiger"); dataSource.setServerName("myDBHost.example.org");
dataSource.setSocketTimeout(CONNECT_TIMEOUT_MS); dataSource.setUser(config.getUser()); dataSource.setPassword(config.getPwd()); dataSource.setLoginTimeout(1);
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("host"); ds.setUser("user"); ds.setPassword("password"); JdbcTemplate jdbcTemplate = new JdbcTemplate(ds); BufferedReader in = new BufferedReader(new FileReader("script.sql")); LineNumberReader fileReader = new LineNumberReader(in); String query = JdbcTestUtils.readScript(fileReader);
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName("hostname"); ds.setUser("username"); ds.setPassword("password"); JdbcTemplate jdbcTemplate = new JdbcTemplate(ds); BufferedReader in = new BufferedReader(new FileReader("script.sql")); LineNumberReader fileReader = new LineNumberReader(in); String query = JdbcTestUtils.readScript(fileReader);
@Override public DataSource get() { MysqlDataSource mysqlds = new MysqlDataSource(); mysqlds.setUrl(prop.getProperty("urlConnection")); mysqlds.setUser(prop.getProperty("user")); mysqlds.setPassword(prop.getProperty("password")); return mysqlds; }
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setUser("scott"); dataSource.setPassword("tiger"); dataSource.setServerName("myDatabaseHost.example.org"); and then obtain connections from it, same as above: Connection conn = dataSource.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT ID FROM USERS"); ... rs.close(); stmt.close(); conn.close();
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setDatabaseName("xyz"); dataSource.setUser("xyz"); dataSource.setPassword("xyz"); dataSource.setServerName("xyz.yourdomain.com");
protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
/** * Connects to the DB and tracks if successful so upstream stuff can try to reconnect. */ protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName(serverName); ds.setDatabaseName(mydatabase); ds.setUser(username); ds.setPassword(password); 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); }
@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();
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();
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); }
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; }