Why Native SQL integration?

 

  • Sometimes it is necessary to use native SQL queries
  • Sometimes it is necessary to use Stored Procedures

 

 

How to integrate native SQL and Stored Procedures?

 

 

The example below demonstrates how to use SQL in  the Jboss Seam  registration example.
Sql queries are defined in orm.xml. Register method is modified to use JPA named query API. 

 

orm.xml

 

 

orm.jpg

 

 

Registration.java

 

sql.jpg