"Operation timed out before completion." when executing queries against JBoss DV
Issue
- client presents error similar to:
PreparedStatementCallback; uncategorized SQLException for SQL [SELECT ...]; SQL state [38000]; error code [0]; Operation timed out before completion.; nested exception is org.teiid.jdbc.TeiidSQLException: Operation timed out before completion.
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT ...]; SQL state [38000]; error code [0]; Operation timed out before completion.; nested exception is org.teiid.jdbc.TeiidSQLException: Operation timed out before completion.
...
Caused by: org.teiid.jdbc.TeiidSQLException: Operation timed out before completion.
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:540) ~[teiid-client-8.7.9.6_2-redhat-2.jar:8.7.9.6_2-redhat-2]
at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) ~[teiid-client-8.7.9.6_2-redhat-2.jar:8.7.9.6_2-redhat-2]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) ~[c3p0-0.9.1.2.jar:0.9.1.2]
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703) ~[spring-jdbc-4.0.5.RELEASE.jar:4.0.5.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) ~[spring-jdbc-4.0.5.RELEASE.jar:4.0.5.RELEASE]
... 39 common frames omitted
Environment
- Red Hat JBoss Data Virtualization (DV) 6.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.