SQL auto complete inside java code Follow
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.
Please sign in to leave a comment.
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.
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").
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.
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.
That did it, thanks. I didn't know I had to set that per module (or project global).
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.