[FIXED] Set an array parameter value using Hibernate console on Intellij14

Issue

I'm using Hibernate Console provided by Intellij 14, which has been working great so far. Recently I've came across with a hql that needs String[] as a parameter value since it's going to be used in a 'IN' clause.

I couldn't find anywhere how to set this array on the parameters window as shown below:

I've tried so many different ways like separating by comma or between curly brackets.

I'm refusing to believe that Hibernate console doesn't allow me to do that. Has anyone faced the same situation?

Solution

I tried kinds of programming ways (like ["val1", "val2"], new String[]{"a", "b"} etc), they all didn't work, but there is another way, it is to specify separate parameter as workaround for this problem, and it works well.

Answered By - Hunter Zhao
Answer Checked By - Marilyn (JavaFixing Volunteer)