Can`t view Table in the Data Source window.
Dear friends, need help.
i created in hsqldb table. And all so working fine in SQL console, but if i selected table in Data Source window and will pressed button open table editor i have error:
[2011-07-06 13:46:38] [22019][-226] Three part identifiers prohibited in statement [select "PUBLIC"."QUOTE".]
wtf? sql script not correct? May be i can, sometime edit or setup script request?
p.s. sorry i don`t know english.So I write in Russian.
Attachment(s):
Снимок экрана 2011-07-06 в 14.10.51.png
请先登录再写评论。
Hi.
This problem does not occur with my HSQLDB 2.0.0. I've googled a bit and found some statements that catalog names wasn't just supported in early versions (see e.g. http://old.nabble.com/Support-for-%22Three-part-identifiers%22-td5939989.html)
What HSQLDB version do you have?
Thanks,
Alexander.
My version HSQLDB is "hsqldb-1.8.0.10" in component grails.
I understood in what problem I will try to translate version back in IDEA.
I select in DataSource old library 1.8.0.10,some as grails, but dialect no change. realy i need path itself?