Hi, thanks all for replying so quickly. Rearranging the order of the mapping files helped solve the problem. What is a good solution for doing it bidirectionally? e.g. if I have my Article.xml specify a flush when an update statement in Author.xml is invoked and vice versa?
Thanks again. - H.E. --- Prashanth Sukumaran <[EMAIL PROTECTED]> wrote: > Hi Sum, > > It is the order in which you define the sqlMap files > in the sqlmap-config.xml. If you want to > reference a statement declared in another sqlMal.xml > file put this entry on top of the file that > is referencing the statement. > > Like > > <sqlMap > resource="folder/persistence/sqlmapdao/sql/Shop.xml"/> > <sqlMap > resource="folder/persistence/sqlmapdao/sql/ValueObjects.xml"/> > > Assume there is an insert (Transport company) in the > shop.xml and the ValueObjects has the list of > Transport companies cached. Have the shop.xml > listed in sqlmap-config.xml before the > valueobjects.xml. > On Insert in the shop.xml you want to flush the list > of transport companies cached in > valueobjects.xml. > > Rgds > > Prashanth. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
