Hibernate Community • View topic - Does named hibernate query supports optional parameters?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Does named hibernate query supports optional parameters?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

singa

Post subject: Does named hibernate query supports optional parameters?

Posted: Sun Feb 20, 2005 10:26 pm

Newbie

Joined: Wed Feb 02, 2005 11:19 pm
Posts: 6

Hi,

I am trying to replace an in-house SQL query engine with hibernate's named query and am wondering if hibernate supports optional parameters?

for eg.

Code:

<query name="testQuery">
  SELECT BALANCES.AMT_BLNC FROM
  BALANCES, ACCOUNTS
  WHERE
  BALANCES.ACCT_ID = ACCOUNTS.ID_ACCT

  <OPTIONAL PARAM="instrumentUID">
     AND BALANCES.INS = :instrumentUID
  </OPTIONAL>
</query>   

Basically the optional parameter instrumentUID is included into the query when it is not empty.

- Jim

Top

michael

Post subject:

Posted: Mon Feb 21, 2005 8:22 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

No, there is no such thing.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum