public static JdbcKeyValueService create(JdbcKeyValueConfiguration config) { JdbcDataSourceConfiguration dataSourceConfig = config.getDataSourceConfig(); SQLDialect sqlDialect = SQLDialect.valueOf(dataSourceConfig.getSqlDialect()); DataSource dataSource = dataSourceConfig.createDataSource(); Settings settings = new Settings();
@Override protected DSLContext create0() { SQLDialect dialect = SQLDialect.DEFAULT; try { dialect = SQLDialect.valueOf(getProperties().getProperty(P_DIALECT)); } catch (Exception ignore) {} // [#6493] Data types are better discovered from the family, not the dialect. This affects the XMLDatabase, // for instance. Other databases are currently not affected by the family / dialect distinction return DSL.using(dialect.family()); }
result.toDialect = SQLDialect.valueOf(args[++i]); continue argsLoop;
private void reloadContexts() throws IOException { SQLDialect dialect = SQLDialect.valueOf(this.conf.getString("sqlDialect")); BasicDataSource ds = new BasicDataSource(); ds.setUrl(new ObjectMapper() .readValue(conf.getJSONArray("address").toString(), List.class).get(0).toString()); ds.setDriverClassName(conf.getString("driver")); String user = conf.optString("user"); String password = conf.optString("password"); if (!user.isEmpty()) ds.setUsername(user); if (!password.isEmpty()) ds.setPassword(password); Settings settings = new Settings(); settings.setRenderNameStyle(RenderNameStyle.AS_IS); Configuration conf = new DefaultConfiguration().set(ds).set(dialect) .set(settings) .set(new DefaultExecuteListenerProvider(new TimingExecuterListener())); this.context = DSL.using(conf); }
@PostConstruct public void init() { String prop = "db." + name + ".database"; String database = ArchaiusUtil.getString(prop).get(); if (database == null) { throw new IllegalStateException("Failed to find config for [" + prop + "]"); } try { SQLDialect dialect = SQLDialect.valueOf(database.trim().toUpperCase()); set(dialect); } catch (IllegalArgumentException e) { throw new IllegalArgumentException("Invalid SQLDialect [" + database.toUpperCase() + "]", e); } if (connectionProvider == null) { set(new AutoCommitConnectionProvider(dataSource)); } else { set(connectionProvider); } settings.setRenderSchema(false); String renderNameStyle = ArchaiusUtil.getString("db." + name + "." + database + ".render.name.style").get(); if (renderNameStyle != null) { settings.setRenderNameStyle(RenderNameStyle.valueOf(renderNameStyle.trim().toUpperCase())); } set(settings); if (listeners != null && listeners.size() > 0) { settings().setExecuteLogging(false); set(DefaultExecuteListenerProvider.providers(listeners.toArray(new ExecuteListener[listeners.size()]))); } }
final SQLDialect sqlDialect = SQLDialect.valueOf(context.getString(CONF_SQL_DIALECT).toUpperCase(Locale.ENGLISH));
builder.sqlDialect(SQLDialect.valueOf(value.toUpperCase())); break;
recordTransformer = pr.getString("sqlStore.recordTransformer"); sqlDialect = SQLDialect.valueOf(SQLDialect.class, pr.getString("sqlStore.sqlDialect").toUpperCase());