Andrey, My answers are inline...
On Tue, Jan 19, 2016 at 4:14 AM, Andrey Gura <ag...@gridgain.com> wrote: > 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. > If cache name is not provided in the URL, all cache names have to be provided in the query (except the default cache if it exists). If one of the names refers to non-existing cache, exception will be thrown. Default cache is not different from this standpoint - if the query contains a type without cache name specified and default cache doesn't exist, exception is thrown as well. > > 2. How user should refer to default cache in queries in case when some non > default cache name used as connection parameter? > This is something that is not possible now anyway, right? Actually, I've never seen an example of the default cache being used, especially if multiple caches are used. So I would not sacrifice usability to support this use case. If one wants to query the default cache, leave it blank in the URL and explicitly specify names of all other caches. > > > > 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 >
