aldettinger commented on code in PR #4751:
URL: https://github.com/apache/camel-quarkus/pull/4751#discussion_r1159871774
##########
integration-tests/jdbc/src/main/java/org/apache/camel/quarkus/component/jdbc/CamelResource.java:
##########
@@ -53,33 +62,23 @@ public class CamelResource {
@Inject
CamelContext context;
+ @ConfigProperty(name = "quarkus.datasource.cameldb.db-kind")
+ String dbKind;
+
@PostConstruct
void postConstruct() throws Exception {
- try (Connection con = dataSource.getConnection()) {
- try (Statement statement = con.createStatement()) {
- try {
- statement.execute("drop table camels");
- statement.execute("drop table camelsGenerated");
- } catch (Exception ignored) {
- }
- statement.execute("create table camels (id int primary key,
species varchar(255))");
- statement.execute("create table camelsGenerated (id int
primary key auto_increment, species varchar(255))");
- statement.execute("create table camelsProcessed (id int
primary key auto_increment, species varchar(255))");
- statement.execute("insert into camelsGenerated (species)
values ('Camelus status'), ('Camelus linus')");
- statement.execute("insert into camels (id, species) values (1,
'Camelus dromedarius')");
- statement.execute("insert into camels (id, species) values (2,
'Camelus bactrianus')");
- statement.execute("insert into camels (id, species) values (3,
'Camelus ferus')");
-
- context.getRouteController().startRoute("jdbc-poll");
- }
- }
+ runScripts("droptables.sql");
Review Comment:
Is it useful to open a connection on each runScripts call ? Maybe we could
pass the connection as argument to runScript ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
