Spring Transactions
Hi there, I have an implementation of my model with OJB using just PersistenceBroker. Now I'm looking into adding transactional support, looked into ODMG but it seems complex to implement since all my mapping and query is in Broker lingo, so I'm looking at injecting Transaction support for my process methods with spring, that way I shouldn't need to change config files and just one class that interfaces with the Broker. Now, I tried to look for samples outthere found this http://www.springframework.org/node/116 But after setting it up transactions don't seem to be happening. So my questions are. 1- Do I need to use InnoDB on Mysql ? My tables are MyIsam. 2- Am I missing any other feature besides applicationContext setup and deriving my class from PersistenceBrokerDaoSupport? Here is the applicationContext.xml beans !-- Transaction manager for a single OJB PersistenceBroker (alternative to JTA) -- bean id=transactionManager class=org.springframework.orm.ojb.PersistenceBrokerTransactionManager/ bean id=genericProcess class=com.met.process.Generic/ bean id=payrollManager class=org.springframework.transaction.interceptor.TransactionProxyFactoryBe an property name=transactionManager ref local=transactionManager/ /property property name=target ref local=genericProcess/ /property property name=transactionAttributes props prop key=complete*PROPAGATION_REQUIRED/prop prop key=terminate*PROPAGATION_REQUIRED/prop prop key=*PROPAGATION_REQUIRED,readOnly/prop /props /property /bean /beans Thanks Sam
Re: Spring Transactions
On 3/9/06, Saman Ghodsian [EMAIL PROTECTED] wrote: I have an implementation of my model with OJB using just PersistenceBroker. Now I'm looking into adding transactional support, looked into ODMG but it seems complex to implement since all my mapping and query is in Broker lingo, so I'm looking at injecting Transaction support for my process methods with spring, that way I shouldn't need to change config files and just one class that interfaces with the Broker. Now, I tried to look for samples outthere found this http://www.springframework.org/node/116 First, you should have a look at the PetStore sample in Spring, which includes OJB support. Also of interest is this: http://staff.osuosl.org/~mckerrj/?p=3. But after setting it up transactions don't seem to be happening. So my questions are. 1- Do I need to use InnoDB on Mysql ? My tables are MyIsam. You should definitely ask this in the Spring forums. Or rather, search the forums - MySql is a commonly used DB so there is bound to be some questions regarding it. 2- Am I missing any other feature besides applicationContext setup and deriving my class from PersistenceBrokerDaoSupport? See the tutorial above. In short, you'll need the LocalDataSourceConnectionFactory that spring provides, in OJB.properties, and you need to declare the transaction wrapping in the applicationContext.xml around your management or DAO objects (management objects are preferred which logically bundle DB accesses provided by one or more DAOs). Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Spring Transactions
YES you need innoDB, myIsam does not support transactions, i guess you want transactions. regards, Dennis 2006/3/10, Thomas Dudziak [EMAIL PROTECTED]: On 3/9/06, Saman Ghodsian [EMAIL PROTECTED] wrote: I have an implementation of my model with OJB using just PersistenceBroker. Now I'm looking into adding transactional support, looked into ODMG but it seems complex to implement since all my mapping and query is in Broker lingo, so I'm looking at injecting Transaction support for my process methods with spring, that way I shouldn't need to change config files and just one class that interfaces with the Broker. Now, I tried to look for samples outthere found this http://www.springframework.org/node/116 First, you should have a look at the PetStore sample in Spring, which includes OJB support. Also of interest is this: http://staff.osuosl.org/~mckerrj/?p=3. But after setting it up transactions don't seem to be happening. So my questions are. 1- Do I need to use InnoDB on Mysql ? My tables are MyIsam. You should definitely ask this in the Spring forums. Or rather, search the forums - MySql is a commonly used DB so there is bound to be some questions regarding it. 2- Am I missing any other feature besides applicationContext setup and deriving my class from PersistenceBrokerDaoSupport? See the tutorial above. In short, you'll need the LocalDataSourceConnectionFactory that spring provides, in OJB.properties, and you need to declare the transaction wrapping in the applicationContext.xml around your management or DAO objects (management objects are preferred which logically bundle DB accesses provided by one or more DAOs). Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- mvg, Dennis