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