RE: Sample configuration for one cache [name=KSDATA] and use it with JDBC (client do not find schema)
I had in fact two problems, the cache BEAN section was not in the good place in the XML (Ignite return no error) and the name of the cache was in lowercase in XML vs interpreted as uppercas in client JDBC.
De : Taras Ledkov [mailto:[hidden email]]
Envoyé : jeudi 6 décembre 2018 14:19 À :[hidden email] Objet : Re: Sample configuration for one cache [name=KSDATA] and use it with JDBC (client do not find schema)
DB object case sensitivity is the Ignite scourge.
When cache name is used as schema name (the schema doesn't define explicitly for a cache) the schema name is case sensitive.
In your case you can fix it:
- use schema name "ksdata", e.g. conn.setSchema("\"ksdata\"");
- or rename cache to "KSDATA" (use uppercase in config).
- or use CacheConfiguration#setSqlSchema (please read javadoc ).