SQL Console (9540)

After configuring a connection to an HSQLDB using the SQL Console, and loading tables / running basic selects etc., is there anything else I have to configure in order to get table name / column auto completion, since right now, I have none?

I would have expected any kind of SQL dialect setting to be made available on the settings for the Database config.

1 comment
Comment actions Permalink

Hello Nick,

After configuring a connection to an HSQLDB using the SQL Console, and
loading tables / running basic selects etc., is there anything else I
have to configure in order to get table name / column auto completion,
since right now, I have none?

I would have expected any kind of SQL dialect setting to be made
available on the settings for the Database config.

---
Original message URL:
http://www.jetbrains.net/devnet/message/5228600#5228600


Find Properties button in JDBC console toolbar. In properties dialog the
language is specified. HSQLDB is not yet supported, Plain text is plain text,
GenericSQL has only syntax highlighting without completion. So, you have
to select a dialect, the "closest" to HSQLDB.

Alexander.


0

Please sign in to leave a comment.