@Inject public SqlServerClient(JdbcConnectorId connectorId, BaseJdbcConfig config) { super(connectorId, config, "\"", new DriverConnectionFactory(new SQLServerDriver(), config)); }
private static ConnectionFactory connectionFactory(BaseJdbcConfig config, MySqlConfig mySqlConfig) throws SQLException { Properties connectionProperties = basicConnectionProperties(config); connectionProperties.setProperty("useInformationSchema", "true"); connectionProperties.setProperty("nullCatalogMeansCurrent", "false"); connectionProperties.setProperty("useUnicode", "true"); connectionProperties.setProperty("characterEncoding", "utf8"); connectionProperties.setProperty("tinyInt1isBit", "false"); if (mySqlConfig.isAutoReconnect()) { connectionProperties.setProperty("autoReconnect", String.valueOf(mySqlConfig.isAutoReconnect())); connectionProperties.setProperty("maxReconnects", String.valueOf(mySqlConfig.getMaxReconnects())); } if (mySqlConfig.getConnectionTimeout() != null) { connectionProperties.setProperty("connectTimeout", String.valueOf(mySqlConfig.getConnectionTimeout().toMillis())); } return new DriverConnectionFactory(new Driver(), config.getConnectionUrl(), connectionProperties); }
public DriverConnectionFactory(Driver driver, BaseJdbcConfig config) { this(driver, config.getConnectionUrl(), basicConnectionProperties(config)); }
@Inject public RedshiftClient(JdbcConnectorId connectorId, BaseJdbcConfig config) { super(connectorId, config, "\"", new DriverConnectionFactory(new Driver(), config)); }
private static ConnectionFactory connectionFactory(BaseJdbcConfig config, MySqlConfig mySqlConfig) throws SQLException { Properties connectionProperties = basicConnectionProperties(config); connectionProperties.setProperty("useInformationSchema", "true"); connectionProperties.setProperty("nullCatalogMeansCurrent", "false"); connectionProperties.setProperty("useUnicode", "true"); connectionProperties.setProperty("characterEncoding", "utf8"); connectionProperties.setProperty("tinyInt1isBit", "false"); if (mySqlConfig.isAutoReconnect()) { connectionProperties.setProperty("autoReconnect", String.valueOf(mySqlConfig.isAutoReconnect())); connectionProperties.setProperty("maxReconnects", String.valueOf(mySqlConfig.getMaxReconnects())); } if (mySqlConfig.getConnectionTimeout() != null) { connectionProperties.setProperty("connectTimeout", String.valueOf(mySqlConfig.getConnectionTimeout().toMillis())); } return new DriverConnectionFactory(new Driver(), config.getConnectionUrl(), connectionProperties); }
@Inject public PostgreSqlClient(JdbcConnectorId connectorId, BaseJdbcConfig config) { super(connectorId, config, "\"", new DriverConnectionFactory(new Driver(), config)); }
@Provides public JdbcClient provideJdbcClient(JdbcConnectorId id, BaseJdbcConfig config) { return new BaseJdbcClient(id, config, "\"", new DriverConnectionFactory(new Driver(), config)); }
public TestingDatabase() throws SQLException { String connectionUrl = "jdbc:h2:mem:test" + System.nanoTime(); jdbcClient = new BaseJdbcClient( new JdbcConnectorId(CONNECTOR_ID), new BaseJdbcConfig(), "\"", new DriverConnectionFactory(new Driver(), connectionUrl, new Properties())); connection = DriverManager.getConnection(connectionUrl); connection.createStatement().execute("CREATE SCHEMA example"); connection.createStatement().execute("CREATE TABLE example.numbers(text varchar primary key, text_short varchar(32), value bigint)"); connection.createStatement().execute("INSERT INTO example.numbers(text, text_short, value) VALUES " + "('one', 'one', 1)," + "('two', 'two', 2)," + "('three', 'three', 3)," + "('ten', 'ten', 10)," + "('eleven', 'eleven', 11)," + "('twelve', 'twelve', 12)" + ""); connection.createStatement().execute("CREATE TABLE example.view_source(id varchar primary key)"); connection.createStatement().execute("CREATE VIEW example.view AS SELECT id FROM example.view_source"); connection.createStatement().execute("CREATE SCHEMA tpch"); connection.createStatement().execute("CREATE TABLE tpch.orders(orderkey bigint primary key, custkey bigint)"); connection.createStatement().execute("CREATE TABLE tpch.lineitem(orderkey bigint primary key, partkey bigint)"); connection.createStatement().execute("CREATE SCHEMA exa_ple"); connection.createStatement().execute("CREATE TABLE exa_ple.num_ers(te_t varchar primary key, \"VA%UE\" bigint)"); connection.createStatement().execute("CREATE TABLE exa_ple.table_with_float_col(col1 bigint, col2 double, col3 float, col4 real)"); connection.commit(); }
@Inject public PostgreSqlClient(JdbcConnectorId connectorId, BaseJdbcConfig config) { super(connectorId, config, "\"", new DriverConnectionFactory(new Driver(), config)); }
@Provides public JdbcClient provideJdbcClient(JdbcConnectorId id, BaseJdbcConfig config) { return new BaseJdbcClient(id, config, "\"", new DriverConnectionFactory(new Driver(), config)); }
public TestingDatabase() throws SQLException { String connectionUrl = "jdbc:h2:mem:test" + System.nanoTime(); jdbcClient = new BaseJdbcClient( new JdbcConnectorId(CONNECTOR_ID), new BaseJdbcConfig(), "\"", new DriverConnectionFactory(new Driver(), connectionUrl, new Properties())); connection = DriverManager.getConnection(connectionUrl); connection.createStatement().execute("CREATE SCHEMA example"); connection.createStatement().execute("CREATE TABLE example.numbers(text varchar primary key, text_short varchar(32), value bigint)"); connection.createStatement().execute("INSERT INTO example.numbers(text, text_short, value) VALUES " + "('one', 'one', 1)," + "('two', 'two', 2)," + "('three', 'three', 3)," + "('ten', 'ten', 10)," + "('eleven', 'eleven', 11)," + "('twelve', 'twelve', 12)" + ""); connection.createStatement().execute("CREATE TABLE example.view_source(id varchar primary key)"); connection.createStatement().execute("CREATE VIEW example.view AS SELECT id FROM example.view_source"); connection.createStatement().execute("CREATE SCHEMA tpch"); connection.createStatement().execute("CREATE TABLE tpch.orders(orderkey bigint primary key, custkey bigint)"); connection.createStatement().execute("CREATE TABLE tpch.lineitem(orderkey bigint primary key, partkey bigint)"); connection.createStatement().execute("CREATE SCHEMA exa_ple"); connection.createStatement().execute("CREATE TABLE exa_ple.num_ers(te_t varchar primary key, \"VA%UE\" bigint)"); connection.createStatement().execute("CREATE TABLE exa_ple.table_with_float_col(col1 bigint, col2 double, col3 float, col4 real)"); connection.commit(); }