DataSource « Transaction « Spring Q&A





1. Proper way to set up transactions in Spring for different data sources?    stackoverflow.com

I have an application which needs to connect to multiple databases. This is an administrative application which is basically used to manage entries in different databases - we do not need ...

2. spring multiple @transactional datasource    stackoverflow.com

    <bean id="transactionManager"
     class="org.springframework.orm.jpa.JpaTransactionManager">
     <property name="entityManagerFactory" ref="data.emf" />
    </bean>


<tx:annotation-driven transaction-manager="transactionManager" />

    <bean id="transactionManager2"
  ...

3. transactionmanager using same datasource    stackoverflow.com

(connected to db call abc)--->datasource1 ---> LocalSessionFactoryBean --->transactionManager1 (connected to db call abc)--->datasource1----->AnnotationSessionFactoryBean -->transactionManager2 the reason i have 2 sessionfactory is because one is used by 3rd party osworkflow library and ...

4. Configure spring datasource for hibernate and @Transactional    stackoverflow.com

at this moment i'm using DriverManagerDataSource with @Transactional annotation to manage transaction. But all transactions are very very slow, i think becouse data source open and close connection to db every ...

5. Multiple SessionFactories, multiple DataSources and Hibernate TransactionManager can take only one Sessionfactory    stackoverflow.com

I have @Transactional annotation in all my DAOs, but I can only define one TransactionManager that takes only one SessionFactory. I have one SessionFactory per customer, one DataSource per customer and ...

6. spring data source transaction manager not rolling back    stackoverflow.com

<!-- Data source definition -->
<bean id="dataSourceWebsube"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource"
    p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.url.websube}"
    p:username="${jdbc.username.websube}"   p:password="${jdbc.password.websube}" />

<bean id="jdbcTemplateWebsube" class="org.springframework.jdbc.core.JdbcTemplate">
    <property name="dataSource" ref="dataSourceWebsube" ...

7. Datasource and transaction manager scope in Spring?    stackoverflow.com

In a spring application what should be the scope of datasource and transaction manager?As per my understanding both should be singleton. Is that correct?

8. spring multiple @transactional datasource    stackoverflow.com

