SqlDialect jdbcDialect = JdbcSchema.createDialect(SqlDialectFactoryImpl.INSTANCE, ds); JdbcConvention jc = JdbcConvention.of(jdbcDialect, null, dataBaseType); JdbcSchema schema = new JdbcSchema(ds, jc.dialect, jc, null/*catalog */, null/*schema */);
public JdbcStoragePlugin(JdbcStorageConfig config, DrillbitContext context, String name) { super(context, name); this.config = config; BasicDataSource source = new BasicDataSource(); source.setDriverClassName(config.getDriver()); source.setUrl(config.getUrl()); if (config.getUsername() != null) { source.setUsername(config.getUsername()); } if (config.getPassword() != null) { source.setPassword(config.getPassword()); } this.source = source; this.dialect = JdbcSchema.createDialect(SqlDialectFactoryImpl.INSTANCE, source); this.convention = new DrillJdbcConvention(dialect, name); }
/** * Returns a suitable SQL dialect for the given data source. * * @param dataSource The data source * * @deprecated Use {@link #createDialect(SqlDialectFactory, DataSource)} instead */ @Deprecated // to be removed before 2.0 public static SqlDialect createDialect(DataSource dataSource) { return createDialect(SqlDialectFactoryImpl.INSTANCE, dataSource); }
/** * Returns a suitable SQL dialect for the given data source. * * @param dataSource The data source * * @deprecated Use {@link #createDialect(SqlDialectFactory, DataSource)} instead */ @Deprecated // to be removed before 2.0 public static SqlDialect createDialect(DataSource dataSource) { return createDialect(SqlDialectFactoryImpl.INSTANCE, dataSource); }
public static JdbcSchema create( SchemaPlus parentSchema, String name, DataSource dataSource, SqlDialectFactory dialectFactory, String catalog, String schema) { final Expression expression = Schemas.subSchemaExpression(parentSchema, name, JdbcSchema.class); final SqlDialect dialect = createDialect(dialectFactory, dataSource); final JdbcConvention convention = JdbcConvention.of(dialect, expression, name); return new JdbcSchema(dataSource, dialect, convention, catalog, schema); }
public static JdbcSchema create( SchemaPlus parentSchema, String name, DataSource dataSource, SqlDialectFactory dialectFactory, String catalog, String schema) { final Expression expression = Schemas.subSchemaExpression(parentSchema, name, JdbcSchema.class); final SqlDialect dialect = createDialect(dialectFactory, dataSource); final JdbcConvention convention = JdbcConvention.of(dialect, expression, name); return new JdbcSchema(dataSource, dialect, convention, catalog, schema); }