Torque will generate the SQL statements for indices (including Unique) and foreign key constraints for tables but not for views. These items are sub-tags of the table tag in the dtd. So when you add the skipsql=true attribute on a table tag in the schema xml, the generator will not produce any SQL for that table (which is really a view) but will produce the access classes. Just to make sure there's no missunderstanding... the use (and keeping up to date) of indices is up to the SQL Server engine. Torque classes (and any software accessing SQL) does not know anything about them. So if you have indices on a view, Torque will use them if they meet the query needs. All that said, better handling of views probably should be considered as future enhancement. Any volunteers? ________________________________
From: David Zhao [mailto:[EMAIL PROTECTED] Sent: Mon 12/19/2005 1:12 PM To: Apache Torque Users List Subject: Re: Does torque support Mysql 5.0 and view Hi Thomas, Thanks for the reply, doesn't Torque support indexing, would it generate indice based upon definitions on schema.xml? Thanks, David On 12/13/05, Thomas Fischer <[EMAIL PROTECTED]> wrote: > > > > > > Hi, > > no problems were reported regarding Mysql 5, so this should work. Torque > supports reading from views (just declare them like you would declare a > table but omit sql generation for it), but you have to create them > manually. Torque does not use triggers at all, but you can insert them > manually without any problems. > > Thomas > > David Zhao <[EMAIL PROTECTED]> schrieb am 12.12.2005 21:19:06: > > > Hi there, > > > > Does current version of torque support MySQL 5.0 and view, trigger and > such? > > Thanks, > > > > David > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Duke CE Privacy Statement Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
