I declare my SQL at the top of my DAO's in private final static String variables. Sometimes IntelliJ applies syntax highlighting to them and sometimes not (mostly not). This occurs to SQL in the same file for lines right next to each other. For instance:
private final static String = "SELECT blah,moreblah FROM foo WHERE junk = ?"; <--Will have highlighting applied
private final static String = "SELECT morecrap FROM bar WHERE morejunk = ?"; <--Won't have highlighting applied
I can't find any rhyme nor reason to what has highlighting applied and what doesn't. These are statements in the same file on subsequent lines.
I have GenericSQL set as my dialect for the entire project.
Also, are we supposed to get auto-completion when writing SQL? Because that doesn't work for me either.
I have my datasources setup and the jdbc console works fine.