Masaki Yamakawa created GEODE-8626:
--------------------------------------
Summary: Omitting field-mapping tag of cache.xml when using Simple
JDBC Connector
Key: GEODE-8626
URL: https://issues.apache.org/jira/browse/GEODE-8626
Project: Geode
Issue Type: Improvement
Components: jdbc
Reporter: Masaki Yamakawa
When configuring Simple JDBC Connector with gfsh, I don't need to create
field-mapping, the default field-mapping will be created from pdx and table
meta data.
On the other hand, when using cache.xml(cluster.xml), pdx and table meta data
cannot be used, and field-mapping must be described in cache.xml.
I would like to create field-mapping defaults based on pdx and table meta data
when using cache.xml.
If field-mapping is specified in cache.xml, the xml setting has priority, and
only if there are no field-mapping tags.
cache.xml will be as follows:
{code:java}
<region name="Region1" refid="REPLICATE">
<jdbc:mapping
data-source="TestDataSource"
table="employees"
pdx-name="org.apache.geode.connectors.jdbc.Employee"
ids="id">
<!-- no need to jdbc:field-mapping tag
<jdbc:field-mapping pdx-name="id" pdx-type="STRING" jdbc-name="id"
jdbc-type="VARCHAR" jdbc-nullable="false"/>
<jdbc:field-mapping pdx-name="name" pdx-type="STRING" jdbc-name="name"
jdbc-type="VARCHAR" jdbc-nullable="true"/>
<jdbc:field-mapping pdx-name="age" pdx-type="INT" jdbc-name="age"
jdbc-type="INTEGER" jdbc-nullable="true"/>
-->
</jdbc:mapping>
</region>
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
