Hibernate Hibernate How To Index

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

This tutorial is really very easy to understand and gives comprehensive knowledge of Hibernate.

Thank you for doing this great work Deepak.

Regards,

Abhishek

Posted by Abhishek Tripathi on Monday, 04.2.07 @ 00:58am | #13151

Its really useful for me and he has explained all the topics with the very simple codes.
Thank you very much for the person who did this wonderful job..........

Posted by Sarath Babu on Thursday, 03.29.07 @ 15:49pm | #12912

Hey.
I am facing problem in HQL.
I want to perform summation of products.

For example -
select (s.totalQuestions * s.weightageMarks) from Section s

But this doesnt work. If i try in SQL after converting the query it works fine.

It shows error at the '*' sign.
Can u guide how to perform multiplication using hibernate

Thanks,
Sameer Malde

Posted by Sameer Malde on Friday, 02.16.07 @ 19:26pm | #8070

Hi Deepak,

Can you please give me an example to delete an a Parent entity having a set of child entities using native SQL, that would be great?

Posted by Abhay on Friday, 12.29.06 @ 14:00pm | #2207

This is very nice tutorial I ever seen elsewhere. Much thanks to Deepak Kumar for explaining details in very simple way.

Thanks
Kannan

Posted by Kannan on Tuesday, 12.19.06 @ 14:38pm | #1232

I tried to run the FirstExample, but I got some NullPointerException. I think I missed the MySQL part. Would you explain how we should setup the database in order to run the hibernateexample?
thanks,
Angie

Posted by Angie on Wednesday, 12.6.06 @ 20:11pm | #517

Hi Vivek,

You can read more about struts hibernate at http://www.roseindia.net/struts/struts-hibernate/index.shtml

n this tutorial I will show you how to integrate Struts and Hibernate. After completing this tutorial you will be able to use Hibernate in your Struts project. We will be using Hibernate Struts plug-in to write high performance application using Struts and Hibernate.

Thanks
Deepak Kumar

Posted by Deepak Kumar on Wednesday, 11.29.06 @ 18:15pm | #205

I have gone throgh the complete tutorial....
If this is all in hibernate then thanks for making it so easy.
Really very nice tutorial...If u can show it with some struts(MVC) archietecture,then it will be really very useful.
Thanks.

Posted by Vivek Bhandarkar on Wednesday, 11.29.06 @ 18:11pm | #204