I got two tables, one to one relation. I need to perform a join selection in sql. How can I do such selection with the framework?
The Join class is more for internal use by the framework than for use by applications.
Have you set up an association between the two classes (either using attributes or the XML mapping file)?
If you have, is the association set for retrieveAutomatic="true"?
If so, then all you should need to do is set the key values on the object and call the Retrieve() method.
dont know why cant login to sourceforge today.
ok. that is not what i want.
mine didnt retrieveAutomatic to true.
i basically need to create a view (in ms sql), the results are from two different tables.
I realized i may need to use MultiRetrieveCriteria class to achieve this. Still struggling to figure out how to use it.
Have a look at this forum thread
http://jcframework.sourceforge.net/modules/newbb/viewtopic.php?topic_id=17&forum=3#forumpost72
It explains things fairly well. Let me know if you still have problems
Not exactly what I want. But enough for me to solve my issue.
Thanks
Log in to post a comment.
I got two tables, one to one relation. I need to perform a join selection in sql. How can I do such selection with the framework?
The Join class is more for internal use by the framework than for use by applications.
Have you set up an association between the two classes (either using attributes or the XML mapping file)?
If you have, is the association set for retrieveAutomatic="true"?
If so, then all you should need to do is set the key values on the object and call the Retrieve() method.
dont know why cant login to sourceforge today.
ok. that is not what i want.
mine didnt retrieveAutomatic to true.
i basically need to create a view (in ms sql), the results are from two different tables.
I realized i may need to use MultiRetrieveCriteria class to achieve this. Still struggling to figure out how to use it.
Have a look at this forum thread
http://jcframework.sourceforge.net/modules/newbb/viewtopic.php?topic_id=17&forum=3#forumpost72
It explains things fairly well. Let me know if you still have problems
Not exactly what I want. But enough for me to solve my issue.
Thanks