db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: Does torque support Mysql 5.0 and view
Date Tue, 20 Dec 2005 02:48:34 GMT
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:wzhao6898@gmail.com]
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?


On 12/13/05, Thomas Fischer <fischer@seitenbau.net> 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 <wzhao6898@gmail.com> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

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.

View raw message