Feb 2nd, 2012, 07:17 AM
Persistent or a single session on a Oracle Enviroment and JEE.
For my first post, I'd like to say that I'm a ruge fan of all Spring technologies. So my question it's no so simple either to explain and I bilieve that this task (explain my situation) will be a litle bit rough. So let's go!
I'm really not sure whether or not this question would be applied to this particular forum or security forum. However I guess this fix to this forum because my architecture depends on it.
Basically I have to integrate my app to another one that works over Oracle Forms 10g. So, this application I have to integrate with, works with a concept of "users context" that are implemented over oracle global temporary tables (GTT). Each "user context" represents all visible data to a particular user profile. On Oracle Forms 10g App this works preatty fine because, if I'm not wrong, a single connection is stabilished to each user connected to the application. My application will be a jee spring IoC framework based one and as long as I know all application open a connection pool that points each one of them to a specific session in data base, right. So how can I still use that scenario of GTT with my application?
So the problem is that my application will have to use those GTT to show data on web forms. I notice that all web application works with a connection pool and I'm really not sure if create to every single connection on pool those GTT are a good idea once to acomplish that it takes a bunch of seconds. I guess i'll have a performance issue every time.
If I could make myself clear, i'll appriciate any ideas!
Thanks in advance!
Tags for this Thread