"Operation timed out before completion." when executing queries against JBoss DV

Solution Unverified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In