@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.setUser("scott"); dataSource.setPassword("tiger"); dataSource.setServerName("myDBHost.example.org");
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setConnectTimeout(CONNECT_TIMEOUT_MS); dataSource.setSocketTimeout(CONNECT_TIMEOUT_MS);
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; }
public static void main(String[] args) throws Exception { MysqlDataSource db = new MysqlDataSource(); db.setDatabaseName("test"); Connection conn = db.getConnection("test", "test"); ResultSet res = conn.prepareStatement("SELECT * FROM thing").executeQuery(); res.next(); System.out.println("Get a int as a string: " + res.getString("a_int")); }
@Override protected Connection createConnection() throws SQLException { final MysqlDataSource ds = new MysqlDataSource(); ds.setURL(dbUrl); Connection results = ds.getConnection(); results.setAutoCommit(false); return results; }
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);
@Override protected Connection createConnection() throws SQLException { final MysqlDataSource ds = new MysqlDataSource(); ds.setURL(dbUrl); Connection results = ds.getConnection(); results.setAutoCommit(false); return results; }
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();
@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); }
@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); }
@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.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.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); }
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); }
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; }