Menu ▾ ▴

java.sql.SQLException: Invalid Fetch Size

Technical questions
Anonymous
2013-08-16
2014-03-30

  • Anonymous

    Anonymous - 2013-08-16

    java.sql.SQLException: Invalid Fetch Size when trying to run query. Using jdbc odbc bridge.

     

  • PAscal

    PAscal - 2013-08-17

    Hi, thanks for this post that should help us to improve SQLeo.
    We are not able to reproduce ...

    Could you give us additionnal informations:
    - SQLeo version
    - database used behind ODBC bridge
    - value set "max rows fetch size" in tools /preferences / command editor

    Thanks in advance
    Regards
    PAscal

     

  • Anonymous

    Anonymous - 2014-03-16

    Hi PAscal, is it possible for SQLEO to fetch many schemas, instead of just one, this due to the fact that many queries need tables from different schemas.
    Thanks, Jorge Eduardo.
    And thanks for that great work you've done. It runs fantastic.

     

    • PAscal

      PAscal - 2014-03-16

      Hi Jorge
      SQLeo supports multi schemas for most rdbms (except MySQL)
      try to change
      tools - preferences - query builder - use schema name in syntax definition

      Regards
      and thanks for the comments
      PAscal

       

  • Anonymous

    Anonymous - 2014-03-17

    Thanks PAscal, is there any possibility of enabling multiple schema for mysql?
    Jorge.

     

    • PAscal

      PAscal - 2014-03-17

      Hi,
      you should always be able to execute such queries from command editor,
      but it will not be possible to reverse them to graph or to build them using query builder.

      We already have ticket #186 related to this subjet, it should be quite a big work to do it, but if other users asks for it, we can do it !

      PAscal

       

  • Anonymous

    Anonymous - 2014-03-18

    thanks, I' ve working around with sqleo and found it great, as well as replaces flyspeed, which runs over windows, but I work on linux. so the only issue is this , to be able to fetch many schemas at once. Hope it can be done soon, thanks and have a great day.

     

  • PAscal

    PAscal - 2014-03-18
     

    • PAscal

      PAscal - 2014-03-18

      See customized jdbc driver in ticket #192
      Feedbacks are welcome

       

      • PAscal

        PAscal - 2014-03-30

        tested with success with MySQL 5.5.16

         

Anonymous
Anonymous

Add attachments
Cancel