[
https://issues.apache.org/jira/browse/IGNITE-7248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16326947#comment-16326947
]
Taras Ledkov edited comment on IGNITE-7248 at 1/16/18 9:55 AM:
---------------------------------------------------------------
*Root cause* is wrong usage of the {{schemaName}} and {{cacheName}} at the
{{JdbcConnection#prepareNativeStatement}} in JDBC v2 (looks like it is the old
code when *schema == cacheName*)
Also please take a look at the test {{JdbcStreamingToPublicCacheTest}} to see
the wright way of the streaming to the table that is created by SQL. We have to
use separate connection. Also the JDBC connection with enabled streaming should
use ONLY for streaming INSERT.
was (Author: tledkov-gridgain):
Root cause is wrong usage of the {{schemaName}} and {{cacheName}} at the
{{JdbcConnection#prepareNativeStatement}} in JDBC v2 (looks like it is the old
code when *schema == cacheName*)
Also please take a look at the test {{JdbcStreamingToPublicCacheTest}} to see
the wright way of the streaming to the table that is created by SQL. We have to
use separate connection. Also the JDBC connection with enabled streaming should
use ONLY for streaming INSERT.
> "Schema not found" error when setting streaming mode for JDBC driver
> --------------------------------------------------------------------
>
> Key: IGNITE-7248
> URL: https://issues.apache.org/jira/browse/IGNITE-7248
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.3
> Reporter: Alexey Kukushkin
> Assignee: Vladimir Ozerov
> Priority: Major
> Fix For: 2.4
>
>
> Using JDBC "thick" driver in streaming mode fails with a "Schema not found"
> erorr:
> Connection connection =
> DriverManager.getConnection("jdbc:ignite:cfg://streaming=true:cache=CACHE@file:/path-to-ignite-config.xml");
> // using connection to create a table works fine but this exception is
> generated when using the connection to execute INSER INTO...
> class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed
> to set schema for DB connection for thread [schema=]
> org.h2.jdbc.JdbcSQLException: Schema not found; SQL statement:
> SET SCHEMA "" [90079-195]
> See [User
> List|http://apache-ignite-users.70518.x6.nabble.com/Cannot-insert-data-into-table-using-JDBC-tc17477.html]
> for more details
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
