Home Tutorialhelp Comment How to Execute Store procedure in Hibernate

 
 

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 

Java Beginners

hibernate
hibernate  how to uses optional column in hibernate 

Hibernate Questions

Hibernate
Hibernate  how to use pagination concept 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 code - Hibernate
hibernate code  How to store a image in mysql or oracle db using struts &hibernate 

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

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 Questions

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

Hibernate Interview Questions

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

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  Give me a brief description about Hibernate?How we will use it in programming?give me one example 

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   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 

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 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 

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 caching - Hibernate
hibernate caching  what is caching ?how to work with caching in hibernate ?can u give brief explanitation 

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 code problem - Hibernate
Hibernate code problem  how to write hibernate Left outer join program 

Hibernate Questions

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

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 Interview Questions

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

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 Questions

Hibernate connection management - Hibernate
Hibernate connection management  Hi I wish to know how does hibernate manages connection opening and closing and resource allocation. Unlike JDBC, we do not do any connection.close() in hibernate. Then as it is said 

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 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 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

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

Hibernate Questions

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

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 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

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

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

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 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

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

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

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

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

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

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 

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

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 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 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

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

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

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

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

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

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

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

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 debug parameters in the hibernate query
how to debug parameters in the hibernate query  how to debug parameters in the hibernate query 

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 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 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 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 integrate core java with Hibernate
How to integrate core java with Hibernate  How to integrate core java with Hibernate How to integrate core java with Hibernate   xxxxxxxxx   Please visit the following link: Java with Hibernate The above 

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-Tutorials

Hibernate : getCurrentSession()
This tutorial describes how getCurrentSession() method works in Hibernate 

Hibernate-Tutorials

CreateSQLQuery Hibernate
This section contain how CreateSQLQuery work in Hibernate 

Hibernate-Tutorials

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

Hibernate-Tutorials

Hibernate Mappings
In this section, you will learn how to do mapping in Hibernate 

Hibernate Questions

Hibernate required jar files - Hibernate
Hibernate required jar files  Hi, What are the jar files are required for hibernate and Springs application. I want to run complete application springs and hibernate. Where it will be available? How can i use it i.e. 

Hibernate Questions

hibernate joins
hibernate joins  how to fetch the data from multiple tables in mysql using HQL. Give me one example using joins 

Spring Framework Questions

spring hibernate
spring hibernate  i need to display many fields( fields are in different tables) in a jsp page....how to implement this using spring hibernate  .../hibernate-spring/index.shtml 

Hibernate Interview Questions

Exception in Hibernate - Hibernate Interview Questions
Exception in Hibernate  Hi Deepak, In Jdbc we can handle d exceptions manually, same as how we can do in hibernate. Thank u 

Hibernate Interview Questions

Exception in Hibernate - Hibernate Interview Questions
Exception in Hibernate   Hi , In Jdbc we can handle d exceptions manually, same as how we can do in hibernate. Thank u 

Hibernate Questions

Configuring Hibernate
Configuring Hibernate  How to configure Hibernate?   ...; <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd 

Hibernate-Tutorials

Hibernate Collection Mapping
Hibernate Collection Mapping In this tutorial you will learn about the collection mapping in Hibernate. Hibernate provides the facility to persist... the persistent collection-value fields. Hibernate injects the persistent collections based 

Hibernate Interview Questions

HIBERNATE
HIBERNATE   What is difference between Jdbc and Hibernate 

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.