Hello, The application that I'm working on is filling up the connections to our Oracle database. We are using Remote Objects (POJOs) to connect to the database. The application is moderatley database intensive and to speed up the responsiveness, connections are not explicitly being closed after they are used. Instead we are closing connections by overiding the "finalize" method. For this reason only one instance of the connections is used throught the lifetime of the class.
The flex client is using "stateful-class" type in the RemoteObject invocation but it appears that there are still mulitple database connections being created with every client. To fix thie multiple database connection issue, we tried making the connection static, which caused an error presumably because of the multiple Asynchronus calls being made to the database. When proxool was integrated into our application, the connection would be established but when the application tried to use the connection there would be a similar error as before. Please point me in the direction of the best practice for properly managing connection pools with flex applications. Thanks for your time. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/nhFolB/TM --------------------------------------------------------------------~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
