database « Transaction « Spring Q&A





1. Would you use AOP for database transaction management?    stackoverflow.com

A while back I wrote an application which used Spring AOP for defining which methods were transactional. I am now having second thoughts as to how much of a ...

2. Obtaining a Hibernate transaction within a Spring class    stackoverflow.com

I am working on a program that uses Spring and obtains Hibernate transactions transparently using a TransactionInterceptor. This makes it very convenient to say "when this method is invoked from ...

3. How to configure transaction management for working with 2 different db in Spring?    stackoverflow.com

I have 2 databases (MySql and HSQLDB). I configured 2 data sources and 2 EntityManagerFactory beans. I can also configure 2 correspondent JpaTransactionManager beans. But I don't know how to specify ...

4. Multiple servers checking and writing flag in database    stackoverflow.com

I have an environment with 4 servers and 2 oracle database servers which have streams between them for instant 2 way replication. I have a servlet (I cannot control which of the ...

5. Hibernate updates database though all the service methods marked as read-only by spring transaction management    stackoverflow.com

I have already posted this question before but as the thread is little old I think I am not getting reply so sorry for duplicating but my issue is something ...

6. Spring Transaction - automatic rollback of previous db updates when one db update failes    stackoverflow.com

I am writing a simple application (Spring + Hibernate + PostgreSql db). I am just trying to construct a sample object and persist in db. I run a simple java class ...

7. Is it possible to test the transactionality of a process?    stackoverflow.com

I would like to be able to verify if each unit of work is done in its own transaction, or as part of a single global transaction. I have a method (defined ...

8. Managing database transactions manually in a Spring/Hibernate environment    stackoverflow.com

We've got a Spring based web application that makes use of Hibernate to load/store its entities to the underlying database. Since it's a backend application we not only want to allow our ...

9. Atomic Transactions across web services residing on same server using same database    stackoverflow.com

Our architecture comprises of Web Services developed on JAX-WS specification using Metro. These services are deployed on a single Glass Fish App server as separate war files.All web services internally use ...





10. Spring: Best way to handle long-running web-service calls with transactional DB methods?    stackoverflow.com

We have a service method which does approximately the following:

@Transactional
public void serviceMethod(...){
   for(Item i : bunchOfItems){
      webServices.webServiceCall(...);
      dao.daoUpdateMethod(...);
  ...

11. Transactions not updating DB when using container-managed(Glassfish) JPA with Spring    stackoverflow.com

How can I get JPA(via Hibernate)/Spring and my Container managed connection (via Glassfish 3.1) to play nice? Update: Somehow my JPA connection seems to be buffered. If I modify a record ...

12. Possible for Spring to rollback for everything except log4j error logging to db?    stackoverflow.com

I am having issue with this, as i get into some exception, and i will called log4j to log the error. But all of them are rolled back. Any idea? or ...

13. Spring Pessimistic locking    stackoverflow.com

i have spring project under java, using hibernate query, i like to use pessimistic locking. How to do Pessimistic locking in Spring + Hibernate? Edit:

@Loggable(value = LogLevel.TRACE)
@Transactional
@Override
public void updateBalance(String id, BigDecimal amount) {
 ...

14. Is there a better way of detecting if a Spring DB transaction is active than using TransactionSynchronizationManager.isActualTransactionActive()?    stackoverflow.com

I have some legacy code that I am now trying to re-use under Spring. This code is deeply nested in other code so it's not practical to redesign and is called ...

15. spring jta -with multiple database    stackoverflow.com

I have two database oracle and postgresl and i want to implement transaction for them using JTA I am using fuse servicemix and they expose the javax.transaction.UserTransaction; as osgi service. Now at business ...

16. Spring AOP Transaction Management and Hibernate: undesired commits to database    stackoverflow.com

Is it possible to enable transactions for methods that making calls to DAO (data access object) methods only? class BusinessLayerFacade implements Facade {

//no transaction handling allowed here
public X foo() {
   ...





17. Spring-Hibernate:: How to Ensure data is transmitted correctly from the DB to the Web Server / end user browser and back    stackoverflow.com

I am using a spring hibernate combination for my web application, but I wanted to ensure that when I read particular data from the db it does not change before I ...

18. 2 independent Databases, Hibernate, no Web app - JTA transactions needed?    forum.springsource.org

2 independent Databases, Hibernate, no Web app - JTA transactions needed? Hi, I searched this forum and googled, but could not find an answer to my question. I'm using Spring 3.0.5 ...

19. @Transactional annotatnio and speed of database call    forum.springsource.org

Hi, I am new in transaction management. I have noticed that when I put @Transactional annotation to my method (read objects from db) it performs much more faster than without this ...

20. webService calls within a Transaction cause long DB locks    forum.springsource.org

I have a service method serviceA() which calls daoMethodX(), webServiceY(), and daoMethodZ(). Transactions are declared at the service level, as is most commonly recommended. If an exception occurs at any point ...

21. data base rollback not working with JTA, Appserver database and Oracle DB    forum.springsource.org

Apr 22nd, 2011, 06:50 AM #1 chamhetti View Profile View Forum Posts Private Message Junior Member Join Date Apr 2011 Location Colombo, Sri Lanka Posts 2 data base rollback not working ...

22. Help required on database Transaction Management    forum.springsource.org

Help required on database Transaction Management hi Guys, This is 1st time i am handling transaction management and i am in SOUP. My project consists of spring 3 and hibernate 3. ...

23. long running transaction db lock...    forum.springsource.org

long running transaction db lock... Hey there guys I'm not entirely new to spring but no were near advanced.I searched high and low for a easy example/ explanation for my question. ...

24. performance impliation-volume transactions with frequent database look ups on input    forum.springsource.org

performance impliation-volume transactions with frequent database look ups on input I am trying to read 3000000 records from database tables and process each record one by one. For each of the ...

25. Help Needed with AOP and Database Transactions    forum.springsource.org

Help Needed with AOP and Database Transactions Hello, I am having a problem with controlling when a transaction is committed in the situation below. I two services - Synchronization and DefaultProvisioning ...

26. Example for using two databases w/Spring & JTA transaction manager?    forum.springsource.org

Example for using two databases w/Spring & JTA transaction manager? Hi all, Question for the community. While I've had plenty of occasions to use a single database & single transaction manager ...

27. How to use multiple database in access under one transaction?    forum.springsource.org

We achieved by using SOA. Defined two transaction managers in our context file. We annotated our service like below. @Service("xxx") @Transactional(value = "transactionManagerAnother", readOnly = true) Then you can call the ...

28. Multiple databases and XA Transaction support    forum.springsource.org

Multiple databases and XA Transaction support Hello, I need to integrate XA into my application and I am already using JdbcTemplate but I am not running using Spring container i.e. I ...

29. TransactionManager Question with Three Databases    forum.springsource.org

TransactionManager Question with Three Databases Hello, I have a comprehension question about Spring-Batch and transactionmanager configuration. Lets say I have three different Databases DB-A, DB-B and DB-C. DB-A holds the Data ...

30. Using Declarative Transactions - Not just for db operation    forum.springsource.org

Using Declarative Transactions - Not just for db operation Hi, Using Spring and Hibernate for the first time. Trying to get to grips with declarative transactions. Would appreciate some help. My ...

31. Transaction Manager with two databases    forum.springsource.org

Transaction Manager with two databases Hello. I'm doing very small command line application that imports some data from a database to another database using the JDBC helper classes. I have to ...

32. Guidelines for db usage around transactions    forum.springsource.org

Guidelines for db usage around transactions Hi, I've noticed quite a alot of commits and rollback statements in our legacy PL/SQL application. I believe this may be wrong but wanted to ...

33. Rollback of JTA transaction does not rollback database chang    forum.springsource.org

Rollback of JTA transaction does not rollback database chang I am running in JBoss 4.0.2 wth Spring 1.2.5 and Hibernate 3.1rc1. I am using the OpenSessionInView filter and HibernateTemplate. I am ...

34. Rollback of transaction leaving open cursors in DB    forum.springsource.org

Rollback of transaction leaving open cursors in DB Info: Using Spring 1.2.3, Hibernate 3.0.5, WebLogic 9.0 and Oracle 10g Using DAO extending HibernateDaoSupport Using org.springframework.transaction.jta.WebLogicJtaTra nsactionManager Hibernate, JDBC, and WebLogic all ...

35. Can I get the same transaction for a DB operation and a JNI operation?    forum.springsource.org

The DB operation and the JNI operation will operation the same database, I wonder are there any methold to do the transation between them. I wonder JTA will only work when ...

36. encapsulate db operations inside one transaction    forum.springsource.org

encapsulate db operations inside one transaction Hi to all! I have got a question regarding transactions using HibernateTemplate. I have encountered some performance issues in my project and tracked the problem ...

37. How to check database down from inside transaction boundaries    forum.springsource.org

How to check database down from inside transaction boundaries Hi, I have a scenario where i am trying to persist some data in DB and also send it to JMS queue. ...

38. How can I use Spring for cross database transactions    forum.springsource.org

How can I use Spring for cross database transactions Hi We are using spring framework, hibernate2, java, oracle10g and tomcat in our application. We are managing hibernate sessions using spring. We ...

39. Failure obtaining db row lock: ORA-00942: table or view does not exist    forum.springsource.org

Failure obtaining db row lock: ORA-00942: table or view does not exist i am trying to run jobs using quartz(i am using 1.5.1 version) ;quartz scheduler integrated with Spring framework.i am ...

40. Transactions involving more than one database    forum.springsource.org

Transactions involving more than one database Hi, I am new to spring and hibernate. I am trying to copy data from one database to another using hibernate and spring. I have ...

41. Spring, Databases and the confusing mess that is transaction management.    forum.springsource.org

Spring, Databases and the confusing mess that is transaction management. Hi all, phew! what a frustrating mess this transaction stuff is. All I'm trying to do is create a simple web ...

42. DB rows are locking with readOnly using TransactionProxyFactoryBean    forum.springsource.org

DB rows are locking with readOnly using TransactionProxyFactoryBean We are using the following: Spring v1.2 Hibernate v2.1 WebSphere v5.1 DB2 v8.2.5 Our application is broken in to the following layers: Struts ...

43. DB Connection Problems with Declarative Transactions    forum.springsource.org

Jul 19th, 2006, 02:44 PM #1 booksurge View Profile View Forum Posts Private Message Junior Member Join Date Jul 2006 Posts 15 DB Connection Problems with Declarative Transactions Development Environment: java ...

44. Non-transactional Method not writing to database    forum.springsource.org

Hi-- How can I declare a method --that persists to a file --Non-transactional? The idea is that anything happens in this method, this method doesn't affect the normal processing of the ...

45. Managing transactions between database and non database systems    forum.springsource.org

Managing transactions between database and non database systems Hello. I have the following scenario: ------------------------------------------------ |---------------Java Application-----------------| ------------------------------------------------ ---------------------- ---------------------- |-- Oracle Database --| |-- Other System --| ---------------------- ---------------------- In ...

46. Database transaction properties (types & when to use which)?    forum.springsource.org

Can someone please tell me how many type of database transaction properties are there -- some of them i do know --> e.g. = 1) PROPAGATION_SUPPORTS, 2) PROPAGATION_REQUIRED, 3) readOnly, 4) ...

47. Transactions against a read-only database.    forum.springsource.org

Transactions against a read-only database. I have a database which is read-only, it's being published from a different part of the system, so the database is tuned for the views it ...

48. locking at the db level    forum.springsource.org

locking at the db level Greetings, Help! Is there any way to obtain a database lock, I mean lock at the database level, like Read Committed lock from either JPA or ...

49. Hibernate transactionmanager and database locking    forum.springsource.org

Hello, I'm having some problems in finding the answer on the following matter. When I add a transactionmanager to a bean with ISOLATION_SERIALIZABLE. Does this result in locks on the database? ...

50. Connecting to multiple databases and using declarative transactions    forum.springsource.org

Connecting to multiple databases and using declarative transactions I am new to spring framework and interested in declarative transaction management for my application. I am aware that spring supports both declarative ...

51. URGENT - Changing Hibernate (database) schemas during transaction    forum.springsource.org

Hi, I have an unique problem. we have different schemas for different customers all having the same tables say mts and mos tables Based on where the message came from, we ...

52. Transaction Management for Two Databases    forum.springsource.org

Transaction Management for Two Databases I have connection to two database from a Spring 1.2 application. One database is in Oracle and the other in DB2. i have created two datasources ...

53. Locking down a database call    forum.springsource.org

Hi guys, I am using Struts/Hibernate/Spring Is this possible?? I need to create about 600 rows in a table. The primary key has a database sequence to generate ID's. How would ...

54. Database lock downs    forum.springsource.org

Database lock downs Hey all We recently deployed an application using Spring/Hibernate and are experiencing serious database lockdowns (e.g. no queries are made against the db, we have to reboot the ...

55. DB connection leak with declarative JTA transaction on Hibernate    forum.springsource.org

Jul 11th, 2007, 12:21 PM #1 AshokB View Profile View Forum Posts Private Message Junior Member Join Date Jul 2007 Posts 1 DB connection leak with declarative JTA transaction on Hibernate ...

56. Using Transaction for hibernate and oracle as DB    forum.springsource.org

Hi All I am using the spring hibernate template to save into DB..I have not yet used transaction...How can i define the transaction manager for hibernate in spring config and also ...

57. Defining a Transaction for spring with hibernate and Oracle as DB    forum.springsource.org

Hi All I am using the spring hibernate template to save into DB..I have not yet used transaction...How can i define the transaction manager for hibernate in spring config and also ...

58. Transactions that don't involve databases: How?    forum.springsource.org

Transactions that don't involve databases: How? Hi, Well, the title wasn't that accurate but here's the scenario: I have a webapp for user registration that does the following: * Adds the ...

59. can it support a database with no transactions?    forum.springsource.org

Our core database we are looking to implement Spring Batch on a database with no transactions (Informix). Is it possible to customize the transaction handling in Spring Batch so we can ...

60. Without @Transactional nothing is writen to database    forum.springsource.org

Without @Transactional nothing is writen to database Hello everyone, I've been recently writing a small aplication, in which I use JPA-based persistence (with Hibernate under the hood) and annotation-driven transaction control. ...

61. Multiple Databases, JPA and Transaction    forum.springsource.org

Multiple Databases, JPA and Transaction Hi, I'm stuck with a problem with multiple databases, JPA and transaction handling. I have an application that deals with multiple databases (that all have the ...

62. Best approach to multiple-database transactions    forum.springsource.org

Best approach to multiple-database transactions We need to support transactions for multiple databases (not XA) and I was wondering what the best approach would be to support this in Spring. WE ...

63. Which transaction to use on a clustered database    forum.springsource.org

Which transaction to use on a clustered database According to the spring reference manual local transaction cannot work across multiple transactional resources. For that one need a global transaction and JTA. ...

64. Multiple webapps, one database, and TransactionProxyFactoryBean    forum.springsource.org

Multiple webapps, one database, and TransactionProxyFactoryBean I have two web apps using the same database to insert data (no deletes or updates). I am worried about the possibility of two simultaneous ...

65. Transactional rollBack if something goes wrong in the internal database.    forum.springsource.org

Transactional rollBack if something goes wrong in the internal database. Hi, I splitted the datasource for the Business object from the datasource used by Spring Batch. And my problem is that ...

66. 2 Persistance Technologies, 1 database...Transactions possible?    forum.springsource.org

2 Persistance Technologies, 1 database...Transactions possible? Hi, I have an application that uses a mixture of 2 persistance technologies (Hibernate & proprietary). Is it possible to have Transaction support? The application ...

67. Performing transaction across multiple database    forum.springsource.org

I need to write a job that should read and then update three diff databases DB 1 - Oracle DB 2 - Oracle RDB DB 3 - Oracle RDB In a ...

68. Why is DB connection acquirered when transactions starts?    forum.springsource.org

Why is DB connection acquirered when transactions starts? Hi, I'm using Spring for transaction management (using annotations), and c3p0 and hibernate. I have noticed that as soon as I start a ...

69. Transactions across multiple databases    forum.springsource.org

Transactions across multiple databases Can someone confirm if I'm right to say: 1. If I use an Oracle DB to store the Batch meta data and a DB2 DB for the ...

70. How lock a database register    forum.springsource.org

How lock a database register Hi all, That's what I need: Select an unique register and lock it, both read and write. On demand, unlock register and update its value. Thats' ...

71. Spring Integration test not rollback changes made to db    forum.springsource.org

Spring Integration test not rollback changes made to db Hi I am trying to create an integration test which looks like this: Code: @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(locations={"/context-dao.xml"}) @TransactionConfiguration(transactionManager="transactionManager", defaultRollback=true) public class UserIntTest { ...

72. DB driver that supports read-only transaction    forum.springsource.org

Could someone tell me which DB and JDBC DB drivers support Spring's read-only transaction (conn.setReadOnly(true)?) if I use DataSourceTransactionManager? I'm currently using MS SQL + JTurbo + IBatis, but the read-only ...

73. Occasional database dead lock    forum.springsource.org

May 11th, 2009, 09:05 PM #1 couzteau View Profile View Forum Posts Private Message Member Join Date Aug 2007 Posts 99 Occasional database dead lock Hi guys and girls, I have ...

74. Read off Q and write to database as a transaction    forum.springsource.org

May 12th, 2009, 01:06 PM #1 dudleygb View Profile View Forum Posts Private Message Senior Member Join Date Nov 2006 Posts 193 Read off Q and write to database as a ...

75. master/slave db access with hibernate sessionfactory/transaction support?    forum.springsource.org

May 29th, 2009, 07:54 PM #1 olegula View Profile View Forum Posts Private Message Junior Member Join Date Dec 2004 Posts 7 master/slave db access with hibernate sessionfactory/transaction support? Hi, I ...

76. Saving to database and properties file in same transaction    forum.springsource.org

Saving to database and properties file in same transaction I am using JPA(Hibernate implementation) to store entities in database . I have a scenario wherein i need to save values to ...

77. DB activity during testing with a transactionManager not rolling back?    forum.springsource.org

[SOLVED, maybe]DB activity during testing with a transactionManager not rolling back? I've been using Spring for a few months now. I am using Spring JDBC for DB access and when I ...

78. Transaction across schemas in a database    forum.springsource.org

Transaction across schemas in a database Hi All, We are using Spring + JPA with hibernate for our project. We have to access three different schemas within a database(oracle). How does ...

79. DB Transaction question    forum.springsource.org

ps: i suggested to do versioning/timestamping and optimistic locking, but it was being frowned by people i talked to.. they say i shouldnt worry about that stuff.

80. Database transactions and exceptions don't mix! (can Spring help?)    forum.springsource.org

Database transactions and exceptions don't mix! (can Spring help?) Lately I've been trying to improve how our web application employs transactions (we don't use them enough). While doing this I became ...

81. Ist it possible to add transaction to OLAP database accesses?    forum.springsource.org

Ist it possible to add transaction to OLAP database accesses? Hello everybody, I have a MVC web application that provides access to Palo OLAP database. There are synchronization problems in the ...

82. After commiting the transaction data not getting updated in database even no error    forum.springsource.org

After commiting the transaction data not getting updated in database even no error Hi All, We're using DataSourceTransactionManager for implementing transaction management in our Spring-MVC 2.5 application. Its been felt that ...

83. After commiting the transaction data not getting updated in database even no error    forum.springsource.org

After commiting the transaction data not getting updated in database even no error Hi All, We're using DataSourceTransactionManager for implementing transaction management in our Spring-MVC 2.5 application. Its been felt that ...

84. XA DB transaction not rolling back.    forum.springsource.org

XA DB transaction not rolling back. Hi my app needs to use XA as it has to complete 1 MQ and 1 DB transaction in one shot. The problem is that ...

85. possible to rollback multiple database transactions ?    forum.springsource.org

possible to rollback multiple database transactions ? Using Spring 3, hibernate xml, and HibernateTemplate in HibernateDaoSupport My scenario is this- the user submits a form and an object is created and ...

86. Single DB - Multiple Web App Shared Data locking design?    forum.springsource.org

Single DB - Multiple Web App Shared Data locking design? Hello All, Can anyone suggest a design approach for managing the state of a object as it is shared between two ...

87. Database level locking in ItemWriter    forum.springsource.org

Database level locking in ItemWriter HI All, I am working in Spring batch 2.1. While performing partioning with grid size = 5 , partioning is working fine. but when my grid ...

88. AOP, Validation (JSR-303), and DB Transactions    forum.springsource.org

AOP, Validation (JSR-303), and DB Transactions In short, I want to perform JSR-303 validation on parameters to a @Transaction method, but have the validation performed before the database transaction is begun. ...

89. Transactional init: how to initialize DB when starting?    forum.springsource.org

Transactional init: how to initialize DB when starting? Hello, My component uses small in-memory database operated by HSQL+Hibernate JPA. When application starts I need to fill the database with a default ...

90. Transactions spanning database and server upload etc.    forum.springsource.org

Transactions spanning database and server upload etc. Hi, I am pretty much a beginner with Spring, and I am trying to set up a new architecture with Spring and Hibernate. We ...