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

C++ ODBC example fails

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0
    • 2.1
    • odbc, platforms

    Description

      C++ ODBC example fails:

      >>> Cache ODBC example started.

      [15:12:08,620][SEVERE]sql-connector-#38%null%[OdbcRequestHandler] Failed to execute SQL query [reqId=1, req=OdbcQueryExecuteRequest [schema=PUBLIC, sqlQry=INSERT INTO Person (_key, orgId, firstName, lastName, resume, salary) VALUES (?, ?, ?, ?, ?, ?)�, args=[1, 1, John, Doe, Master Degree., 2200.0]]]
      class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query: INSERT INTO Person (_key, orgId, firstName, lastName, resume, salary) VALUES (?, ?, ?, ?, ?, ?)
      at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1293)
      at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1856)
      at org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1852)
      at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
      at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2293)
      at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1860)
      at org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.executeQuery(OdbcRequestHandler.java:177)
      at org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.handle(OdbcRequestHandler.java:116)
      at org.apache.ignite.internal.processors.odbc.SqlListenerNioListener.onMessage(SqlListenerNioListener.java:152)
      at org.apache.ignite.internal.processors.odbc.SqlListenerNioListener.onMessage(SqlListenerNioListener.java:44)
      at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
      at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
      at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
      at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
      at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      at java.lang.Thread.run(Thread.java:745)
      Caused by: org.h2.jdbc.JdbcSQLException: Table "PERSON" not found; SQL statement:
      INSERT INTO Person (_key, orgId, firstName, lastName, resume, salary) VALUES (?, ?, ?, ?, ?, ?) [42102-195]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
      at org.h2.message.DbException.get(DbException.java:179)
      at org.h2.message.DbException.get(DbException.java:155)
      at org.h2.command.Parser.readTableOrView(Parser.java:5506)
      at org.h2.command.Parser.readTableOrView(Parser.java:5483)
      at org.h2.command.Parser.parseInsert(Parser.java:1056)
      at org.h2.command.Parser.parsePrepared(Parser.java:416)
      at org.h2.command.Parser.parse(Parser.java:320)
      at org.h2.command.Parser.parse(Parser.java:292)
      at org.h2.command.Parser.prepareCommand(Parser.java:257)
      at org.h2.engine.Session.prepareLocal(Session.java:573)
      at org.h2.engine.Session.prepareCommand(Session.java:514)
      at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
      at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
      at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
      at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:398)
      at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1273)
      ... 17 more
      An error occurred: Failed to execute prepared statement: HY000: class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query: INSERT INTO Person (_key, orgId, firstName, lastName, resume, salary) VALUES (?, ?, ?, ?, ?, ?)

      >>> Example finished, press 'Enter' to exit ...

      Attachments

        Issue Links

          Activity

            People

              isapego Igor Sapego
              izaporozhtseva Irina Zaporozhtseva
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: