Thanks, Martin! but I searched the TDK i've downloaded and there is no db.props file. There is also no torque-gen.jar (i have the torque-3.0-rc2.jar)
Since the table type is specified in only a single file (i.e. db.props) I assume that the specified type is used in all tables in the database. Since InnoDB and MyIsam has their own advantages, i want to use InnoDB for some tables and MyIsam in others. Could someone please suggest some ways to do that. What I was planning to do was execute torque in its default configurations then edit the sql scripts generated (to specify the table type), then manually create the database. Would that work? Are there other configuration settings that I should modify? Thanks! --- [EMAIL PROTECTED] wrote: > > Clinton, > > You're right, the file to change is indeed db.props. > This file is part > of the torque-gen jar file since it is used to > generate the Torque > classes > code. It is located somewhere in the 'templates' > directory (sorry I > don't > remember the exact path by heart). > > Hope this helps! > > MG > -- > Martin Goulet, B.Sc. > Senior Software Architect > SunGard Front Office Solutions > Email: [EMAIL PROTECTED] > Web: www.online.sungard.com > > > > -----Original Message----- > From: clinton lopez [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 29, 2004 7:24 AM > To: [EMAIL PROTECTED] > Subject: Mysql table type > > > I would like to use InnoDB table type in mysql. I > read > the documentation but I could not find a way to > specify the table type (unless i missed some parts). > I > searched the archives and I found out that I should > change something in the db.props file. I downloaded > the tdk (2.2-rc2) and followed the instructions in > the > TDK-How to . I could not find the db.props file. Am > I > missing something or are there other ways to specify > the table type? > > Thanks! > Clinton Lopez > > > > _______________________________ > Do you Yahoo!? > Declare Yourself - Register online to vote today! > http://vote.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
