Thanks for the response.
The below suggestion to make an SP call worked out.
Another update on programmatic registering the pool to jmx - It worked out
and here is how I did it
MBeanServer mBeanServer =
ManagementFactory.getPlatformMBeanServer();
try {
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Amit,
On 2/9/12 11:21 AM, Amit wrote:
Any thoughts on the first point about executing multiple SQL
queries on physical connection creation?
Doesn't Oracle have a CALL() syntax in a regular query?
How are you getting parametric information from
Here is an example
String query = BEGIN DBMS_LOCK.sleep(seconds = 5.01); END;
It is pretty obvious that you can't do SELECT 1; SELECT 1; is this would
result in TWO result sets.
But you can create a block and execute any number of instructions
The above example executes a stored procedure.
On 09/02/2012 17:24, Amit wrote:
Comment below
On 09-Feb-2012, at 10:18 PM, Pid p...@pidster.com wrote:
On 09/02/2012 16:21, Amit wrote:
Any thoughts on the first point about executing multiple SQL queries on
physical connection creation?
I have no idea if it'll work, but I'd try:
Comments below.
On Wed, Feb 8, 2012 at 9:19 PM, Pid p...@pidster.com wrote:
On 08/02/2012 14:59, amit shah wrote:
Responses below.
Thanks.
On Wed, Feb 8, 2012 at 7:14 PM, Pid p...@pidster.com wrote:
On 08/02/2012 12:30, amit shah wrote:
Thanks for the reply. Responses below.
One more comment below about oracle UCP.
On Thu, Feb 9, 2012 at 5:10 PM, amit shah amits...@gmail.com wrote:
Comments below.
On Wed, Feb 8, 2012 at 9:19 PM, Pid p...@pidster.com wrote:
On 08/02/2012 14:59, amit shah wrote:
Responses below.
Thanks.
On Wed, Feb 8, 2012 at 7:14 PM,
On 09/02/2012 12:56, amit shah wrote:
One more comment below about oracle UCP.
snip
The pool returns members at random, so how would you know which cached
credentials you were getting?
The credentials which are passed to the getConnection(String username,
String password) method. When we
Any thoughts on the first point about executing multiple SQL queries on
physical connection creation?
On 09-Feb-2012, at 7:05 PM, Pid p...@pidster.com wrote:
On 09/02/2012 12:56, amit shah wrote:
One more comment below about oracle UCP.
snip
The pool returns members at random, so how
On 09/02/2012 16:21, Amit wrote:
Any thoughts on the first point about executing multiple SQL queries on
physical connection creation?
I have no idea if it'll work, but I'd try:
SELECT 1; SELECT 1;
If you are controlling the pool (and you are) by passing in
username/password parameters each
Comment below
On 09-Feb-2012, at 10:18 PM, Pid p...@pidster.com wrote:
On 09/02/2012 16:21, Amit wrote:
Any thoughts on the first point about executing multiple SQL queries on
physical connection creation?
I have no idea if it'll work, but I'd try:
SELECT 1; SELECT 1;
If you are
I am trying to use the tomcat 7 jdbc connection pool in our application by
using the tomcat-jdbc.jar and tomcat-juli.jar files. The basic connection
pool works fine. I have few questions/clarifications
1. Executing multiple statements on connection initialization
- The pool
On 08/02/2012 11:41, amit shah wrote:
I am trying to use the tomcat 7 jdbc connection pool in our application by
using the tomcat-jdbc.jar and tomcat-juli.jar files. The basic connection
pool works fine. I have few questions/clarifications
1. Executing multiple statements on connection
Thanks for the reply. Responses below.
On Wed, Feb 8, 2012 at 5:19 PM, Pid p...@pidster.com wrote:
On 08/02/2012 11:41, amit shah wrote:
I am trying to use the tomcat 7 jdbc connection pool in our application
by
using the tomcat-jdbc.jar and tomcat-juli.jar files. The basic connection
On 08/02/2012 12:30, amit shah wrote:
Thanks for the reply. Responses below.
On Wed, Feb 8, 2012 at 5:19 PM, Pid p...@pidster.com wrote:
On 08/02/2012 11:41, amit shah wrote:
I am trying to use the tomcat 7 jdbc connection pool in our application
by
using the tomcat-jdbc.jar and
Responses below.
Thanks.
On Wed, Feb 8, 2012 at 7:14 PM, Pid p...@pidster.com wrote:
On 08/02/2012 12:30, amit shah wrote:
Thanks for the reply. Responses below.
On Wed, Feb 8, 2012 at 5:19 PM, Pid p...@pidster.com wrote:
On 08/02/2012 11:41, amit shah wrote:
I am trying to use the
On 08/02/2012 14:59, amit shah wrote:
Responses below.
Thanks.
On Wed, Feb 8, 2012 at 7:14 PM, Pid p...@pidster.com wrote:
On 08/02/2012 12:30, amit shah wrote:
Thanks for the reply. Responses below.
On Wed, Feb 8, 2012 at 5:19 PM, Pid p...@pidster.com wrote:
On 08/02/2012 11:41,
16 matches
Mail list logo
