5 Replies Latest reply on Dec 27, 2011 12:45 PM by Joyce Gaoiran

    org.teiid.jdbc.TeiidSQLException: java.util.concurrent.TimeoutException

    Joyce Gaoiran Newbie

      This exception is being thrown when executing a select * query on a vdb which contains a series of 7 views.  It times out at ~5 minutes each time.  I've set the QueryTimeout to be 10 minutes.  Is there a different property I should be setting?

       

      Thank you.

      -Jo

       

       

      org.teiid.jdbc.TeiidSQLException: java.util.concurrent.TimeoutException

          at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

          at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

          at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:546)

          at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:331)

       

      Caused by: java.util.concurrent.ExecutionException: java.util.concurrent.TimeoutException

          at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:335)

          at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539)

          ... 5 more

      Caused by: java.util.concurrent.TimeoutException

          at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:270)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          at java.lang.reflect.Method.invoke(Method.java:597)

          at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)

          at $Proxy1.read(Unknown Source)

          at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)

          at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:333)

          ... 6 more