[ https://issues.apache.org/jira/browse/GEODE-3823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kirk Lund reassigned GEODE-3823: -------------------------------- Assignee: Kirk Lund > 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 > 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. > > AC: > 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)