Hi Yann, > We want to read data from an application which generate result in temporary > table. We know the table name,
I don't know if I understand you right but....you want to read data from a temporary table? I have a few questions to try to understand what you're talking about: a) Are the columns names constant or do they change depending on when/how the table is generated? If they're the same everytime, is there a reason it has to be a temporary table? b) I don't know if you can read data from a temporary table via JPA. AFAIK, in Postgres, MySQL, and MS SQL temporary tables are not accessible outside the scope of that transaction or session (unless you disable auto-commit and manage the transactions yourself since they're dropped on-commit). Have you done this successfully in straight JDBC? c) Is it fair to assume it is reporting/OLAP related data? It might help a bit if you elaborate a little bit on the use case. thanks, Judes On Fri, Jan 9, 2009 at 6:41 AM, Yann Andenmatten < yandenmat...@odyssey-group.com> wrote: > > Hi, > > We want to read data from an application which generate result in temporary > table. We know the table name, but I don't know the best way to do this. > Generated, building a class with the appropriate annotation is not > acceptable. Possibly generate a xml based entity configuration might be a > way. > > What would you suggest ? Does anyone faced the same problem ? > > Thanks > Yann > -- > View this message in context: > http://n2.nabble.com/Mapping-a-temporary-table-tp2133474p2133474.html > Sent from the OpenJPA Users mailing list archive at Nabble.com. > >
