@Inject public SqlServerClient(JdbcConnectorId connectorId, BaseJdbcConfig config) { super(connectorId, config, "\"", new DriverConnectionFactory(new SQLServerDriver(), config)); }
@Override public Connection openConnection(JDBCSchemaConfig config) throws SQLException { Properties info = new Properties(); String userName = config.getUsername(); String password = config.getPassword(); Optional.ofNullable(userName).map(value -> info.put("user", value)); Optional.ofNullable(password).map(value -> info.put("password", value)); return new com.microsoft.sqlserver.jdbc.SQLServerDriver() .connect(format("jdbc:sqlserver://%s:%s;databaseName=%s", config.getHost(), Optional.ofNullable(config.getPort()).orElse(1433), config.getDatabase()), info); } }, (jdbcSchemaConfig, table) -> ofNullable(jdbcSchemaConfig.getSchema())
SQLServerDataSource dataSource = new SQLServerDataSource(); dataSource.setUser("aUser"); dataSource.setPassword("password"); dataSource.setServerName("hostname"); dataSource.setDatabaseName("db");
@Override public DataSource dataSource() { SQLServerDataSource dataSource = new SQLServerDataSource(); dataSource.setURL( "jdbc:sqlserver://localhost;instance=SQLEXPRESS;" + "databaseName=high_performance_java_persistence;" ); dataSource.setUser("sa"); dataSource.setPassword("adm1n"); return dataSource; }
public void setPassword(String pwd) { this.password = pwd; xaDataSource.setPassword(pwd); }
public void setUserName(String user) { xaDataSource.setUser(user); }
public void setSelectMethod(String method) { xaDataSource.setSelectMethod(method); }
public void setServerName(String sn) { xaDataSource.setServerName(sn); }
public String getServerName() { return xaDataSource.getServerName(); }
public String getSelectMethod() { return xaDataSource.getSelectMethod(); }
public Boolean getSendStringParameters() { return xaDataSource.getSendStringParametersAsUnicode(); }
public void setDatabaseName(String dbname) { xaDataSource.setDatabaseName(dbname); }
public void setPortNumber(Integer pn) { xaDataSource.setPortNumber(pn == null ? 0 : pn); }
public String getUserName() { return xaDataSource.getUser(); }
SQLServerDataSource sql = new SQLServerDataSource(); sql.setServerName("Your SQL server name"); sql.setUser("sa"); sql.setPassword("your password"); sql.setPortNumber(1433); // Make sure this port is open sql.setDatabaseName("Your database name");
public void setPassword(String pwd) { this.password = pwd; xaDataSource.setPassword(pwd); }
public void setUserName(String user) { xaDataSource.setUser(user); }
public void setSelectMethod(String method) { xaDataSource.setSelectMethod(method); }
public void setServerName(String sn) { xaDataSource.setServerName(sn); }
public String getServerName() { return xaDataSource.getServerName(); }