[jira] [Closed] (GEODE-4164) Setting specific pdx field to db column mapping all columns are required

["Anthony Baker (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GEODE-4164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anthony Baker closed GEODE-4164.
--------------------------------

> Setting specific pdx field to db column mapping all columns are required
> ------------------------------------------------------------------------
>
>                 Key: GEODE-4164
>                 URL: https://issues.apache.org/jira/browse/GEODE-4164
>             Project: Geode
>          Issue Type: Bug
>          Components: regions
>            Reporter: Fred Krone
>            Priority: Major
>
> For gfsh create jdbc-mapping and setting field-mapping did not seem to work. 
> Example: if I set 
> --field-mapping=age:name
> it should put the age into the name column of the table. But throws:
> Column name 'NAME' appears more than once times in the column list of an INSERT statement.
> It works fine if I set all the k,v like this:
> --field-mapping=age:age,id:name,name:id
> So either all the fields should be required and this should be noted in gfsh help (I actually think this is the least problematic but obviously the most verbose)
> or it should check for a set mapping when doing the insert statement and add in remaining values by default.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)