Comment

Chirag
How to Execute Store procedure in Hibernate,
October 15, 2008 at 12:20 PM

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.


View All Comments | View Tutorial
Related Tutorial and Articles
Hibernate Questions

hibernate
hibernate  how to execute a sequence(in database) from Hibernate program or java program   Please visit the following link: Hibernate Tutorials 

Hibernate Questions

Hibernate - Hibernate
Hibernate  how to update record by calling stored procedure from java prog using hibernate query   Hibernate update query http://www.roseindia.net/hibernate/hibernate-update.shtml This will show you how to update 

Hibernate Questions

Hibernate - Hibernate
Hibernate  how to call the stored procedure in mysql database server using hibernate..??  Hi Friend, Please visit the following link: http://www.roseindia.net/hibernate Thanks 

Hibernate Questions

hibernate web project - Hibernate
hibernate web project  hi friends,very good morning,how to develop and execute web project using myeclipse ide.plz give me step-by-step procedure... links: http://www.roseindia.net/hibernate/index.shtml http://www.roseindia.net 

Hibernate Questions

Hibernate
Hibernate  how to use pagination concept in Hibernate 

Java Beginners

hibernate
hibernate  how to uses optional column in hibernate 

Hibernate Questions

hibernate
hibernate   I want to learn how to use hibernate framework in web application . for storing database in our application 

Hibernate Questions

hibernate
hibernate   I want to learn how to use hibernate framework in web application . for storing database in our application 

Hibernate Interview Questions

Hibernate
Hibernate  How do you handle parent - child tables relationships in hibernate? How do you handle Detach state in hibernate 

Hibernate Questions

Hibernate
Hibernate  hello, how to run hibernate program in netbeans?please send me step by step instructions to run hibernate in netbeans 

Hibernate Questions

hibernate
hibernate  How to know how many columns changed in a table when we are using hibernate 

Hibernate Questions

hibernate
hibernate  how to impot mysql database client jar file into eclipse for hibernate configuration   Hi Friend, Please visit the following link: http://www.roseindia.net/hibernate/runninge-xample.shtml Thanks 

Hibernate Interview Questions

HIBERNATE
HIBERNATE  How u connects database using hibernate 3.0? Where you have written the database configuration details 

Hibernate Questions

Hibernate Code - Hibernate
Hibernate Code   How to Invoke Stored Procedure in Hibernate???????? Plz provide details code 

Hibernate Questions

Hibernate
of Hibernate. I followed all th steps as given in the tutorial, but a build error... not be resolved. How can i rectify that error?   Hi, The error comes when hibernate library files are not included in the project build path. Please download 

Hibernate Questions

Hibernate
Hibernate  Can we write more than one hibernate.cfg.xml file... ? if so how can we call and use it.? can we connect to more than one DataBase from a single Hibernate program 

Hibernate Questions

hibernate code - Hibernate
hibernate code  How to store a image in mysql or oracle db using struts &hibernate 

Hibernate Questions

How to create and execute Hibernate project with out Myeclipse ide ?
How to create and execute Hibernate project with out Myeclipse ide ?  Hi, I am new to Hibernate programming please provide me rough design for creating and executing Hibernate project. Thank you 

Hibernate Questions

how to Integrate MULE and HIBERNATE - Hibernate
how to Integrate MULE and HIBERNATE  hi, i am having a simple JSP... from the page and store into DB(MYSQL). Mule is used to expose my JSP as webservice. Hibernate is used to talk with DB. I have used Spring framework to generate 

Hibernate Questions

Hibernate
Hibernate  How to create Dynamic array of Objects during HQL execution 

Hibernate Interview Questions

HIBERNATE
HIBERNATE  What is mean by cache? How many types are there give me one example 

Hibernate Questions

Hibernate
Hibernate  Can we rename hibernate.cfg.xml file name to somename.cfg.xml? if so how can we use 

Hibernate Questions

hibernate - Hibernate
hibernate  how to write join quaries using hql  Hi satish...: http://www.roseindia.net/hibernate/hibernate-aggregate-functions.shtml http://www.roseindia.net/hibernate/associations-and-joins.shtml Thanks 

