[jira] [Resolved] (GEODE-3823) Implement CacheLoader for JDBC to PDX

["Darrel Schneider (JIRA)" <ji...@apache.org>]

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

Darrel Schneider resolved GEODE-3823.
-------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.4.0

> 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
>             Fix For: 1.4.0
>
>
> 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)