[ https://issues.jboss.org/browse/TEIIDDES-2812?page=com.atlassian.jira.plu... ] Van Halbert edited comment on TEIIDDES-2812 at 8/24/16 10:13 AM: ----------------------------------------------------------------- Need a couple additions to this, as these came about after the initial design work was done. - When creating materialized table, create a duplicate copy (for staging), but prefixing the name with "ST_" - need to create/add a medata extension property to the staging table. Also, as had been previous discussed, is the creation a connection profile for JDG. Settings: - JNDI Name - cacheTypeMap where the format is: cacheName:className[;pkFieldName[:cacheKeyJavaType]] cacheName = name of the primary cache in JDG className = pojo class name for the object stored in JDG (this would be class of the pojo created) pkFieldName = name of the attribute that is identified as the key value to the object stored in the JDG cache map (key=value) cacheKeyJavaType = [optional] java type of the pkFieldName when its java type of the key value is different from its pojo attribute java type - How to connect to JDG a. CacheJndiName - find cache using JNDI b. RemoteServerList - Server list, specify 1 or more host:port[,host:port] to connect to c. HotRodClientPropertiesFile - HotRod client properties file - Being using for materialization a. StagingCacheName - jdg cache used for staging b. AliasCacheName - JDG cache used for storing/tracking cache aliasing (can be shared for all JDG materializations) was (Author: van.halbert): Need a couple additions to this, as these came about after the initial design work was done. - When creating materialized table, create a duplicate copy (for staging), but prefixing the name with "ST_" - need to create/add a medata extension property to the staging table. Also, as had been previous discussed, is the creation a connection profile for JDG. Settings: - JNDI Name - cacheTypeMap where the format is: cacheName:className[;pkFieldName[:cacheKeyJavaType]] cacheName = name of the primary cache in JDG className = pojo class name for the object stored in JDG pkFieldName = name of the attribute that is identified as the key value to the object stored in the JDG cache map (key=value) cacheKeyJavaType = [optional] java type of the pkFieldName when its java type of the key value is different from its pojo attribute java type - How to connect to JDG a. CacheJndiName - find cache using JNDI b. RemoteServerList - Server list, specify 1 or more host:port[,host:port] to connect to c. HotRodClientPropertiesFile - HotRod client properties file - Being using for materialization a. StagingCacheName - jdg cache used for staging b. AliasCacheName - JDG cache used for storing/tracking cache aliasing (can be shared for all JDG materializations) -- This message was sent by Atlassian JIRA (v6.4.11#64026)