Hibernate Questions

hibernate - Hibernate
hibernate  hi friends i had one doubt how to do struts with hibernate in myeclipse ide its urgent 

Hibernate Questions

Hibernate - Hibernate
Hibernate  Give me a brief description about Hibernate?How we will use it in programming?give me one example 

Hibernate Questions

hibernate - Hibernate
hibernate   hi,can any one tell me how to get SQL query in hibernate, when hql fire it will create sql in console when hibernate.cfg.xml property will true, but i want SQL query in one variable how to get it... Thanks satish 

Hibernate Questions

hibernate - Hibernate
hibernate  what is hibernate and how to make a pc hibernating?  Hi friend, Hibernate is based on object oriented concept like java... .properties file and in hibernate we use .xml file ,which is a better approach. We 

Hibernate Questions

Hibernate code problem - Hibernate
Hibernate code problem  Hi This is Raju.I tried the first example of Hibernate material what u have given. I have written contact.java... to execute FirstExample.java it is throwing java.lang.NullPointerException. at the line 

Hibernate Questions

Hibernate - Hibernate
Hibernate   Dear sir Thanks for your previous answers its really... ,hibernate, jboss, oracle) one is 1) Express and 2) MDM(All master data... 192.168.1.2 using hibernate(Schema name Express) In MDM i am connecting 

Hibernate Questions

Hibernate - Hibernate
Hibernate  when I run Hibernate Code Generation wizard in eclipse I'm... getting this error. please let me know, how to resolve.../hibernate/index.shtml Hope that it will be helpful for you. Thanks 

Struts Questions

how to store and retrieve image using struts2 and hibernate integration
how to store and retrieve image using struts2 and hibernate integration  how to store and retrieve image using struts2 and hibernate integration? plz help !! thanks in advance 

Hibernate Interview Questions

Hibernate Code - Hibernate Interview Questions
Hibernate Code  This is the question asked in CAPEGEMINI Write a sample code how to persist inner class,interface,final class and how to invoke stored procedure in hibernate? From Surjeet 

Hibernate Questions

hibernate sql error - Hibernate
hibernate sql error  Hibernate: insert into EMPLOYE1 (firstName..." org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update...) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ... 15 more *)how 

Java Beginners

hibernate with srtuts
hibernate with srtuts  store all employee time in time out infomation ....how can i get all employee time in time out information 

Hibernate Questions

hibernate
hibernate  hi what are the necessary jar files that we need to set in the classpath to execute a hibernate application 

Hibernate Questions

hibernate
hibernate  Is there any other way to call procedure in hibernate other than named query????? if we are using session object to get the connection then why hibernate we can directly call by using a simple java class??????? please 

Hibernate Questions

how to configure the hibernate in netbean
how to configure the hibernate in netbean  how to configure the hibernate in netbean 6.5 

Hibernate Questions

hibernate
hibernate   i am using hibernate3.2.5 and oracle9i. First i set classpath to ojdbc14.jar and all the hibernate jar files to path env variable.After that when i try to execute the program i got an error "unknown oracle major 

Hibernate Questions

Hibernate Configuration
Hibernate Configuration  Explain how to configure Hibernate 

Hibernate Questions

Hibernate code problem - Hibernate
Hibernate code problem  how to write hibernate Left outer join program 

Hibernate Questions

Hibernate compilation - Hibernate
Hibernate compilation  please explain how to compile and run Hibernate at command prompt ( in dos) with sample example 

Hibernate Questions

hibernate caching - Hibernate
hibernate caching  what is caching ?how to work with caching in hibernate ?can u give brief explanitation 

Hibernate Questions

Hibernate Annotations ManytoMany - Hibernate
Hibernate Annotations ManytoMany  Can anybody tell me how to have a many to many relationship through Hibernate Annotations not through the Hbm.xml files plz 

Hibernate Questions

How will you configure Hibernate?
How will you configure Hibernate?  Hi, How will you configure Hibernate? Thanks 

Hibernate Questions

AND operator in hibernate.
AND operator in hibernate.  How to use AND operator in hibernate 

Hibernate Questions

OR operator in hibernate.
OR operator in hibernate.  How to use OR operator in hibernate 

Hibernate Interview Questions

count in hibernate .
count in hibernate .  How to implements count in hibernate 

Hibernate Questions

spring hibernate - Hibernate
spring hibernate  can u tell me how we can integration of spring with hibernate?  Hi friend, For solving the problem Spring with Hibernate visit to : http://www.roseindia.net/spring/index.shtml http 

Hibernate Questions

struts hibernate - Hibernate
struts hibernate   how to integrate struts and hibernate ?is need any plugin ?programmer manually create that plguin?   Hi.../struts-hibernate/ Thanks 

Hibernate Questions

Hibernate application - Hibernate
Hibernate application  Hi, Could you please tell me how to implement hibernate application in eclipse3.3.0 Thanks, Kalaga.  Hi Friend, Please visit the following link: http://www.roseindia.net/hibernate 

Hibernate Interview Questions

hibernate - Hibernate Interview Questions
hibernate  1. how to create tables in hibernate"?  Hi Friend, Please visit the following link: http://www.roseindia.net/hibernate/index.shtml Hope that it will be helpful for you. Thanks 

Hibernate Questions

Hibernate code - Hibernate
Hibernate code   how to write hql query for retriveing data from multiple tables 

Hibernate Questions

structs2 + hibernate - Hibernate
structs2 + hibernate  pls suggest me to how save the pojo object in in hibernate using struts2 

Hibernate Questions

Hibernate Annotattions - Hibernate
Hibernate Annotattions  Can anybody tell me here how we can use hibernate annotations which is a new facility in hibernate 3.2 any tutorial and what.... The Hibernate Annotations is the powerful way to provide the metadata for the Object 

Hibernate Questions

how to edit a record in hibernate?
how to edit a record in hibernate?  how to edit a record in hibernate?   Hi Friend, Please visit the following link: Hibernate Tutorials Thanks   Hi Friend, Please visit the following link: Hibernate 

Hibernate Questions

hibernate execution - Hibernate
hibernate execution  how to create hibernate pojo classes in eclipse... database using hibernate in eclipse galileo ide. any one plz send me steps.../hibernate/index.shtml Thanks 

Hibernate Questions

How to learn Hibernate?
How to learn Hibernate?  I am beginner in Hibernate. Now I want to learn Hibernate. Can anyone explain me how to learn Hibernate from scratch... learn the complete Hibernate. Check the tutorial Hibernate examples and articles 

Hibernate Tutorial Example

Hibernate ORM 4.3.1.Final released
for stored procedure is added Now you can execute the UPDATE and DELETE... Hibernate How to use Hibernate 4.3.1 in project? If you are using the Maven...First bug fix of Hibernate: Hibernate ORM 4.3.1.Final released with JPA 

Hibernate Questions

About Hibernate - Hibernate
About Hibernate  What is Hibernate? How can i learn it fast.  ... object/relational persistence and query service for Java. Hibernate lets you develop... in itif you want to expertise in hibernate then you must read step-by-step tutorial 

Hibernate Questions

Hibernate Subquery - Hibernate
Hibernate Subquery  How to write following sub query query in hibernate? without using the query criteria. only need SQL query SELECT * FROM (SELECT ROWNUM ROW_NUM, A.* FROM ACCOUNT_SITE_INFO as A WHERE ROWNUM <= 100 

Hibernate Questions

Hibernate code - Hibernate
Hibernate code   Hi How to intract struts , spring and Hibernet. Explain architecture flow.   Hi Friend, Please visit the following link: http://www.roseindia.net/struts/hibernate-spring/index.shtml Here 

Hibernate Questions

Hibernate code - Hibernate
Hibernate code   example code of how insert data in the parent table and child tabel coloums at a time in hibernate  Hi friend, I am...: http://www.roseindia.net/hibernate/insert-data-database.shtml Thanks 

Hibernate Questions

How to calculate the average in Hibernate?
How to calculate the average in Hibernate?  Hi, I have to calculate the average in Hibernate. How to calculate the average in Hibernate? Thanks   Hi, You can use the project in Hibernate. Here is the example code 

Hibernate Questions

j2eee(Hibernate) - Hibernate
j2eee(Hibernate)  Hi, This is jagadhish.Iam learning Hibernate.I have one doubt on relationships in Hibernate.plz anybody tell me how to use relations in Hibernate(with examples).But not showing the link available 

Hibernate Questions

Hibernate in java - Hibernate
and Hibernate). Is there any body who can help me out in my task. All I want is an example in Hibernate. " How to configure a login page (user name and password...Hibernate in java  Hi, This is Gopi, I am working 

Hibernate Questions

how to iterate hibernate object
how to iterate hibernate object  am just learning hibernate .by the hibernate am getting one list to display a grid(grid has 5 column). now i want to iterate one only column value to calculate total of that particular column. how 

Hibernate Questions

jeetendradash - Hibernate
jeetendradash   how this code works?i just want to know when we execute session.getNamedQuery("Insname"), what happens? how the above code invoked? can anyone explain please?thnx 

Hibernate Questions

creating and executing stored procedure using hibernate
creating and executing stored procedure using hibernate  I have to execute following query using hibernate DECLARE @i_STARTDATETIME DATETIME DECLARE @i_ENDDATETIME DATETIME DECLARE @o_ERRORCODE INT DECLARE @o_ERRORDESCRIPTION 

Hibernate Questions

Hibernate in liferay
Hibernate in liferay  How to use hibernate in liferay jsf portlet? Can you illustate it with an example 

Hibernate Questions

Hibernate in liferay
Hibernate in liferay  How to use hibernate in liferay jsf portlet? Can you illustate it with an example 

Hibernate Questions

HIbernate call for sequence - Hibernate
HIbernate call for sequence  I have created a sequence in oracle table. Now how to access this in java class through hibernate from dual table i am not able to get. the hbm file is: IB_PAYMENT_SEQ 

Hibernate Questions

hibernate code problem - Hibernate
hibernate code problem  suppose i want to fetch a row from the table through a value which i got from the jsp page. how can i do it and iterate... . Please visit for more information. http://www.roseindia.net/hibernate 

Hibernate Questions

Hibernate - Hibernate
Hibernate SessionFactory  Can anyone please give me an example of Hibernate SessionFactory?  Hi friend,package roseindia;import... = sessionFactory.openSession(); String SQL_QUERY ="from Procedure proced" 

Hibernate Questions

How to update table in Hibernate
How to update table in Hibernate  Hi, I have a table in database that has two fields in it. Student Name and ID, can anyone explain me how to update these tables in Hibernate. Thanks.   Update table query in Hibernate 

Hibernate Questions

usage of hints in hibernate - Hibernate
usage of hints in hibernate  i, how to use oracle hints in hibernate. and also pls tell me the different scenarios we can use oracle hints in hibernate.can i use hints using named queries in hibernate.if u gave any 

Hibernate Questions

windows authentication with hibernate - Hibernate
windows authentication with hibernate  Does anyone know how to setup a datasource for SQL Server that uses Windows authentication instead of SQL Server mixed mood authentication? Is it possible with hibernate framwork? Thanks 

Hibernate Questions

Using of Hibernate - Hibernate
..._* all the column and keys are same. How can we use hibernate  Hi friend,read for more information.http://www.roseindia.net/hibernate 

Hibernate Questions

java - Hibernate
java  how can we configure many to many relationships in hibernate 

Hibernate Questions

How to run? - Hibernate
friends are told hibernate is a new entry to Java. so plz try to tell how to use Hibernate code in my application?  Hi friend, Hinernate : Hibernate...How to run?  Hiiiiiiiiiiiii friend.. i am Magesh 

Hibernate Questions

C3P0 with Hibernate
C3P0 with Hibernate  How to use C3PO with Hibernate? Thanks   Hi, Please check the tutorial C3P0 Hibernate. In this page we have source code example of using C3P0 with Hibernate. Thanks 

SQL Question

how to write store procedure in sql
how to write store procedure in sql  How to write a store procedure in SQL Server 

Hibernate Questions

How to deploy hibernate in linux server - Hibernate
How to deploy hibernate in linux server  can anyone tell me how can i deploy my project hibernate project in linux server which is currently running on eclipse (on my local desktop)? thanks in advance 

Hibernate Questions

How to deploy hibernate in linux server - Hibernate
How to deploy hibernate in linux server  can anyone tell me how can i deploy my project hibernate project in linux server which is currently running on eclipse (on my local desktop)? thanks in advance 

Hibernate Questions

How to use Hibernate get sessionfactory?
How to use Hibernate get sessionfactory?  Hi, How to use hibernate get sessionfactory? Thanks 

Java Interview Questions

How to solve the Hibernate Common Exceptions?
How to solve the Hibernate Common Exceptions?  How to solve the Hibernate Common Exceptions 

Hibernate Questions

how to debug parameters in the hibernate query
how to debug parameters in the hibernate query  how to debug parameters in the hibernate query 

Hibernate Questions

Hibernate - Hibernate
Hibernate  I am trying to connect hibernate with ejb2.0 stateless session bean, my application sucessfully deploy in weblogic server but when i execute the client application i got an error message that class not found exception 

Hibernate Tutorial Example

Hibernate How To
Hibernate How To Adding the ordering ability in your Hibernate Application while using hibernateTemplate In this section you will learn how... this tutorial you will learn how to find unique result using hibernate criteria 

Hibernate Tutorial Example

Hibernate Overview
. Hibernate mediates between Java objects and database store. It takes the Java... diagram shows how Hibernate works: Advantages of Hibernate There are many...Hibernate Overview - Learn the basics of Hibernate Framework This article 

Hibernate Questions

How to create sessionfactory in Hibernate 4.1?
How to create sessionfactory in Hibernate 4.1?  hi, I have worked on earlier versions of Hibernate but I am finding it difficult to work... Session Factory How to create SessionFactory in Hibernate 4.3.1 Hibernate 

Hibernate Questions

Hibernate Criteria Query Example
Hibernate Criteria Query Example  Hi, How to create Hibernate.... Thanks   Hi, Hibernate Criteria Query is used to selectively find the entities from the persistence store. Check the example Criteria Query Examples 

Hibernate Questions

Hibernate- Oracle connection - Hibernate
Hibernate- Oracle connection  In Eclipse I tried Windows --> Open perspective--> other in that Database Development Right click...) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) Please let me know How 

