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

examples/sql/world.sql doesn't work for IgniteJdbcDriver

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.7
    • Fix Version/s: None
    • Component/s: examples
    • Labels:
      None
    • Ignite Flags:
      Docs Required

      Description

      ['/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/art-gg-pro/bin/sqlline.sh', '-d', 'org.apache.ignite.IgniteJdbcDriver', '--verbose=true', '--force=true', '--showWarnings=true', '--showNestedErrs=true', '-u', 'jdbc:ignite:cfg://cache=default:transactionsAllowed=true@/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/test_modules/test_sql_world/jdbc-memory-region.3/client.xml', '-f', '/var/lib/teamcity/data/work/dd4d79acf76cc870/i2test/var/suite-examples/test_modules/test_sql_world/jdbc-memory-region.3/sqlline_output.1.batch.txt']
      ...
      9/5330       CREATE TABLE City (
      ID INT,
      Name VARCHAR,
      CountryCode CHAR(3),
      District VARCHAR,
      Population INT,
      PRIMARY KEY (ID, CountryCode)
      ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City";
      No rows affected (0.118 seconds)
      10/5330
      11/5330      CREATE INDEX idx_country_code ON city (CountryCode);
      Error: Table doesn't exist: CITY (state=42000,code=3001)
      java.sql.SQLException: Table doesn't exist: CITY
      	at org.apache.ignite.internal.processors.query.IgniteSQLException.toJdbcException(IgniteSQLException.java:143)
      	at org.apache.ignite.internal.jdbc2.JdbcUtils.convertToSqlException(JdbcUtils.java:179)
      	at org.apache.ignite.internal.jdbc2.JdbcUtils.convertToSqlException(JdbcUtils.java:158)
      	at org.apache.ignite.internal.jdbc2.JdbcStatement.executeSingle(JdbcStatement.java:181)
      	at org.apache.ignite.internal.jdbc2.JdbcStatement.execute0(JdbcStatement.java:195)
      	at org.apache.ignite.internal.jdbc2.JdbcStatement.execute(JdbcStatement.java:303)
      	at sqlline.Commands.execute(Commands.java:823)
      	at sqlline.Commands.sql(Commands.java:733)
      	at sqlline.SqlLine.dispatch(SqlLine.java:795)
      	at sqlline.SqlLine.runCommands(SqlLine.java:1706)
      	at sqlline.Commands.run(Commands.java:1317)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
      	at sqlline.SqlLine.dispatch(SqlLine.java:791)
      	at sqlline.SqlLine.initArgs(SqlLine.java:595)
      	at sqlline.SqlLine.begin(SqlLine.java:643)
      	at sqlline.SqlLine.start(SqlLine.java:373)
      	at sqlline.SqlLine.main(SqlLine.java:265)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              skozlov Sergey Kozlov
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: