Hi Judes,
It is not a temporary table in the sense of a database temporary table. It is a table created to hold the result of a complicated query. However the table name is not fixed (it will be something like a fixed prefix + a session id). The columns are fixed. The reason to have a temporary table (outside the fact it is done from another application), is for performance reason. This table is used to store large result of complicated query. Therefore it would be a bottleneck if every user creates data in the same table (while other users are reading it). Has the interest of the data is not cross user, it makes sense to have a separate temporary table(s). To answer directly your c question, it is not related to reporting or OLAP as it is real time. In a second phase we will include asynchronous calculation for very long query. Thanks for your interest. Yann ________________________________ From: Judes Tumuhairwe (via Nabble) [mailto:ml-user+110072-47525...@n2.nabble.com] Sent: vendredi, 9. janvier 2009 23:24 To: Yann Andenmatten Subject: Re: Mapping a temporary table 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...@... <http://n2.nabble.com/user/SendEmail.jtp?type=node&node=2135621&i=0> > 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. > > ________________________________ This email is a reply to your post @ http://n2.nabble.com/Mapping-a-temporary-table-tp2133474p2135621.html You can reply by email or by visting the link above. ____________________________________________________________ This email and any files transmitted with it are CONFIDENTIAL and intended solely for the use of the individual or entity to which they are addressed. Any unauthorized copying, disclosure, or distribution of the material within this email is strictly forbidden. Any views or opinions presented within this e-mail are solely those of the author and do not necessarily represent those of Odyssey Financial Technologies SA unless otherwise specifically stated. An electronic message is not binding on its sender. Any message referring to a binding engagement must be confirmed in writing and duly signed. If you have received this email in error, please notify the sender immediately and delete the original. -- View this message in context: http://n2.nabble.com/Mapping-a-temporary-table-tp2133474p2144637.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