Hibernate Questions

Hibernate - Hibernate
Hibernate  Hai this is jagadhish while running a Hibernate...:11 PM org.hibernate.tool.hbm2ddl.SchemaUpdate execute INFO: Running hbm2ddl... execute INFO: fetching database metadata Aug 14, 2008 12:06:11 PM 

Hibernate Questions

How to create sessionfactory in Hibernate 4.1.1?
How to create sessionfactory in Hibernate 4.1.1?  HI, I need to create Sessionfactory in Hibernate 4.1.1. How can i do it? Thanks.   ... in hibernate 4.1.1: Hibernate 4 create Session Factory How to create SessionFactory 

Struts Questions

Struts2 and Hibernate
Struts2 and Hibernate  how to fetch database value from one page to another page in struts2 and hibernate 

Hibernate Questions

How to create wildcard query in Hibernate?
How to create wildcard query in Hibernate?  Hi, I am new in Hibernate and I have to create a query using wildcard. How to create wildcard query in Hibernate? Thanks   Hi, For creating wildcard query you can use 

Hibernate Questions

Java Hibernate
Java Hibernate  Sir, I want to learn hibernate but i don't know JSP. How & from Where i can start to learn hibernate?   Hello Friend, Please go through the following link: Hibernate Tutorials Here you will get 

Hibernate Tutorial Example

Hibernate ORM 4.3.0.Final released
for Stored procedure, batch updates etc. The Hibernate 4.3 was developed to support...: Now support for stored procedure is added Now you can execute the UPDATE... within Hibernate How to use Hibernate 4.3.0 in project? If you are using 

Hibernate-Tutorials

CreateSQLQuery Hibernate
This section contain how CreateSQLQuery work in Hibernate 

Hibernate-Tutorials

Hibernate save()
This tutorial explain how save() works in hibernate 

Advertisements

Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles