Skip to content

Instantly share code, notes, and snippets.

@diuis
Created November 21, 2017 15:44
Show Gist options
  • Save diuis/8b4c8784c844783eb4bc334cff617b73 to your computer and use it in GitHub Desktop.
Save diuis/8b4c8784c844783eb4bc334cff617b73 to your computer and use it in GitHub Desktop.
infinispan 9.1.3 sqlserver jdbc store config
ConfigurationBuilder builder = new ConfigurationBuilder();
builder.jmxStatistics()
.disable();
builder.clustering()
.cacheMode(CacheMode.LOCAL);
builder.persistence()
.passivation(false)
.addStore(JdbcStringBasedStoreConfigurationBuilder.class)
.dialect(DatabaseType.SQL_SERVER)
.fetchPersistentState(false)
.ignoreModifications(false)
.preload(false)
.shared(true)
.table()
.dropOnExit(false)
.createOnStart(true)
.tableNamePrefix("fai_infinispan_wizard-vehicle")
.idColumnName("ID_KEY")
.idColumnType("VARCHAR(255)")
.dataColumnName("DATA")
.dataColumnType("VARBINARY(MAX)")
.timestampColumnName("TIMESTAMP")
.timestampColumnType("VARCHAR(255)")
.connectionPool()
.connectionUrl(connectionUrl)
.username(username)
.driverClass(driverClass)
.password(password);
builder.validate();
final GlobalConfigurationBuilder global = GlobalConfigurationBuilder.defaultClusteredBuilder();
global.globalJmxStatistics()
.cacheManagerName("WizardVehicleCacheManager")
.allowDuplicateDomains(true);
global.transport()
.defaultTransport()
.addProperty("configurationFile", "default-configs/default-jgroups-udp.xml");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment