3 Replies Latest reply on Aug 19, 2013 9:08 AM by Sanne Grinovero

    Need ISPN 5.1.6 sample code re: usel JdbcStringBasedCacheStore

    Ben Cotton Newbie

      I know ISPN 5.1.6 is no longer maintained, but I cannot upgrade past our current 5.1.6 installation.  Not a possibility at this time.

       

      That said, I am still hopeful someone might be able to provide me sample code equivalent to the following 5.2 sample code (taken from https://docs.jboss.org/author/display/ISPN52/Cache+Loaders+and+Stores) that will work with the ISPN 5.1.6 API:

       

       

      ConfigurationBuilder builder = new ConfigurationBuilder();

        builder.loaders().addLoader(JdbcStringBasedCacheStoreConfigurationBuilder.class)

           .fetchPersistentState(false)

           .ignoreModifications(false)

           .purgeOnStartup(false)

           .table()

              .dropOnExit(true)

              .createOnStart(true)

              .tableNamePrefix("ISPN_STRING_TABLE")

              .idColumnName("ID_COLUMN").idColumnType("VARCHAR(255)")

              .dataColumnName("DATA_COLUMN").dataColumnType("BINARY")

              .timestampColumnName("TIMESTAMP_COLUMN").timestampColumnType("BIGINT")

           .connectionPool()

              .connectionUrl("jdbc:h2:mem:infinispan_binary_based;DB_CLOSE_DELAY=-1")

              .username("sa")

              .driverClass("org.h2.Driver");

       

      The reason I can't use this code as written above is because 5.1.6 does not include JdbcStringBasedCacheStoreConfigurationBuilder.class    Can anyone provide me the basic equivalent of the exact spirit of the code above, but that will work with ISPN 5.1.6?