Thanks *Pavel *for the reply our application is multi company application ,so each company instance have more than 100 tables.so that we are creating single cache for each company instance containing lot entity classes as well as it thirdparty enable with native persistence.
*You can manipulate SQL tables for existing caches with DML, *yes,we are using DML for if any new field added/removed to the entity/model class by using sqlline. For Updating New Model/Entity class is visible to sql query only problem to us now, i have tried like this also ,newly entity class record inserted into ignite cache(name company1),working for crud operations with key,for visible to sql api , tried to create table with same entity/model class name with specified cachename as company1 which is already created.but exception occured as table already exists java.sql.SQLException: Table already exists: CARSALES -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
