[ https://issues.apache.org/jira/browse/GEODE-3823?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16257551#comment-16257551 ]
ASF subversion and git services commented on GEODE-3823: -------------------------------------------------------- Commit 69337aaa6bca5274cced16a4a776b6f04709b761 in geode's branch refs/heads/feature/GEODE-3781 from [~agingade] [ https://gitbox.apache.org/repos/asf?p=geode.git;h=69337aa ] 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 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. > > 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)