Stored Procedure

Call Stored Procedure using Spring StoredProcedure

This tutorial will show you how we can stored procedure using Spring SimpleJdbcCall. For this tutorial we will create a standalone maven project in Eclipse. If you already have an idea on how to create a maven project in Eclipse will be great otherwise I will tell you here how to create a maven project […]

Call Stored Procedure using Spring SimpleJdbcCall

This tutorial will show you how we can stored procedure using Spring SimpleJdbcCall. For this tutorial we will create a standalone maven project in Eclipse. If you already have an idea on how to create a maven project in Eclipse will be great otherwise I will tell you here how to create a maven project […]

Important properties in hibernate configuration file

There are mainly six important tags for hibernate configuration file. Hibernate configuration file naming convension is generally hibernate.cfg.xml and it is generally placed in the classpath. This can also be configured in the hibernate.properties file. If both hibernate.cfg.xml and hibernate.properties are found in the classpath then hibernate.cfg.xml overrides hibernate.properties file.

Stored procedure example in Hibernate

This tutorial shows how we can call stored procedure in Hibernate API. Prerequisites Hibernate 3.x jars, mysql-connector-java jar, jdk 1.6, MySQL 5.x 1. Create a Store Procedure in MySQL in database cdcol DELIMITER $$ CREATE PROCEDURE `cdcol`.`getCds`(cdid BIGINT) BEGIN SELECT * FROM cds WHERE id=cdid; END$$ DELIMITER ;  

Scroll to top