Hello!
I don't think we can help you further without looking at some SQL
statements. You could probably try commercial support which you trust.
What's the connection string for your driver? Does it point to a server
node or client node?
Regards,
--
Ilya Kasnacheev
вт, 8 дек. 2020 г. в 09:17, yangjiajun <1371549...@qq.com>:
> Hello.Thanks for u reply.
>
> Sorry for that I can't post sqls beacuse they contain sensitive bussiness
> info.I'm also sorry that I can't make a reproducer now.
>
> Here is my code to execute query:
> ResultSet excuteQuery(Connection conn, String sql) throws SQLException {
> Statement stmt = conn.createStatement();
> stmt.setQueryTimeout(7200);
> ResultSet rs = stmt.executeQuery(sql);
> rs.setFetchSize(15000);
> return rs;
> }
>
> void closeResultSet(ResultSet rs) throws SQLException {
> rs.close();
> rs.getStatement().close();
> rs.getStatement().getConnection().close();
> }
>
> try(Connection conn = pool.getConnection()){
> try(ResultSet rs = excuteQuery(conn,sql)){
> /**
> hadle result set
> */
> closeResultSet(rs);
> }
> }
>
> My hikariCP pool settings:
> HikariDataSource ds = new HikariDataSource();
> ds.setDriverClassName("org.apache.ignite.IgniteJdbcThinDriver");
> ds.setMaximumPoolSize(100);
> ds.setLeakDetectionThreshold(600000);
> ds.setConnectionTimeout(60000);
> ds.setMinimumIdle(0);
> ds.setReadOnly(true);
>
> The reseason I believe with as syntax does not work anymore is I have 5
> sqls
> got in trouble and all of then contain with as syntax.Another reason is
> such
> error happens at parse step.And we can see error info relates to 'temp
> table' which I think with as needs temp table.
>
> But u guys are experts,I will try my best to follow u advices and collect
> more info u need.
>
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