I need to use two different dataSources/transactionManagers for different methods. The concept with @Transaction(value="txManagerABC") and a defined qualifier in the applicationContext for the transaction manager is perfect. (As seen in

9. Spring transaction multiple datasource    stackoverflow.com

I am having two datasource one for oracle and other for postgresql and both are used in same business method . How i can make this bussiness method transactional using spring ...





10. JTA 2PC - with multiple datasource    stackoverflow.com

I am new to JTA and i am trying to implement the JTA 2 pc .In business method I want if fun1 fails then fun3 should also but its not ...

11. oneToMany bidirectional does not work when datasource has transactions set as serializable    stackoverflow.com

i have a app that uses Spring,Struts, Hibernate and JPA. So i have two entities, Company and Location. Company is in oneToMany relation with Location, and location in ManyToOne to Company. Location ...

12. Enlisting Custom DataSource with JTa    forum.springsource.org

Enlisting Custom DataSource with JTa Hello, We are building an application which uses a legacy database schema on Oracle. Security is managed in database by using USER function of oracle sql, ...

13. Single Datasource + Multi JPA module jars + Transactional    forum.springsource.org

Single Datasource + Multi JPA module jars + Transactional Hi I need to configure my project to work with 2 persistence units, 1 transaction manager and 1 datasource. Ive looked all ...

14. JTA - XA Datasources    forum.springsource.org

There's not much of a reason to use an XA datsource if you don't actually need XA (two phase commit, basically) capabilities, and/or your environment (like the DB) doesn't support XA. ...

15. Spring Data Source Transaction Manager Not Rolling Back    forum.springsource.org

Spring Data Source Transaction Manager Not Rolling Back Code:

17. JTA propagation - XA datasources in glassfish 3 - not behaving    forum.springsource.org

JTA propagation - XA datasources in glassfish 3 - not behaving Hi all I've got a set up that is using JPA persistence.xml with JTA transactions from Glassfish 3. There are ...

18. A JDBC and a JPA operation on different datasources in same transaction    forum.springsource.org

Is there a way to manage a JDBC operation on a datasource and a JPA operation on another datasource transactionally? If yes how would I configure this? Would I use a ...

19. Transaction management for Two session factories with two data sources    forum.springsource.org

Transaction management for Two session factories with two data sources I am using two session factories each one has separate data source. I have one method in a service that read ...

20. Spring JDBC datasource Failover (prim and sec ) and Declarative Transactions.    forum.springsource.org

Spring JDBC datasource Failover (prim and sec ) and Declarative Transactions. The following configuration is failing with the error " java.lang.ClassCastException: com.att.scld.workq.util.DataSourceEvaluater cannot be cast to javax.sql.DataSource". I have two dataSources: ...

21. multiple DataSources without JTA    forum.springsource.org

multiple DataSources without JTA hello, We have a situation where the same kind of data is in three different databases. (One user's account data is in one database and another user's ...

22. Transaction Management over 2 different data sources    forum.springsource.org

Transaction Management over 2 different data sources I am rewriting a legacy application using the spring framework. The legacy database is a c-isam cobol filesystem with a somewhat working JDBC driver ...

23. Multiple/Dynamic Datasource and TransactionManager Binding    forum.springsource.org

Multiple/Dynamic Datasource and TransactionManager Binding We are facing design issues related to use of data source in the spring framework, below is the detailed information for the same: In our application, ...

24. Need help with multiple datasource transaction configuration    forum.springsource.org

Need help with multiple datasource transaction configuration Hi, I have an application that needs to support two databases with identical schema (not data), but at any one time only connection is ...

25. Transaction management with multiple data sources    forum.springsource.org

Transaction management with multiple data sources I have service classes using multiple data sources and it depends on the arguments of the service method which data source is used each time. ...

26. Multiple datasources with autonomous transactions    forum.springsource.org

Multiple datasources with autonomous transactions Hello, I need to connect to multiple datasources in my application. I do need transactions too, as I need to do write operations, but I do ...

27. Hibernate one transaction two session Factories one DataSource    forum.springsource.org

Mar 8th, 2006, 10:45 AM #1 paul_d_austin View Profile View Forum Posts Private Message Junior Member Join Date Mar 2006 Posts 11 Hibernate one transaction two session Factories one DataSource I ...

28. Two datasources in one transaction manager    forum.springsource.org

How do I specify in the spring config files to use two separate datasources within same jta transaction manager (need two phase commit)? I need to solve it in out of ...

29. Coordinating transactions across multiple DataSources    forum.springsource.org

Coordinating transactions across multiple DataSources I am having troubles understanding Spring's transaction model (using PlatformTransactionManager)... If I have several data sources, it seems that: 1) I set up a txManager around ...

30. JTA with Jencks, Hibernate and multiple XA datasources    forum.springsource.org

Nov 30th, 2006, 03:53 PM #1 Juergen Mayrbaeurl View Profile View Forum Posts Private Message Member Join Date Nov 2005 Location Austria Posts 38 JTA with Jencks, Hibernate and multiple XA ...

31. How to use multiple data sources with @Transactional    forum.springsource.org

How to use multiple data sources with @Transactional Hi, I have a situation where I need to access two different databases through two different data sources. I would like to use ...

32. Transaction Control over multiple datasources    forum.springsource.org

Transaction Control over multiple datasources I'm relatively new to iBatis and am hoping someone can offer me some form of transaction management advise? I'm using Spring MVC with iBatis, and so ...

33. How to configure multiple datasources for transactionManager    forum.springsource.org

Code:

34. Transactional Retry with Programatically Configured DataSource    forum.springsource.org

Transactional Retry with Programatically Configured DataSource I am working on an application which requires that I programmatically create and configure 1 or more DataSources. The DataSources can NOT be configured either ...

35. Transaction Management using WAS 6.1 datasource    forum.springsource.org

36. managing datasource pools in a transaction    forum.springsource.org

managing datasource pools in a transaction hi, the context i'm working with an application that has to support connectivity to multiple remote DB end-points, each with their own connection pool (using ...

37. transactions across multiple datasources    forum.springsource.org

transactions across multiple datasources Hi, I have a DAO that extends HibernateDaoSupport and is proxied by a TransactionProxyFactoryBean. The relevant dataSource, sessionFactory, and transactionManager are all defined in a standard way. ...

38. @Transactional and 2 datasources    forum.springsource.org

Currently, you can't. You can vote on a Jira issue SPR-3844. In the meantime, I have created my own implementation which I am willing to share here if you want. It ...

39. Spring JTA and WAS 6 datasource    forum.springsource.org

Hi, We are trying to use Spring JTA transaction with WAS 6 datasource. WAS 6 datasource by default has autocommit as true as we operate within an LTC and have its ...

40. Error looking up jta-datasource by name : jdbc/__default    forum.springsource.org

Mar 11th, 2008, 11:13 AM #1 juliedaniel View Profile View Forum Posts Private Message Junior Member Join Date Mar 2008 Posts 1 Error looking up jta-datasource by name : jdbc/__default My ...

41. TransactionManager and multiple data sources    forum.springsource.org

TransactionManager and multiple data sources Hi, I had a question, and the title of this thread pretty much explained it. I have 2 datasources and I would like to have 1 ...

42. Second datasource will not commit transaction    forum.springsource.org

I have now solved this issue. It was a coding error in my Java classes and not a spring/hibernate config error. I have tried my spring-config in a couple of different ...

43. missing datasource for transaction    forum.springsource.org

missing datasource for transaction When i want implement transaction in DAO, i am getting this error : Code: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'eraserTransactional' defined in ServletContext resource [/WEB-INF/applicationContext/business-context.xml]: Invocation ...

44. JTA/XA automatic enlisting DB connect. in transaction-two datasources (1-XA, 2-noXA)    forum.springsource.org

JTA/XA automatic enlisting DB connect. in transaction-two datasources (1-XA, 2-noXA) hi, Is it possible to have 2 datasources in application container (e.g. Weblogic) where one points to XA aware datasource e.i. ...

45. Roll back a Transaction across TWO datasources in SPRING framework    forum.springsource.org

Roll back a Transaction across TWO datasources in SPRING framework Hi, I am new to Spring and this is my first project. I have issue with ROLLBACK across TWO diff datasources ...

46. Transaction over two datasources    forum.springsource.org

Transaction over two datasources Hi, I've a question related to transactions. I've programmed a desktop application that works with two datasources, one for an oracle instance and the other for an ...

47. Method DataSourceUtils.getConnection(datasource) & transactions    forum.springsource.org

Hi all, sorry my bad english: I'm using declarative transactions: The method DataSourceUtils.getConnection(datasource) must retrieve the connection that it's associated to a thread in a transaction but we have the problem ...

48. Dispatching the readOnly transactions to a Slave DataSource    forum.springsource.org

Dispatching the readOnly transactions to a Slave DataSource For our application we use master/slave mysql database replication. The Master permits Read/Write while the Slaves permit only Reads. In the application layer ...

49. Session VS Transaction VS Datasource    forum.springsource.org

Session VS Transaction VS Datasource Hi good people, am really confused with these terms as am new to Java and DBs... I will use Qs to help get direct responses 1. ...

50. JTA transactionManager unaware of DataSource?    forum.springsource.org

JTA transactionManager unaware of DataSource? I just plugged in a JBossTS JTA implementation into the following stack Tomcat 6 Spring 2.5 Hibernate 3.3.1 JBossCache 3 C3p0 Connection Pool (mysql) Now JDBC ...

51. notWritableProperty using jpa/jta and multiple datasource    forum.springsource.org

notWritableProperty using jpa/jta and multiple datasource hi all... i'm trying to setup transactions for multiple datasources (jta/xa) and running into a problem. here's my data access setup: Code:

52. Transaction without a datasource ?    forum.springsource.org

Transaction without a datasource ? Hi, I am working on a java application, which do not have direct access to the datasource(Mainframe DB2) . But these jave programs do have access ...

53. Transaction without a datasource ?    forum.springsource.org

Transaction without a datasource ? Hi, I am working on a java application, which do not have direct access to the datasource(Mainframe DB2) . But these jave programs do have access ...

54. multiple datasource, xa transaction?    forum.springsource.org

55. Two datasources and annotated transactions    forum.springsource.org

Two datasources and annotated transactions Hi guys, I've managed to set up annotated transacions and it works fine with one datasource. But I have another datasource which points to different database. ...

56. Two datasources and annotated transactions    forum.springsource.org

Two datasources and annotated transactions Hi guys, I've managed to set up annotated transacions and it works fine with one datasource. But I have another datasource which points to different database. ...

57. Connectio to multiple datasource and transactions    forum.springsource.org

Connectio to multiple datasource and transactions Hi, I have a test case where I need to connect to 2 different databases. I am currently using spring 2.5.6 and hibernate 3.3.1 I ...

58. How to define a Transaction Manager with a chaning data source at Runtime?    forum.springsource.org

How to define a Transaction Manager with a chaning data source at Runtime? Hello, Because of sharding, we have multiple data sources. And we injected a list of all available data ...

59. HowTo - Two ordinal nonXA-datasources in one spring application (with No JTA support)    forum.springsource.org

HowTo - Two ordinal nonXA-datasources in one spring application (with No JTA support) Hello, It is possible have two ordinal (nonXA)datasources in one spring application with seamless use @Transactional ? I ...

60. Transaction Management w/ 2x dataSources    forum.springsource.org

Oct 15th, 2009, 01:36 PM #1 atwoodjw View Profile View Forum Posts Private Message Junior Member Join Date Oct 2009 Posts 1 Transaction Management w/ 2x dataSources I need to support ...

61. Transaction Management for one datasource and two hibernate session factories    forum.springsource.org

Transaction Management for one datasource and two hibernate session factories Hi I would like to know how to apply/use transactions on a application with "one datasource" and "two hibernate session factories". ...

62. multiple datasource in transaction manager    forum.springsource.org

multiple datasource in transaction manager Hi, I have an application that need to connect to multiple database (it can be any database, sql server, mysql, hqldb,etc). I'm using Transaction Management, so ...

63. Dynamically adding transaction managers/session factories/data sources    forum.springsource.org

You can't "DI existing service beans with those objects" with Spring (not out of the box, that is). If you refresh the context, you will create new instances of all the ...

64. Pre-bound JDBC Connection Found error while using 2 data sources in transaction    forum.springsource.org

Pre-bound JDBC Connection Found error while using 2 data sources in transaction We have a service that talks to 2 different DAO (using hibernate). Each DAO has its own HibernateTransactionManager. One ...