jdbctemplate « Transaction « Spring Q&A





1. Spring JDBCTemplate Table Locking with MySQL    stackoverflow.com

I just migrating one of our applications from pure JDBC to Spring's JDBCTemplate. I was wondering how to create a write lock for a table. Do i just execute a "LOCK ...

2. How exactly JdbcTemplate with TransactionManager works together?    stackoverflow.com

As far as I understood DataSourceTransactionManager binds a JDBC connection from the specified DataSource to the current thread, allowing for one thread-bound Connection per DataSource. If it's a pool of connections, ...

3. Firebird query is crashing with org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544364. request synchronization error    stackoverflow.com

I am using JdbcTemplate.queryForInt to insert a Row into the DB, and then get the ID back. The Query is "INSERT INTO metadocs(NAME) values (?) RETURNING METADOCID". If I run the statement ...

4. jdbctemplate and optimistic locking    stackoverflow.com

In the project I'm in Hibernate and Spring jdbctemplate are mixed. I added optimistic locking. Hibernate works great with versioning but now I have to tansform all this jdbctemplate code to ...

5. Sharing a Spring transaction between hibernate & JdbcTemplate within a AbstractTransactionalTestNGSpringContextTests    stackoverflow.com

I'm running a test within a subclass of AbstractTransactionalTestNGSpringContextTests, where I execute tests over a partial Spring context. Each test runs within a transaction, which is rolled back at the end ...

6. Spring JDBC appearing to randomly rollback transactions    stackoverflow.com

I was checking database consistencies during my web application testing and I discovered a strange occurrence. There is a gap of Id's in every table between certain times. ie, Every ID between ...

7. Spring XA Transactions With Oracle JDBC Driver    stackoverflow.com

I am trying to enable distributed transactions using bitronix transaction manager. Configuration Details include

  1. Using OCI JDBC Driver and oracle.jdbc.xa.client.OracleXADataSource. This datasource is wrapped around by UCP connection pooling datasource - ...

8. how can I use sql transactions?    stackoverflow.com

I have a Mysql server with ndbcluster engine which supports transactions. I want to use transactions with my Java application under tomcat 6 with Spring JDBC framework 3.0.6. I have a DataSource bean ...

9. JdbcTemplate rollback not working    forum.springsource.org

JdbcTemplate rollback not working Hi All I have written a simple (standalone) application using spring 3 to test how transaction management works with JdbcTemplate and mysql database. All source files are ...





10. Transaction doesnt rollback JdbcTemplate MySql    forum.springsource.org

Jan 27th, 2011, 12:42 PM #1 KaraPirinc View Profile View Forum Posts Private Message Junior Member Join Date Jan 2011 Posts 4 Transaction doesnt rollback JdbcTemplate MySql Hi, I am testing ...

11. Wrapping JdbcTemplate with TransactionProxyFactoryBean    forum.springsource.org

Wrapping JdbcTemplate with TransactionProxyFactoryBean hello, I am using Spring inside an EJB (on Weblogic). Until now I was using one database only and everything was nice. The EJB had a 'transaction ...

12. How to use Spring 3.x JdbcTemplate with NO transaction?    forum.springsource.org

How to use Spring 3.x JdbcTemplate with NO transaction? Hi all, I need to invoke some sql and it needs to be done outside a transaction. It's being done on a ...

13. JdbcTemplate transaction on 2 datasource    forum.springsource.org

Hello, I have 2 database and want to do update on both or none at all. I tried using transactions but my code throws Code: java.lang.IllegalStateException: Cannot deactivate transaction synchronization - ...

14. JdbcTemplate does not participate in JTA transaction    forum.springsource.org

JdbcTemplate does not participate in JTA transaction Hi, I am trying to use the JdbcTemplate so that it participates in a JTA transaction. I have set up the configuration to specify ...

15. Transaction rollback problem with JdbcTemplate    forum.springsource.org

Transaction rollback problem with JdbcTemplate I have Junits testing JdbcTemplate based persisters outside of the app server environment. The code flow looks like this: ............... OracleConnectionPoolDataSource oracleDataSource = new OracleConnectionPoolDataSource(); String ...

16. savepoints and rollback using jdbctemplate??    forum.springsource.org





17. transaction management in data base calls using JdbcTemplate    forum.springsource.org

transaction management in data base calls using JdbcTemplate hi all, i am a programmer very new to spring. i eould like to know if the below mentioned functionality is suported by ...

