Hello.

I have a problem when trying to use a named HQL query. I get a StringIndexOutOfBoundsException when trying to list the query.
The error (only in the browser btw, not in the console) is:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1


My java code is:

Query q = session.getNamedQuery("findMessageByMailboxIdAndStatus");
q.setParameter("mailboxId", mailboxId+"");
q.setParameterList("statuses", params);
q.setMaxResults(pageSize);
q.setFirstResult(pageSize * pageNr);
List messages = q.list(); <- this is where the exception is thrown

The parameter known as 'statuses' is a list with Integers. The query definition itself is as follows (irrelevant stuff omitted):

<hibernate-mapping>
<class name="com.veritate.inbound.model.Message" table="messages">
.....
</class>

<sql-query name="findMessageByMailboxIdAndStatus"><![CDATA[
from Message as message where message.mailbox.id = :mailboxId
and message.status in (:statuses) order by message.created desc
]]>
</sql-query>

</hibernate-mapping>


What am I doing wrong?

stuff I use:
Hibernate 2.1.8
Java 1.4
Resin 3.0.13

q.setParameter("mailboxId", mailboxId+"");
I wonder what you're trying to do here. Don't know if this is related to your exception.

Sorry my mistake, that is changed to:

q.setParameter("mailboxId", new Integer(mailboxId));

This is not the problem btw, since I've minimises the statement as much as possible to

<sql-query name="findMessageByMailboxIdAndStatus">
<![CDATA[from Message as message]]>
</sql-query>

Must be something else...

please provide the Stacktrace ... it will make it easier to help.

And second, have a look at page 105 in the reference PDF. I'm not quite sure if you can have an "sql-query" without "select" etc. ...
My HiA is not available at the moment so i'm not able to look it up there ..

gtx
curio

sorry ... (not my day i think) ...

you can look at page 74, too ... there's the description of how to write "named querys" ...

ok, I found it finally. appearantly I should have used <query...> instead of <sql-query...>.


yes, you can. well, in <query...> you can anyway...

I was under the impression that <query...> was deprecated and replaced by <sql-query...>.
My mistake then...

Thanx for all the replies, guys. C U Next time!