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

["George Jansen" <GJANSEN@aflcio.org>]

>From what I've seen, no. If the number of connections is an issue, you
could look at MTS or Connection Manager on the Oracle side.





>>> SSundaram@pershing.com 1/28/2005 11:30:46 AM >>>
Hi All,

Any updates on this?
It would be great if someone could atleast point me to any
related topics which I can explore.

Thanks and Regards
Subbu

Posted on 01/21/2005

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

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