#88 Odd characters in SQL not being handled right?

open
nobody
None
5
2011-08-02
2011-08-02
Jonathan Carlson
No

Thanks for a great plugin. I've been happily running SQL Explorer 3.6.1 for the last few weeks. However, the plugin goes into la-la land when I execute this against a database (happens to be Postgres)

update t_user set password = '/FkB31Sclr+awjyHLJzNv2kLThw=:eZ5iJTDcc10=' where user_id = 27;

I never get a response back from the application and when I try to execute other SQL statements it throws a NullPointerException

SQuirreL executes it fine against the exact same database instance. I suspect there is something in the syntax parser that doesn't like one of the characters in that string.

I'm running Eclipse Helios Service Release 2

Thanks!!

Discussion

  • Heiko Hilbert
    Heiko Hilbert
    2011-08-03

    Hi Jonathan,

    I tried your statement against my MySql database. It completes without any problems.
    Check that you have switched 'Log Success Messages' on in the SQL Explorer preferences.
    Then try it again and look into Messages tab for results.
    Sometimes the Sql editor has a problem when trying to execute a statement at the end of the file. Then you'll get a NPE. The real cause I can't find yet.
    Please check your eclispe error log for more detailed error information.

    Thx
    Heiko