18. JdbcTemplate and rollback on exceptions    forum.springsource.org

Does JdbcTemplate perform a rollback when exceptions occur ? I have call to the JdbcTemplate.call method. In the CallableStatementCreator class I then hava different statements which issue calls to Oracle PL/SQL ...

19. HibernateTemplate and JdbcTemplate in one transaction ??    forum.springsource.org

HibernateTemplate and JdbcTemplate in one transaction ?? Hi All, In my new application which I am designing, I am planning to use HibernateTemplate and JdbcTemplate at data access layer and planning ...

20. JdbcTemplate lock database in OOC    forum.springsource.org

JdbcTemplate lock database in OOC I am using JOTM, with enhydra XA datasources. All integration tests, extending springs transactional test is working just fine. Now I am about to set up ...

21. Executing many jdbcTemplate.execute(String sql) does not rollback to before the first    forum.springsource.org

Apr 20th, 2007, 04:40 PM #1 jboring View Profile View Forum Posts Private Message Member Join Date Aug 2004 Posts 63 Executing many jdbcTemplate.execute(String sql) does not rollback to before the ...

22. Transaction not rolling back when using JDBCTemplate    forum.springsource.org

Transaction not rolling back when using JDBCTemplate Hi, I have a requirement where i need an all or nothing transaction meaning all inserts go thru or nothing goes thru. So i ...

23. jdbcTemplate vs Hibernate / how to synchronize    forum.springsource.org

jdbcTemplate vs Hibernate / how to synchronize hi all, i have an app which is mainly hibernate based.. unfortunately, due to some constraints, it turns out that the best way in ...

24. JdbcTemplate and releasing a lock    forum.springsource.org

JdbcTemplate and releasing a lock Hello, I am trying to append some values to a Clob in an Oracle database. For this purpose I'm executinng this query: "SELECT CLOB_COLUMN FROM CLOB_TABLE ...

25. Transaction Management with JdbcTemplate    forum.springsource.org

Transaction Management with JdbcTemplate Dear all, I am fairly new to spring. I am making a web app using JdbcTemplate(around 80+ tables with simple constraints. I have done a fair bit ...

26. JpaTransactionManager/@Transactional/JdbcTemplate - roll backs not working    forum.springsource.org

JpaTransactionManager/@Transactional/JdbcTemplate - roll backs not working Hi all, I'm successfully using JPA (with hibernate as the provider) in my application with the 'tx:annotation-driven' configuration, a JpaTransactionManager, and @Transactional annotations. I'm trying ...

27. JDBCTemplate and locking    forum.springsource.org

Hi! I am getting the following error: Timeout when waiting for a lock. I am using JDBCTemplate and want to know if I use queryForList it will get the data I ...

28. Strange transaction behaviour with JdbcTemplate    forum.springsource.org

Strange transaction behaviour with JdbcTemplate I'm using JdbcTemplate and suddenly my service CRUD unit tests are failing. The test just inserts records then pulls them back out to make sure they ...

29. RollBack Not Working JdbcTemplate    forum.springsource.org

RollBack Not Working JdbcTemplate Hi EveryOne I'm Working with JdbcTemplate, I have some parts of my Application that needs to do various operation with jdbcTemplate as a transaction, I have a ...

30. The update function with parameters in JdbcTemplate dose not support Transaction?    forum.springsource.org

The update function with parameters in JdbcTemplate dose not support Transaction? I am using TransactionTemplate to control transaction, but it seems like the update function with parameters can not support transaction, ...

31. JTA Transaction Manager and JDBCTemplate    forum.springsource.org

JTA Transaction Manager and JDBCTemplate I have spent hours looking through these forums but no one seems to have the answer to my problem. I am using weblogic jta transaction manager ...

32. JdbcTemplate, Transaction Rollback issue with "defaultAutoCommit"    forum.springsource.org

JdbcTemplate, Transaction Rollback issue with "defaultAutoCommit" Hi, Thanks in advance for your inputs/suggestions. Since last two days i am facing the issue with Spring transaction rollback. i am using Tomcat 5.5.28 ...

33. Problem with JdbcTemplate and transactions not rolling back    forum.springsource.org

Problem with JdbcTemplate and transactions not rolling back I'm having an issue trying to implement transactions in a spring mvc project - when I throw an exception, the inserts I've performed ...