I have a quick question about writing a select statement that returns an object inside of another object...
Say I have a Java bean named Message that has an instance variable named statusid which is a long. I also have an enum named Status that contains statusid (long) and statusdesc (String). These two classes map to Oracle tables named MESSAGE and STATUS respectively... Right now the select statement correctly returns the statusid value from the db and sets it in the Message object. However, I want to replace the statusid instance variable in Message with the enum Status and have a more complex query that returns the Message along with both values from the STATUS lookup table in the form of my enum. How would this work in the SQLMap? Does anybody have an example of this? Thanks in advance! -- View this message in context: http://old.nabble.com/SQLMap-Question---Select-Statement-tp28892238p28892238.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
