[
https://issues.apache.org/jira/browse/IGNITE-20862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17786056#comment-17786056
]
Sunil Chittumalla commented on IGNITE-20862:
--------------------------------------------
Ignite Configuration
{code:java}
@Bean(name = "igniteConfiguration")
public IgniteConfiguration igniteInstance() {
IgniteConfiguration icfg = new IgniteConfiguration();
// Setting some custom name for the node.
icfg.setIgniteInstanceName("ignite-1");
// Enabling peer-class loading feature.
icfg.setPeerClassLoadingEnabled(true);
icfg.setIgniteHome("C:/Sunil_New_WS/ignite");
icfg.setSqlConfiguration(new SqlConfiguration().setQueryEnginesConfiguration(
new CalciteQueryEngineConfiguration()
));
// Defining and creating a new cache to be used by Ignite Spring Data
// repository.
CacheConfiguration<String, NfIdDetails> ccfg = new
CacheConfiguration<>("NfIdDetailsCache");
//ccfg.setWriteBehindEnabled(true);
ccfg.setReadThrough(true);
//ccfg.setWriteThrough(true);
ccfg.setStatisticsEnabled(true);
ccfg.setOnheapCacheEnabled(true);
ccfg.setCacheMode(PARTITIONED);
ccfg.setRebalanceMode(CacheRebalanceMode.ASYNC);
ccfg.setBackups(1);
// Setting SQL schema for the cache.
ccfg.setIndexedTypes(String.class, NfIdDetails.class);
CacheJdbcPojoStoreFactory<String, NfIdDetails> f = new
CacheJdbcPojoStoreFactory<>();
f.setDataSourceBean("datasource");
f.setDialect(new OracleDialect());
JdbcType jdbcType = new JdbcType();
jdbcType.setCacheName("NfIdDetailsCache");
jdbcType.setKeyType(String.class);
jdbcType.setValueType(NfIdDetails.class);
jdbcType.setDatabaseTable("NF_AS_DETAIL_VIEW_NEW");
jdbcType.setDatabaseSchema("WFM_NF");
jdbcType.setKeyFields(new JdbcTypeField(Types.VARCHAR, "NF_ID",
String.class, "nfid"));
jdbcType.setValueFields(new JdbcTypeField(Types.VARCHAR, "NF_ID",
String.class, "nfid"),
new JdbcTypeField(Types.VARCHAR, "PROJECT_STATUS", String.class,
"projectstatus"),
new JdbcTypeField(Types.VARCHAR, "PROJECT_NAME", String.class,
"projectname"),
new JdbcTypeField(Types.VARCHAR, "NF_NTWK_SERVICE_TYPE_NAME",
String.class, "nfntwkprojecttypename"),
new JdbcTypeField(Types.VARCHAR, "NF_NTWK_PROJECT_TYPE_NAME",
String.class, "nfntwkservicetypename"),
new JdbcTypeField(Types.VARCHAR, "NF_NTWK_ENG_DISCIPLINE_NAME",
String.class, "nfntwkengdisciplinename"),
new JdbcTypeField(Types.VARCHAR, "NF_NTWK_ACTIVITY_TYPE_NAME",
String.class, "nfntwkactivitypename"),
//new JdbcTypeField(Types.VARCHAR, "BONITA_CASE_ID", String.class,
"caseid"),
new JdbcTypeField(Types.VARCHAR, "CLLI", String.class, "clli"),
new JdbcTypeField(Types.VARCHAR, "CITY", String.class, "city"),
new JdbcTypeField(Types.VARCHAR, "STATE", String.class, "state"),
new JdbcTypeField(Types.VARCHAR, "JUSTIFICATION_COMMENTS",
String.class, "justificationcomments"),
new JdbcTypeField(Types.VARCHAR, "NF_CANCEL_COMMENTS", String.class,
"cancelcomments"),
new JdbcTypeField(Types.VARCHAR, "NF_PROJECT_ID", String.class,
"nfprojectid"),
new JdbcTypeField(Types.VARCHAR, "SITECODE", String.class, "sitecode"),
new JdbcTypeField(Types.VARCHAR, "CREATE_DATE", String.class,
"createdate"),
new JdbcTypeField(Types.VARCHAR, "COMPLETED_TIME", String.class,
"completedtime"),
new JdbcTypeField(Types.VARCHAR, "START_DATE", String.class,
"startdate"),
new JdbcTypeField(Types.VARCHAR, "DUE_DATE", String.class, "duedate"),
new JdbcTypeField(Types.VARCHAR, "NF_JOB_ID", String.class, "nfjobid"),
new JdbcTypeField(Types.VARCHAR, "NF_STATUS_NAME", String.class,
"nfstatusname"),
new JdbcTypeField(Types.VARCHAR, "ICON_TOOLTIP", String.class,
"tooltip"),
new JdbcTypeField(Types.VARCHAR, "ICON_FILE_NAME", String.class,
"filename"),
new JdbcTypeField(Types.VARCHAR, "VZID", String.class, "vzid"),
new JdbcTypeField(Types.VARCHAR, "CN", String.class, "createdBy"),
new JdbcTypeField(Types.VARCHAR, "NF_SYSTEM_NAME", String.class,
"systemname"),
new JdbcTypeField(Types.VARCHAR, "NF_COMPONENT_NAME", String.class,
"componentname"),
new JdbcTypeField(Types.VARCHAR, "NF_COMPONENT_VALUE", String.class,
"componentvalue"),
new JdbcTypeField(Types.VARCHAR, "NF_PHASE_NAME", String.class,
"phasename"),
new JdbcTypeField(Types.VARCHAR, "NF_NTWK_PROGRAM_NAME", String.class,
"programname"),
new JdbcTypeField(Types.VARCHAR, "TAG_NAMES", String.class,
"tagnames"),
new JdbcTypeField(Types.VARCHAR, "WFM_PROJECT_ID", String.class,
"projectid"),
new JdbcTypeField(Types.VARCHAR, "WFM_ICM_RFP_REVIEW", String.class,
"rfpreview"),
new JdbcTypeField(Types.VARCHAR, "CCP_CCR", String.class, "ccr"),
new JdbcTypeField(Types.VARCHAR, "CCP_TEO", String.class, "teo"),
new JdbcTypeField(Types.VARCHAR, "VBUILD_EWO", String.class, "ewo"),
new JdbcTypeField(Types.VARCHAR, "FUZE_ORDER_NUMBER", String.class,
"ordernumber"),
//new JdbcTypeField(Types.VARCHAR, "VBUILD_WORK_REQUEST",
String.class, "workrequest"),
//new JdbcTypeField(Types.VARCHAR, "VBUILD_WP", String.class, "wp"),
new JdbcTypeField(Types.VARCHAR, "METADATA_ATTRS", String.class,
"metadataattrs"),
new JdbcTypeField(Types.VARCHAR, "BGW_ORDER_NUMBER", String.class,
"provisioningorderid"),
new JdbcTypeField(Types.VARCHAR, "NAUTILUS_CIRCUIT_ID", String.class,
"circuitid"),
new JdbcTypeField(Types.VARCHAR, "CONSUMPTION_CIRCUIT_ID",
String.class, "consumptioncircuitid"),
new JdbcTypeField(Types.VARCHAR, "IEN_CIRCUIT_ID", String.class,
"iencircuitid"),
new JdbcTypeField(Types.VARCHAR, "ALT_CIRCUIT_ID", String.class,
"altcircuitid"),
new JdbcTypeField(Types.VARCHAR, "ROW_DETAILS", String.class,
"customcolumn"),
new JdbcTypeField(Types.VARCHAR, "ENG_DISCIPLINE_NAME", String.class,
"engservicecatrgory"),
new JdbcTypeField(Types.VARCHAR, "ENG_SERVICE_TYPE", String.class,
"requestservicetype")
);
f.setTypes(jdbcType);
ccfg.setCacheStoreFactory(f);
icfg.setCacheConfiguration(new CacheConfiguration[] {
ccfg
});
//Ignite ignite = Ignition.start(icfg);
return icfg;
}{code}
> Calcite engine 2.15.0 with JDK 17- Exceptions when loading cache and when
> querying cache
> ----------------------------------------------------------------------------------------
>
> Key: IGNITE-20862
> URL: https://issues.apache.org/jira/browse/IGNITE-20862
> Project: Ignite
> Issue Type: Improvement
> Reporter: Sunil Chittumalla
> Assignee: Aleksey Plekhanov
> Priority: Blocker
> Labels: calcite
> Fix For: 2.15
>
>
> Apache Calcite 2.15.0 with JDK 17
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
