Stored procedure « Transaction « Spring Q&A





1. spring & plsql stored procedure - exception handling & transactions    stackoverflow.com

I need to call oracle stored procedure from spring (via Hibernate). I'm not familiar with PL/SQL so I would like to know how to proceed with that. 1) Can I use spring/hibernate ...

2. Spring Transaction Management and Oracle Stored procedures    stackoverflow.com

I am currently integrating transaction management into my code. I am trying to set it up against stored procedures that already exist. The stored procedures have a commit at the end of them. In ...

3. Are Java Transactions Propagated to MySQL Stored Procedure?    stackoverflow.com

[I have been getting conflicting information on the web, hence asking a specific question.] My Java App uses Declarative Spring Transactions (with Hibernate ORM). If my application calls a MySQL Stored Procedure ...

4. Spring transaction with JPA and stored procedure    forum.springsource.org

Spring transaction with JPA and stored procedure HI, We are using jpa with spring transaction. (Oracle database) Within a transaction i am inserting record in one table(using jpa) then i am ...

5. StoredProcedure not rollback after exception    forum.springsource.org

StoredProcedure not rollback after exception Hi, I am using Spring JDBCTemplate, Tomcat 6 and spring 2.5.6 for inserting into MYSQL stored procedure.My stored procedure has two insert statment for storing records ...

6. Stored procedure call on starting and finishing transaction.    forum.springsource.org

Stored procedure call on starting and finishing transaction. I'm using Spring 1.1 framework for a web application using Oracle 9.2 database. Data access is a mix of Hibernate and JDBC access ...

7. Spring - Hibernate3 - Stored Procedures - Transaction Fails    forum.springsource.org

We are using Spring 1.2 and Hibernate3. The application demands to call Oracle stored procedures from it. Application handles database inserts, updates and deletes using plain old java objects, whereas the ...

8. StoredProcedure instances sharing a transaction scope    forum.springsource.org

StoredProcedure instances sharing a transaction scope Hi I have an application calling some stored procs (Spring StoredProcedure instances) and I want to have them all sharing a transaction scope. The use ...

9. Problem using iBatis and transaction management inside Stored procedure    forum.springsource.org

Problem using iBatis and transaction management inside Stored procedure I am using stored procedure for DB related stuff using iBATIS. (SQL server 2000). When i call procedure in which i do ...





10. Optimistic locking and stored procedures    forum.springsource.org

Can someone give me some insight as to how I might be able to leverage Spring to obtain an optimistic locking concurrency strategy using stored procedures? I'm kind of a newbie ...

11. Transactions with stored procedures    forum.springsource.org

Transactions with stored procedures I'm working on a project that leverages Oracle stored procedures heavily. It is a legacy system that is undergoing a modernization effort by replacing COBOL with an ...

12. Committing Stored Procedure Call Mid-Transaction    forum.springsource.org

Dec 31st, 2007, 05:48 PM #1 rorr View Profile View Forum Posts Private Message Junior Member Join Date Aug 2004 Posts 2 Committing Stored Procedure Call Mid-Transaction Hello. I'm wondering if ...

13. StoredProcedure implementation- Specifying transaction    forum.springsource.org

Hi, How can I run a StoredProcedure interface implementation within a database transaction context. My scenario would have a stored proc class implementation to execute the controller db strored proc. The ...

14. Stored procedure may be run only in unchained transaction mode    forum.springsource.org

Transaction management runs perfectly until it hits this a nested stored procedure, and I wonder if there is something using Spring to solve it? Code: Cause: com.sybase.jdbc3.jdbc.SybSQLException: Stored procedure 'dbo.get_sec_usr_details' may ...

15. Transaction control on stored procedures    forum.springsource.org

Sep 10th, 2008, 10:49 AM #1 wonder View Profile View Forum Posts Private Message Junior Member Join Date Sep 2007 Posts 6 Transaction control on stored procedures Hello, We are in ...

16. How to setup correctly: Two datasources, StoredProcedure and transactions    forum.springsource.org

How to setup correctly: Two datasources, StoredProcedure and transactions Within a transaction (on Oracle db) that uses standard Hibernate stuff, I would also like to call StoredProcedures on a different database ...