[jira] [Commented] (CAMEL-4152) jdbc idempotent repository - table creation

["Christian Müller (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAMEL-4152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055153#comment-13055153 ] 

Christian Müller commented on CAMEL-4152:
-----------------------------------------

I'm not sure if we should do this.
I agree it would be convenient for our users, but it's not so easy to handle all the databases well (it's much more work for Camel than for the user).
To be consistent, we also have to improve the JdbcAggregationRepository.

Other thoughts?

Christian

> 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
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
>  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