SQL auto complete inside java code

SQL Auto complete inside java code looks to work just fine when doing a "SELECT" statement, but when I try to do "INSERT" or "UPDATE" I don't get any auto complete. I looked on the injections and don't see anything restricting that.

What do I need to change?

Thanks.

6 comments

I take that back a bit, it is given me sql language auto complete when using "SELECT", but it isn't giving me any of my table information.

0

Make sure that you've defined data source (either DLL or regular) within your project ("Database" tool window > rlick > "New" > "Data Source" | "DDL Data Source").

0

I guess I forgot to mention that this works just great on JSP so I know my datasource is configured right. To configure the the auto complete for JSP I followed the advice on this thread.
http://devnet.jetbrains.com/thread/450437

Thanks.

0

What is the SQL dialect? E.g. see Settings dialog / SQL Dialects. "Generic" value does not provide table names completion. Please try to set your dialect.

Regards,
Alexander.

0

That did it, thanks. I didn't know I had to set that per module (or project global).

0

The default dialect for predefined injections (like for java.sql's prepareStatement() or so) is just "SQL". You can change it to, say, "Oracle" in Settings / Language Injections, then it will affect all projects.

Regards,
Alexander.

0

Please sign in to leave a comment.