firebird « Stored Procedure « JPA Q&A

1. Executing stored procedures in Firebird using JPA NamedStoredProcedureQuery

    EntityManager em = getEntityManager();

    EntityTransaction etx = em.getTransaction();

    Query query = em.createNamedQuery("login_procedure").setParameter("param1","user").setParameter("param2", "pw");

    Integer ...

2. Firebird support stored procedures and UDFs

Newbie Joined: Sat Jun 25, 2005 11:18 pm Posts: 7 Summary: Can hibernate now or later be made to support non-table object "existence testing" and creation prior to hibernate executing any other schemaupdate methods against the database? Important for the availability of Firebird basic SQL functions which are standard in other databases. Useful for the declaration of helper Firebird stored procedures. ...

4. How to call stored procedure of Firebird

hello sir, I have a stored proc [b]TESTSELECTSP [/b] written in firebird DB: CREATE PROCEDURE TESTSELECTSP RETURNS ( VBOOKNAME VARCHAR(50), VAUTHOR VARCHAR(50), VPUBLICATION VARCHAR(50), VPRICE INTEGER ) AS BEGIN For Select BookName,Publication,Author,Price from Books into :vBookName,vAuthor,vPublication,vPrice Do Begin suspend; End END ^ I have the below code written for mapping, [code]