Val, I have a couple of questions:
1. What cache should be used by JDBC driver for query execution when no cache name in JDBC URL? I see only one option: any user cache. But it can bring some random behavior. Caches can be created/deleted dynamically and JDBC connection can refer to removed cache. 2. How user should refer to default cache in queries in case when some non default cache name used as connection parameter? On Tue, Jan 19, 2016 at 12:47 AM, Valentin Kulichenko < valentin.kuliche...@gmail.com> wrote: > I think we can just remove the requirement of having the default cache when > no cache name is provided in the JDBC URL. I don't see any reason to refuse > connection in this case, because if query doesn't properly specify cache > names for all participating types, the exception will be thrown anyway. > > Thoughts? > > -Val > > On Mon, Jan 18, 2016 at 6:35 AM, Andrey Gura <ag...@gridgain.com> wrote: > > > Cos, > > > > if cache name isn't specified in JDBC URL then default cache will be > used. > > > > If default cache isn't created then driver will throw exception with > > "Client is invalid. Probably cache name is wrong" message. > > > > You can use workaround and just create default cache. I understand that > > this solution is not what you want :) > > > > I don't have any idea about how to avoid using cache name because Ignite > > API requires named cache instance in order to execute query. > > > > > > > > On Sat, Jan 16, 2016 at 10:44 AM, Konstantin Boudnik <c...@apache.org> > > wrote: > > > > > Thanks Andrey. > > > > > > I think option one is a bad UX, cause creating an interpreter isn't > > > a) a simple button click (might be improved later on by Z. folks) > > > b) what if I have 25 different caches and the equal number of > > interpreters > > > and need to make a change to all of them? > > > > > > The second option sounds good, yet the interpreter still needs to have > a > > > particular cache name in the configuration, which now looks weird > because > > > I am > > > working with multiple caches at once. > > > > > > It is possible to avoid specifying the cache name all together, in > which > > > case > > > a user will have to simply go with what you call cross-cache queries? > > > > > > Cos > > > > > > On Thu, Jan 14, 2016 at 07:22PM, Andrey Gura wrote: > > > > Cos, > > > > > > > > you have two options in order to create different notebooks for > > separate > > > > caches: > > > > > > > > 1. You can create separate interpreter with cpecific configuration > for > > > each > > > > notebook. Then you can bind interpreters to notebooks. You can also > > bind > > > > many interpreters to oone notebook and use different interpreters in > > > > different paragraphs. > > > > > > > > 2. You can use cross-cache like queries with one interpreter. From > > docs: > > > > "In this case, cache names act as schema names in regular SQL. This > > means > > > > all caches can be referred by cache names in quotes." > > > > > > > > > > > -- > > Andrey Gura > > GridGain Systems, Inc. > > www.gridgain.com > > > -- Andrey Gura GridGain Systems, Inc. www.gridgain.com
