[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

0
Avatar
Permanently deleted user

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

0
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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

请先登录再写评论。