1 2 Previous Next 19 Replies Latest reply on Oct 23, 2014 4:42 AM by lukaszmro Go to original post
      • 15. Re: Connection error - result set closed
        shawkins
        shawkins Oct 20, 2014 1:28 PM (in response to rareddy)

        > @Steven - unfortunately, at this moment i have only production environment , i cannot update now to newer release.

         

        This would be more to just confirm behavior.  Ideally you could do that in a non-production environment.

          • Actions
        • 16. Re: Connection error - result set closed
          lukaszmro
          lukaszmro Oct 20, 2014 2:58 PM (in response to lukaszmro)

          Hi, please find attached detailed log

           

          edit:that was only a part...

          How can i send you priv message with full log?

            • Actions
          • 17. Re: Connection error - result set closed
            lukaszmro
            lukaszmro Oct 22, 2014 11:20 AM (in response to lukaszmro)

            Solved!

             

                        </datasource>
                        <datasource jndi-name="***" pool-name="***" enabled="true">
                            <connection-url>****</connection-url>
                            <driver>jaybird-2.2.5.jar</driver>
                             <security>
                                <user-name>***</user-name>
                                <password>***</password>
                            </security>

            <timeout>

            <blocking-timeout-millis>180000</blocking-timeout-millis>

            <idle-timeout-minutes>3</idle-timeout-minutes>

            </timeout>

            <pool>

            <min-pool-size>10</min-pool-size>

            <max-pool-size>500</max-pool-size>

            <prefill>true</prefill>

            </pool>              
                        </datasource>
              • Actions
            • 18. Re: Connection error - result set closed
              rareddy
              rareddy Oct 22, 2014 11:32 AM (in response to lukaszmro)

              Lukas,

               

              Please explain the difference from before what you had? The configuration will not change the behavior of resultset being closed. Either you have a new driver with fixed error or one the times have been extended, in that case the problem has been just delayed not eliminated.

               

              Ramesh..

                • Actions
              • 19. Re: Connection error - result set closed
                lukaszmro
                lukaszmro Oct 23, 2014 4:42 AM (in response to lukaszmro)

                Hi,

                After change DS def. i dont have any errors anymore in console.

                It seems - for me - that error occurred, because teiid was waiting for query result which was not possible to receive from query.

                And the reason for this was in pool.

                 

                Since i increased the pool and timeout - query can be finished and everything works fine.

                  • Actions
                1 2 Previous Next