Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-7743

JDBC driver allows to connect to non existent schema

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3
    • Fix Version/s: None
    • Component/s: jdbc
    • Labels:

      Description

      Currently, if one creates a cache without DDL (via QueryEntity or indexedTypes), separate schema for this cache is created. Schema name is case sensitive, so to connect to it with JDBC driver, it's required to provide the name in quotes. Here is how it looks like in SqlLine:

      ./bin/sqlline.sh -u jdbc:ignite:thin://127.0.0.1/\"CacheQueryExamplePersons\"
      

      However, if name is provided without quotes, driver still connects, but then fails with a very unclear exception when a query is executed:

      ./bin/sqlline.sh -u jdbc:ignite:thin://127.0.0.1/CacheQueryExamplePersons

      This is a huge usability issue. We should disallow connections to schema that does not exist, throw exception in this case. Exception should provide proper explanation how to connect properly.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                vkulichenko Valentin Kulichenko
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: