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/
