HIbernate calls the Oracle Stored Procedure

1. Create a stored procedure

Proc code

1. Create or replace procedure changesalary (p_employeeid number, p_newsalary number) is
2. Begin
3. Update employees set salary = p_newsalary
4. Where employee_id = p_employeeid;
6. If SQL % notfound then
7. Raise_application_error (-20100,'Invalidemployee id');
8. End if;
10. End;
11. /

Create or replace procedure changesalary (p_employeeid number, p_newsalary number) isbegin update employees set salary = p_newsalary where employee_id = p_employeeid; if SQL % notfound then raise_application_error (-20100, 'invalidemployee id'); end if; end ;/

2. hibernate Configuration

Xml Code

1. <?Xml Version="1.0" Encoding=UTF-8"?>
2. <! DOCTYPE hibernate-configuration PUBLIC "-// Hibernate/Hibernate Configuration DTD 3.0 // EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
3. <Hibernate-configuration>
4. <Session-factory>
5. <Property Name="Hibernate. dialect">Org. hibernate. dialect. Oracle9Dialect</Property>
6. <Property Name="Hibernate. connection. driver_class">Oracle. jdbc. driver. OracleDriver</Property>
7. <Property Name="Hibernate. connection. url">Jdbc: oracle: thin: @ localhost: 1521: xe</Property>
8. <Property Name="Hibernate. connection. username">Hr</Property>
9. <Property Name="Hibernate. connection. password">Hr</Property>
10. <Property Name="Hibernate. hbm2ddl. auto">Update</Property>
11. <Property Name="Hibernate. show_ SQL">True</Property>
12. </Session-factory>
13. </Hibernate-configuration>

<? Xml version = "1.0" encoding = "UTF-8"?> <! DOCTYPE hibernate-configuration PUBLIC "-// Hibernate/Hibernate Configuration DTD 3.0 // EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> 
3. hibernate applications
(1) Connect using JDBC
Java code

 

 
  
ImportOrg. hibernate. Query;
 
  
ImportOrg. hibernate. Session;
 
  
ImportOrg. hibernate. SessionFactory;
 
  
ImportOrg. hibernate. cfg. Configuration;
 
  

 
  
Public ClassCallSP {
 
  

 
  
Public Static VoidMain (String [] args)ThrowsException {
 
  

 
  
Configuration c =NewConfiguration (). configure ();
 
  
SessionFactory sf = c. buildSessionFactory ();
 
  
Session session = sf. openSession ();
 
  
Session. beginTransaction ();
 
  

 
  
Connection con = session. connection ();// Obtain JDBC connection from Session object
 
  
CallableStatement cs = con. prepareCall ("{Call changesalary (?,?) }");
 
  
Cs. setInt (1,100);// First parameter index start with 1
 
  
Cs. setInt (2,6000);// Second parameter
 
  
Cs.exe cute ();// Call stored procedure
 
  

 
  
Session. getTransaction (). commit ();
 
  
Session. close ();
 
  
Sf. close ();
 
  
}
 
  
}

 
Import org. hibernate. query; import org. hibernate. session; import org. hibernate. sessionFactory; import org. hibernate. cfg. configuration; public class CallSP {public static void main (String [] args) throws Exception {Configuration c = new Configuration (). configure (); SessionFactory sf = c. buildSessionFactory (); Session session = sf. openSession (); session. beginTransaction (); Connection con = session. conne Ction (); // obtain JDBC connection from Session object CallableStatement cs = con. prepareCall ("{call changesalary (?,?) } "); Cs. setInt (1,100); // first parameter index start with 1 cs. setInt (2,6000); // second parameter cs.exe cute (); // call stored procedure session. getTransaction (). commit (); session. close (); sf. close ();}}
(2) Use Native SQL
Java code

 

 
  
ImportOrg. hibernate. Query;
 
  
ImportOrg. hibernate. Session;
 
  
ImportOrg. hibernate. SessionFactory;
 
  
ImportOrg. hibernate. cfg. Configuration;
 
  

 
  
Public ClassCallSP {
 
  

 
  
Public Static VoidMain (String [] args)ThrowsException {
 
  

 
  
Configuration c =NewConfiguration (). configure ();
 
  
SessionFactory sf = c. buildSessionFactory ();
 
  
Session session = sf. openSession ();
 
  
Session. beginTransaction ();
 
  

 
  
Query q = session. createSQLQuery ("{Call changesalary (?,?) }");
 
  
Q. setInteger (0,100);// First parameter, index starts with 0
 
  
Q. setInteger (1,4000);// Secon parameter
 
  
Q.exe cuteUpdate ();
 
  
Session. getTransaction (). commit ();
 
  
Session. close ();
 
  
Sf. close ();
 
  
}
 
  
}