[
https://issues.apache.org/jira/browse/GEODE-3823?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16269768#comment-16269768
]
ASF subversion and git services commented on GEODE-3823:
--------------------------------------------------------
Commit 4953c8f6f13b107a742fa58623b79503aa13e850 in geode's branch
refs/heads/feature/GEODE-3781 from [~agingade]
[ https://gitbox.apache.org/repos/asf?p=geode.git;h=4953c8f ]
GEODE-3781: add geode-connectors module
Introduce new PDX JDBC Connector Service
* GEODE-3782: implement JdbcWriter
* GEODE-3783: implement JdbcAsyncWriter
* GEODE-3823: implement JdbcLoader
> Implement CacheLoader for JDBC to PDX
> -------------------------------------
>
> Key: GEODE-3823
> URL: https://issues.apache.org/jira/browse/GEODE-3823
> Project: Geode
> Issue Type: Sub-task
> Components: regions
> Reporter: Fred Krone
> Assignee: Kirk Lund
>
> This is for a 'read through' to the DB scenario when the entry is not found
> in a Region. This implementation should take a result set and convert to PDX
> for the cache.
> Make a SQL statement to query by the key provided. dbName must match the
> Region name.
> Check each ResultSet field for type and convert. Create a PDXInstance insert
> values. Region can (should?) have its type set so we'll know what the type
> is.
>
> If the value is not in the cache it should take configured JDBC credentials
> and connect to DB
> Should log any connection error and retry x amount of times
> On connect should execute query using the provided key as UID
> On successful query should create PDX object, map JDBC values to PDX object,
> put PDX object in the cache, return value
> Should only return one value -- multiple values should be logged and error
> JDBC execution errors should be logged
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
