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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.7
    • None
    • examples
    • None
    • 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

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

            Dates

              Created:
              Updated: