Menu ▾ ▴

Negative Time Values

Technical questions
Anonymous
2013-10-15
2013-10-15

  • Anonymous

    Anonymous - 2013-10-15

    Running OSX 10.8.5, installed SQLeoVQB.2013.09.rc1 and downloaded mysql-connector-java-5.1.26.

    When encountering a negative time-value in time data-type ( http://dev.mysql.com/doc/refman/5.0/en/time.html ) I receive a "java.sql.SQLException: Bad format for Time '-05:00:00' in column 3"

    However, the I can input and modify the value from other MySQL applications, the value appears valid to me. It also loads when I change to a positive time value.

    Thanks.

     

  • Anu

    Anu - 2013-10-15

    Hello,

    We had a similar question for time field of mysql, check answer here
    https://sourceforge.net/p/sqleo/discussion/general/thread/8dcc6258/

    Hope it solves your issue.

    Cheers
    Anudeep

     

    • Anonymous

      Anonymous - 2013-10-15

      Thanks Anudeep -- unfortunately that parameter didn't correct the issue. Still throws an error.

       

  • Anu

    Anu - 2013-10-15

    Thanks for the feedback, Could you please confirm this exception happens in content window (displayed like table format where you can add/delete rows)
    but not in command editor result ?

    If you try in command editor, select * from test, may be you are not getting this exception, negative times are shown in the result ?

    If so, I have a fix for SQLeo as JDBC connector of MySQL doesn't support this case, but little bit hesitant to fix as its only MySQL specific case.
    Fix proposed here - http://stackoverflow.com/questions/3493378/resolve-a-bad-format-for-time-error-in-java

     

    Last edit: Anu 2013-10-15

  • Anu

    Anu - 2013-10-15

    There was actually old bug in MySQL jdbc connector which was decided to "Wont fix"
    http://bugs.mysql.com/bug.php?id=11154

     

Anonymous
Anonymous

Add attachments
Cancel