public DataSource createDataSource() { ClientDataSource dataSource = new ClientDataSource(); dataSource.setServerName("localhost"); dataSource.setPortNumber(1527); dataSource.setDatabaseName("mytestdb"); dataSource.setUser("myusername"); dataSource.setPassword("mypasswd"); return dataSource; }
private void setProperties(ClientDataSource ds, Properties properties) throws SQLException { Properties props = (Properties) properties.clone(); String databaseName = (String) props.remove(DataSourceFactory.JDBC_DATABASE_NAME); if (databaseName != null) { ds.setDatabaseName(databaseName); } String createDatabase = (String) props.remove(ClientConnectionConstant.CREATE_DATABASE); ds.setCreateDatabase(createDatabase); String password = (String) props.remove(DataSourceFactory.JDBC_PASSWORD); ds.setPassword(password); String user = (String) props.remove(DataSourceFactory.JDBC_USER); ds.setUser(user); String host = (String) props.remove(DataSourceFactory.JDBC_SERVER_NAME); ds.setServerName(host == null ? "localhost" : host); String portNumber = (String) props.remove(DataSourceFactory.JDBC_PORT_NUMBER); ds.setPortNumber(portNumber != null ? Integer.parseInt(portNumber) : 1527); String url = (String) props.remove(DataSourceFactory.JDBC_URL); applyUrl(ds, url); if (!props.isEmpty()) { BeanConfig.configure(ds, props); } }
dataSource = new ClientDataSource(); dataSource.setCreateDatabase("create"); dataSource.setDatabaseName("target/beam"); dataSource.setServerName("localhost"); dataSource.setPortNumber(port);
private void applyUrl(ClientDataSource ds, String url) { if (url == null) { return; } if (!url.startsWith(DERBY_PREFIX)) { throw new IllegalArgumentException("The supplied URL is no derby url: " + url); } URI uri = URI.create(url.substring(5)); ds.setServerName(uri.getHost()); ds.setPortNumber(uri.getPort()); String suburl = uri.getPath(); if (suburl.startsWith("/")) { suburl = suburl.substring(1); } String[] parts = suburl.split(";"); String database = parts[0]; if (database != null) { ds.setDatabaseName(database); } String options = parts[1]; if (options.length() > 0) { ds.setConnectionAttributes(options); } }
/** * Set the name of the server to connect to. * * @param serverName the name of the server to connect to */ public void setServerName(String serverName) { ds.setServerName(serverName); }
/** * Set the database name. * * @param name the database name */ public void setDatabaseName(String name) { ds.setDatabaseName(name); }
/** * Set the port number to connect to. * * @param port the port number to connect to */ public void setPortNumber(Integer port) { ds.setPortNumber(port.intValue()); }
ClientDataSource ds = new ClientDataSource(); ... // set properties here Connection connection = dataSource.getConnection();
/** * Set the user name used establish the connection. * This value is used if no connection information is supplied by the application * when attempting to create a connection. * * @param user the user name used to establish the connection; may be null */ public void setUserName(String user) { ds.setUser(user); }
/** * Set the user password credential establish the connection. * This value is used if no connection information is supplied by the application * when attempting to create a connection. * * @param password the password credential used to establish the connection; may be null */ public void setPassword(String password) { ds.setPassword(password); }
+ DataSourceFactory.JDBC_DATABASE_NAME); datasource.setDatabaseName(databaseName); datasource.setPassword(password); datasource.setUser(user); datasource.setCreateDatabase(createDatabase); datasource.setServerName(serverName); final String portNumber = (String) props .remove(DataSourceFactory.JDBC_PORT_NUMBER); if (portNumber != null) { datasource.setPortNumber(Integer.parseInt(portNumber)); datasource.setPortNumber(ClientConnectionConstant.DEFAULT_PORT);
public final static void main(String[] args) throws Exception { ActiveMQConnectionFactory connectionFactory = new ActiveMQConnectionFactory("tcp://localhost:61616"); ClientDataSource dataSource = new ClientDataSource(); dataSource.setPortNumber(1527); dataSource.setServerName("localhost"); dataSource.setDatabaseName("test"); PipelineOptions options = PipelineOptionsFactory.fromArgs(args).create(); Pipeline pipeline = Pipeline.create(options); pipeline .apply(JmsIO.read().withConnectionFactory(connectionFactory).withQueue("BEAM")) .apply(ParDo.of(new DoFn<JmsRecord, String>() { @ProcessElement public void processElement(ProcessContext processContext) { JmsRecord element = processContext.element(); processContext.output(element.getPayload()); } })) .apply(Window.<String>into(FixedWindows.of(Duration.standardSeconds(30))) .triggering(AfterWatermark.pastEndOfWindow()) .withAllowedLateness(Duration.ZERO) .discardingFiredPanes()) .apply(JdbcIO.<String>write().withDataSourceConfiguration( JdbcIO.DataSourceConfiguration.create(dataSource)) .withStatement("insert into test values(?)") .withPreparedStatementSetter((element, statement) -> { statement.setString(1, element); })); pipeline.run(); }
/** * Default constructor for a Derby Client Local DataSource. */ public ClientLocalMCF() { super(new ClientDataSource(), new NoExceptionsAreFatalSorter(), false); ds = (ClientDataSource) super.dataSource; }
+ DataSourceFactory.JDBC_DATABASE_NAME); datasource.setDatabaseName(databaseName); datasource.setPassword(password); datasource.setUser(user); datasource.setCreateDatabase(createDatabase); datasource.setServerName(serverName); final String portNumber = (String) props .remove(DataSourceFactory.JDBC_PORT_NUMBER); if (portNumber != null) { datasource.setPortNumber(Integer.parseInt(portNumber)); datasource.setPortNumber(ClientConnectionConstant.DEFAULT_PORT);
@Override public DataSource createDataSource(Properties props) throws SQLException { ClientDataSource ds = new ClientDataSource(); setProperties(ds, props); return ds; }
"missing required property " + DataSourceFactory.JDBC_DATABASE_NAME); datasource.setDatabaseName(databaseName); datasource.setPassword(password); datasource.setUser(user); datasource.setCreateDatabase(createDatabase); datasource.setServerName(serverName); final String portNumber = (String) props .remove(DataSourceFactory.JDBC_PORT_NUMBER); if (portNumber != null) { datasource.setPortNumber(Integer.parseInt(portNumber)); } else { datasource.setPortNumber(ClientConnectionConstant.DEFAULT_PORT);