Any tricks needed to make the SQL coding assistance work in jdbc console and java files?

Hello Andrei,

Hi there,

I'm trying to use the features described here:
http://www.jetbrains.com/idea/features/sql.html

The datasources get the tables, I get coding assistance for SQL code
inside ddl files (after I set the dialect to SQL-92 for the source
root), but no coding assistance is available in the java files or in
the jdbc console. The latter is particularly weird, since there
doesn't seem to be much I could mess up.

For the java files I do get syntax highlighting, but just the generic
stuff (keywords and such), no hyperlinking available for the table or
column names.

Any ideas, are there any settings one should be aware of in order to
have this working?

DB is Oracle 10.2, btw.

Thx,
Andrei

The default dialect for JDBC console and Java String literals is "Generic
SQL". It provides just basic highlighting, no syntax errors or id resolve.

The dialect for JDBC console can be changed in its properties dialog. Find
the properties button on the console toolbar.

The dialect for String literal can be changed either globally, in Settings
/ Language injection / Parameters, or just for certain literal, with an annotation
like @Language("SQL-92").

Alexander.

SQL92 is most limited dialect (only generic stuff), we should have
Oracle dialect enabled in 8.X eap

Andrei Oprea wrote:

Hi there,

I'm trying to use the features described here:
http://www.jetbrains.com/idea/features/sql.html

The datasources get the tables, I get coding assistance for SQL code
inside ddl files (after I set the dialect to SQL-92 for the source
root), but no coding assistance is available in the java files or in the
jdbc console. The latter is particularly weird, since there doesn't seem
to be much I could mess up.

For the java files I do get syntax highlighting, but just the generic
stuff (keywords and such), no hyperlinking available for the table or
column names.

Any ideas, are there any settings one should be aware of in order to
have this working?

DB is Oracle 10.2, btw.

Thx,
Andrei

--
Best regards,
Maxim Mossienko
IntelliJ Labs / JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

The default dialect for JDBC console and Java String literals is
"Generic SQL". It provides just basic highlighting, no syntax errors

I've forgot: http://www.jetbrains.net/jira/browse/IDEADEV-31480

For JDBC console the default setting can be a bit worse.

Alexander.

That's very good news!

Hello Alexander,

Thanks for all the answers, I got it working now. :)

Best,
Andrei

Hello Maxim,

MM> SQL92 is most limited dialect (only generic stuff), we should have
MM> Oracle dialect enabled in 8.X eap

That's great, looking forward to it.

Best,
Andrei