[
https://issues.apache.org/jira/browse/CAMEL-4152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055162#comment-13055162
]
Julian Cable commented on CAMEL-4152:
-------------------------------------
I think the minimum would be to detect the table not being there and raise an
exception that explained the problem and how to fix it.
I think an SQL94 compliant create (with primary key on the two main fields)
would be nice. If that fails, don't try anything clever, just raise a helpful
exception.
Either way works for me.
Julian
> jdbc idempotent repository - table creation
> -------------------------------------------
>
> Key: CAMEL-4152
> URL: https://issues.apache.org/jira/browse/CAMEL-4152
> Project: Camel
> Issue Type: Improvement
> Components: camel-sql
> Affects Versions: 2.7.1
> Environment: camels on any
> Reporter: Julian Cable
> Assignee: Christian Müller
> Labels: idempotent, jdbc
>
> It would be nice if the class caught the error if the table does not exist
> and tried to create it. If the create privilege is not available then a more
> informative exception can be raised to inform the user what needs creating.
> I also suggest the schema is changed so that the fields are lower case as
> different database engines handle case differently and use incompatible
> quoting for mixed case tables (Oracle, MySql and Postgres are all slightly
> different).
> Julian
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
