You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by "zhfeng (via GitHub)" <gi...@apache.org> on 2023/03/30 13:04:23 UTC

[GitHub] [camel-quarkus] zhfeng opened a new issue, #4723: Intermittent failure in Jdbc native tests

zhfeng opened a new issue, #4723:
URL: https://github.com/apache/camel-quarkus/issues/4723

   ```
   2023-03-30 11:32:18,113 WARN  [io.agr.pool] (Camel (camel-1) thread #1 - timer://interval-polling) Datasource 'camel-ds': JDBC resources leaked: 0 ResultSet(s) and 1 Statement(s)
   2023-03-30 11:32:18,116 ERROR [org.apa.cam.pro.err.DefaultErrorHandler] (Camel (camel-1) thread #1 - timer://interval-polling) Failed delivery for (MessageId: 4C4B23931637794-0000000000000000 on ExchangeId: 4C4B23931637794-0000000000000000). Exhausted after delivery attempt: 1 caught: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "CAMELSGENERATED" not found (this database is empty); SQL statement:
   select * from camelsGenerated order by id desc [42104-214]
   ```
   
   It looks like there is no data in the h2 database. I think  we could use [quarkus-flyway](https://quarkus.io/guides/flyway) to setup the database at the application startup time.


-- 
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: commits-unsubscribe@camel.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [camel-quarkus] jamesnetherton commented on issue #4723: Intermittent failure in Jdbc native tests

Posted by "jamesnetherton (via GitHub)" <gi...@apache.org>.
jamesnetherton commented on issue #4723:
URL: https://github.com/apache/camel-quarkus/issues/4723#issuecomment-1491850587

   https://github.com/apache/camel-quarkus/issues/4730


-- 
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: commits-unsubscribe@camel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [camel-quarkus] ldrozdo commented on issue #4723: Intermittent failure in Jdbc native tests

Posted by "ldrozdo (via GitHub)" <gi...@apache.org>.
ldrozdo commented on issue #4723:
URL: https://github.com/apache/camel-quarkus/issues/4723#issuecomment-1491503326

   Hi @zhfeng, looks like @jamesnetherton already solved it, thanks for that :) I'm working on testing with multiple JDBC providers, I can check the quarkus-flyway and try to set up the database with it, thanks for the tip. 


-- 
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: commits-unsubscribe@camel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [camel-quarkus] jamesnetherton closed issue #4723: Intermittent failure in Jdbc native tests

Posted by "jamesnetherton (via GitHub)" <gi...@apache.org>.
jamesnetherton closed issue #4723: Intermittent failure in Jdbc native tests
URL: https://github.com/apache/camel-quarkus/issues/4723


-- 
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: commits-unsubscribe@camel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [camel-quarkus] zhfeng commented on issue #4723: Intermittent failure in Jdbc native tests

Posted by "zhfeng (via GitHub)" <gi...@apache.org>.
zhfeng commented on issue #4723:
URL: https://github.com/apache/camel-quarkus/issues/4723#issuecomment-1490324456

   @ldrozdo can you take a look at this issue? I think we could move such SQLs to the quarkus-flyway migration files and it could resolve the failures in native tests. https://github.com/apache/camel-quarkus/blob/b5a0a66588db48aa5d5c8dcaf54cfc1214c9ec31/integration-tests/jdbc/src/main/java/org/apache/camel/quarkus/component/jdbc/CamelResource.java#L61-L72
   


-- 
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: commits-unsubscribe@camel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [camel-quarkus] zhfeng commented on issue #4723: Intermittent failure in Jdbc native tests

Posted by "zhfeng (via GitHub)" <gi...@apache.org>.
zhfeng commented on issue #4723:
URL: https://github.com/apache/camel-quarkus/issues/4723#issuecomment-1491771825

   Yeah, it looks good to me.


-- 
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: commits-unsubscribe@camel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org