[sqr-users] Reg: SQR Execute and connection pools

[SSundaram@pershing.com]

Hi,

One of my applications is currently using SQR Server for Solaris/Oracle
8.0.5.
We are using .sqr files to execute sql queries and output html pages. The
OS is
Solaris 2.5.

The application invokes SQR from within a java program, supplying
the user name password as parameters and executes using Java's Runtime
class.
Currently SQR uses one separate connection each time a report is invoked.
If there
are 50 report requests at the same time, it takes up 50 different
connections.
I am migrating this application into a J2EE based architecture where all
connections
to the database (Oracle) must go via a connection pool.

And now the question. Is there a mechanism by which I can invoke SQR and
make it
use connections from my application server's connection pools. My
application server
provides connection pooling API. If there is a way for SQR to access
connection pools
I can explore the possibility of it using our API.

Thanks in advance.
Subbu




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users