[ANN] SQL Code Assistant plugin

Versions for IDEA 8 and CE are available.

Now plugin is able to run SQL queries in the background. Another helpful enhancement (I believe) is ability to turn off syntax check and remove annoying "error syntax" highlighting in case the parser could not cope with a script.

Main resolved bugs:
- issue with multiframe mode,
- pl/sql variable auto completion,
- table definition for External Table fixed,
- etc

Comments and rates are very appreciated!

Regards,
Serhiy

4 comments
Comment actions Permalink

Is this plugin Open source? I like to help with it.

0
Comment actions Permalink

I'm getting this error:

Column datetime not found: Column datetime not found
java.lang.Error: Column datetime not found
at com.deepsky.database.ora.desc.OraTableDescriptor.getColumnDescriptor(Unknown Source)
at com.deepsky.database.ora.handlers.TableDefGenerator.generate(Unknown Source)
at com.deepsky.database.ora.handlers.TableDefGenerator.generate(Unknown Source)
at com.deepsky.database.ora.handlers.TableHandler.load(Unknown Source)
at com.deepsky.database.ora.CacheManager3.a(Unknown Source)
at com.deepsky.database.ora.CacheManager3.run(Unknown Source)
at java.lang.Thread.run(Thread.java:619)

10G database

0
Comment actions Permalink

Hi Rodrigo, thank you for the feedback!

I guess the plugin does not quite correct handle definitions of some specific tables, root of cause is the "datetime" column.
Could you provide a definition script of the table with column "datetime"? It might help with resolving similar issues in the future.

Regards,
Serhiy

0
Comment actions Permalink

Hi Rodrigo,

The most of sources can be found on GitHub - "SQL-Code-Assistant"project, it is a prerelease of 0.9.0.

Thanks,
Serhiy

0

Please sign in to leave a comment.