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

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


6 comments
Comment actions Permalink

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.


0
Comment actions Permalink

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!"

0
Comment actions Permalink

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.


0
Comment actions Permalink

That's very good news!

0
Comment actions Permalink

Hello Alexander,

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

Best,
Andrei


0
Comment actions Permalink

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


0

Please sign in to leave a comment.