Hi Palmer, First I should say, please don't address questions like this to me individually. Although I am one of the lead people here, I am not the only one and especially with the move to Apache we want to spread knowledge a lot more.
I am affraid you're not going to get much luck by using BOTH the access module and the pojo module. It sounds a bit like you think the pojo module is a ORM-like mapping module, but actually it is not. It is simply an in-memory collection based DataContext. It allows querying and updating an in-memory data structure as if it was a database - mostly used for mocking/testing etc. I just updated the wiki with this example (taken from the old website): https://wiki.apache.org/metamodel/examples/PojoDataContext So you should stick with the Access module only for your case. And probably discard the pojos that you mention. Does this answer your questions? 2013/7/18 palmer_one <[email protected]> > Hi Kasper, I was in contact with you a few years ago. > I am trying to do things with the Jackcess API, but it does not allow > one to 'push' relationships into a newly created database MDB file. It only > allows to put tables and data. > So I created like 3 tables(POJO's) in memory that represent table > entities, 2 tables and a join table that handles a Many-to-Many > relationship or was it a one-to-many relationship. I would like to query > this and get a Result-Set back and then push this into Access mdb as a > result table. > SO the context is university courses. One has Faculty table, then the > join table called Sections, and Courses table. > So if I query a particular professor from Faculty table I want to get > related data, that is the courses > he/she teaches. > How do you use Meta-Model to query multi-tables(POJO objects)? > Hope you can help. > Regards, > P > > > >
