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 {
tomcatDataSour
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 procedur
-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 t
On 09/02/2012 17:24, Amit wrote:
> Comment below
>
>
>
> On 09-Feb-2012, at 10:18 PM, Pid 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:
Comment below
On 09-Feb-2012, at 10:18 PM, Pid 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 control
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 eac
Any thoughts on the first point about executing multiple SQL queries on
physical connection creation?
On 09-Feb-2012, at 7:05 PM, Pid wrote:
> On 09/02/2012 12:56, amit shah wrote:
>> One more comment below about oracle UCP.
>
>
>
>> The pool returns members at random, so how would you
On 09/02/2012 12:56, amit shah wrote:
> One more comment below about oracle UCP.
> 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 passwor
One more comment below about oracle UCP.
On Thu, Feb 9, 2012 at 5:10 PM, amit shah wrote:
> Comments below.
>
> On Wed, Feb 8, 2012 at 9:19 PM, Pid wrote:
>
>> On 08/02/2012 14:59, amit shah wrote:
>> > Responses below.
>> >
>> > Thanks.
>> >
>> > On Wed, Feb 8, 2012 at 7:14 PM, Pid wrote:
>>
Comments below.
On Wed, Feb 8, 2012 at 9:19 PM, Pid wrote:
> On 08/02/2012 14:59, amit shah wrote:
> > Responses below.
> >
> > Thanks.
> >
> > On Wed, Feb 8, 2012 at 7:14 PM, Pid wrote:
> >
> >> On 08/02/2012 12:30, amit shah wrote:
> >>> Thanks for the reply. Responses below.
> >>>
> >>> On W
On 08/02/2012 14:59, amit shah wrote:
> Responses below.
>
> Thanks.
>
> On Wed, Feb 8, 2012 at 7:14 PM, Pid 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 wrote:
>>>
On 08/02/2012 11:41, amit shah w
Responses below.
Thanks.
On Wed, Feb 8, 2012 at 7:14 PM, Pid 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 wrote:
> >
> >> On 08/02/2012 11:41, amit shah wrote:
> >>> I am trying to use the tomcat 7 jdbc co
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 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
Thanks for the reply. Responses below.
On Wed, Feb 8, 2012 at 5:19 PM, Pid 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
> > pool works
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 connec
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 provides
16 matches
Mail list logo