from User as u where ((u.firstName like '%" + firstName +
"%') " + logicalOperator + " (u.lastName like '%" + lastName +
"%') " + logicalOperator + " (u.nickname like '%" + nickname +
"%')) AND (u.role.role like '%" + role + "%')";

Posted by Anrew on Tuesday, 04.7.09 @ 18:37pm | #86610

Dear Sir
We are using NHibernate with Asp.net.
I have written this code in HBM file

<sql-query name="OtherProfileAreas">
<return class="OtherProfileArea">
<return-property name="OtherDomain" column="OtherDomain"/>
<return-property name="Total" column="Total"/>
</return>
exec [dbo].[OtherProfileArea]
</sql-query>
</hibernate-mapping>


Also Created DAO for the same
now while executing the same

NHibernate.ISession iSession = NHibernateSessionManager.Instance.GetSessionFrom(SessionFactoryConfigPath);

NHibernate.IQuery query = iSession.GetNamedQuery("OtherProfileArea");



It gives run time error of

The given key was not present in the dictionary.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: The given key was not present in the dictionary.

Posted by Chirag on Wednesday, 10.15.08 @ 12:20pm | #81092

I want to learn Spring frame work, How far it easy to learn.

Posted by vas on Monday, 09.22.08 @ 12:56pm | #80591

Hello,
First of all, congratulations to keep a lot of documentation about hibernate in one place: it's help a lot !
I need to call an stored procedure in oracle from Hibernate (see bellow) that has 1 input parameter and 2 return values. I'm receiving and error from Oracle (invalid column index). Any help is appreciated.
Thanks in advance !!!

HBM file
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="br.com.gppg.dto.csep_Busca_Vinc_Matr">
<cache usage="read-only"/>
<id name="usuario" column="P_USERID"/>
<property name="vinculo" column="P_VINCULO"/>
<property name="matricula" column="P_MATRICULA"/>
<loader
query-ref="CSEP_BUSCA_VINC_MATR"/>
</class>
<sql-query name="CSEP_BUSCA_VINC_MATR" callable="true" >
<return alias="vinc_matr" class="br.com.gppg.dto.csep_Busca_Vinc_Matr" lock-mode="read">
<return-property name="vinculo" column="P_VINCULO"/>
<return-property name="matricula" column="P_MATRICULA"/>
</return>
{call CSEP_BUSCA_VINC_MATR(:ID_USUARIO,{vinc_matr.vinculo},{vinc_matr.matricula})}
</sql-query>
</hibernate-mapping>

Code to call it:

session = HibernateUtil.currentSession();
Query query = session.getNamedQuery("CSEP_BUSCA_VINC_MATR");
query.setString("ID_USUARIO", "tstgp");


Here is error message:
INFO [STDOUT] Hibernate: {call CSEP_BUSCA_VINC_MATR(?,{vinc_matr.vinculo},P_MATRICULA)}
WARN [JDBCExceptionReporter] SQL Error: 17003, SQLState: null
ERROR [JDBCExceptionReporter] Invalid column index

Posted by Andre on Sunday, 03.2.08 @ 19:03pm | #51028

Nice job. I am a hard time understanding Hibernate but I find this tutorial very helpful. I will definitely use this as my reference.

Posted by jane on Wednesday, 02.27.08 @ 22:26pm | #50330

hi is there a way to get result in random manner in DetachedCriteria query i appreciates early response
regards
Wishwa

Posted by Wishwa on Thursday, 11.29.07 @ 11:49am | #40878

thank you for your tutorial, the examples are great, i continue to use it as my reference

Posted by Kay on Thursday, 10.11.07 @ 04:35am | #33029

Hi,
i need to know how to implement the sample or different example hibernate in Netbeans IDE.
Can anyone help out me?

Regards,
Selva

Posted by selva on Tuesday, 09.18.07 @ 11:39am | #27462

Hi,

This is very easy & quick learning tutorail...

Thanx

Posted by sanjay Rakholiya on Wednesday, 05.30.07 @ 12:13pm | #17712

It is really good material for the beginners, nice, and thanks for your effort in presenting this material, try to update this one with the diffrent IDE's

Posted by vittal kambagi on Thursday, 04.26.07 @ 16:52pm | #14980