You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@camel.apache.org by "Federico Mariani (Jira)" <ji...@apache.org> on 2025/10/02 14:25:00 UTC

[jira] [Created] (CAMEL-22488) Error when automatically creating JdbcIdempotent table

Federico Mariani created CAMEL-22488:
----------------------------------------

             Summary: Error when automatically creating JdbcIdempotent table
                 Key: CAMEL-22488
                 URL: https://issues.apache.org/jira/browse/CAMEL-22488
             Project: Camel
          Issue Type: Bug
            Reporter: Federico Mariani


The following error 
{code:java}
Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [CREATE TABLE camel_idempotent (processorName VARCHAR(255), messageId VARCHAR(100), createdAt TIMESTAMP, PRIMARY KEY (processorName, messageId))]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block
{code}
is thrown when automatically creating https://camel.apache.org/components/4.14.x/sql-component.html#_using_the_jdbc_based_idempotent_repository table.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)