Vladimir, Guess this has to be documented under Java Dev Guide section? https://apacheignite-sql.readme.io/docs/schema-and-indexes <https://apacheignite-sql.readme.io/docs/schema-and-indexes>
Do we need to do the same for .NET and C++? — Denis > Begin forwarded message: > > From: "Vladimir Ozerov (JIRA)" <j...@apache.org> > Subject: [jira] [Resolved] (IGNITE-6572) Allow multiple caches use one SQL > schema > Date: October 25, 2017 at 4:47:00 AM PDT > To: dma...@gridgain.com > > > [ > https://issues.apache.org/jira/browse/IGNITE-6572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel > ] > > Vladimir Ozerov resolved IGNITE-6572. > ------------------------------------- > Resolution: Fixed > >> Allow multiple caches use one SQL schema >> ---------------------------------------- >> >> Key: IGNITE-6572 >> URL: https://issues.apache.org/jira/browse/IGNITE-6572 >> Project: Ignite >> Issue Type: Improvement >> Components: sql >> Reporter: Denis Mekhanikov >> Assignee: Denis Mekhanikov >> Labels: usability >> Fix For: 2.4 >> >> >> When trying to create more than one cache with the same SQL schema name, the >> following exception is thrown: >> {noformat} >> Exception in thread "main" class org.apache.ignite.IgniteException: Schema >> already registered: TEST_SCHEMA >> at >> org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:957) >> at org.apache.ignite.Ignition.start(Ignition.java:350) >> at >> org.apache.ignite.examples.repro.schema.SchemaExampleNode.main(SchemaExampleNode.java:7) >> Caused by: class org.apache.ignite.IgniteCheckedException: Schema already >> registered: TEST_SCHEMA >> at >> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerCache(IgniteH2Indexing.java:2110) >> at >> org.apache.ignite.internal.processors.query.GridQueryProcessor.registerCache0(GridQueryProcessor.java:1393) >> at >> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart0(GridQueryProcessor.java:784) >> at >> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:845) >> at >> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1185) >> at >> org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1884) >> at >> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCachesOnLocalJoin(GridCacheProcessor.java:1755) >> at >> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:619) >> at >> org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1901) >> at >> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) >> at java.lang.Thread.run(Thread.java:748) >> {noformat} >> It should be allowed to share schema between caches. Currently it works for >> PUBLIC schema only. > > > > -- > This message was sent by Atlassian JIRA > (v6.4.14#64029)