You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Irina Zaporozhtseva (JIRA)" <ji...@apache.org> on 2017/06/16 15:33:00 UTC

[jira] [Updated] (IGNITE-5525) C++ ODBC example fails

     [ https://issues.apache.org/jira/browse/IGNITE-5525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Irina Zaporozhtseva updated IGNITE-5525:
----------------------------------------
    Summary: C++ ODBC example fails  (was: C++ OBDC example fails)

> C++ ODBC example fails
> ----------------------
>
>                 Key: IGNITE-5525
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5525
>             Project: Ignite
>          Issue Type: Bug
>          Components: platforms
>    Affects Versions: 2.1
>            Reporter: Irina Zaporozhtseva
>
> C++ OBDC 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 ...



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)