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

["Fred Krone (JIRA)" <ji...@apache.org>]

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

Fred Krone updated GEODE-3823:
------------------------------
    Description: 
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.
           
AC:
1) Should take a JDBC ResultSet and convert it to a PDX object.
2) Should log any errors on PDX conversion.
3) If can't convert (on error) then nothing is put into the Region.

  was:Implementation should take a result set and convert to PDX for the cache.


> Implement a 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
>
> 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.
>            
> AC:
> 1) Should take a JDBC ResultSet and convert it to a PDX object.
> 2) Should log any errors on PDX conversion.
> 3) If can't convert (on error) then nothing is put into the Region.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)