Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 10th, 2005, 06:53 AM
Registered User
Join Date: Aug 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Proxxy Connections working, but not correctly???


We are tying to test a OCI Connection Pool Proxxy Authentication scenario and so far it seems to be working, but we are getting some miscued information from the DB. We are using a .NET (VB.NET) application and we establish a connection to the database using APP_USER as the proxy account. Our Min Pool Size is 1 and our Max Pool Size is 5. Here is how I am testing it after the application has established a connection.

Here is my connection string I use within VB.NET:
myConnectionString1 = "Persist Security Info=False;Proxy User ID=DMIS_APP_USER;Proxy Password=*********;User ID=" & strUser & ";Incr Pool Size=1;Pooling=true;Min Pool Size=1;Max Pool Size=25;Data Source=DMIS;Connection Lifetime=5"

When I query V$SESSION, I see the following:
DMISDBA DEDICATED TestPool.exe 8/9/2005 10:38:23 INACTIVE
DMIS_APP_USER DEDICATED TestPool.exe 8/9/2005 10:38:22 INACTIVE
DMIS_APP_USER DEDICATED TestPool.exe 8/9/2005 10:38:19 INACTIVE
DMIS_APP_USER DEDICATED TestPool.exe 8/9/2005 10:38:22 INACTIVE
RANDS DEDICATED TestPool.exe 8/9/2005 10:38:24 INACTIVE
ZEVERSEN DEDICATED TestPool.exe 8/9/2005 10:38:22 INACTIVE

As you can see here, APP_USER has established 3 dedicated connections when it should only have one. The other users should have the value of PSEUDO under the server column. But as you can see it does not.

One thing to note here: It seems like that the application is setting up a connection cache pool. In this case the results when I query V$SESSION are accurate and correct, but I am trying to run a OCI Connection Pool which will eliminate the problem of multiple physical connections to the pool. In OCI Connection Pool I can multiplex the database connections. I would simply like to have one physical connection to the DB with multiple database sessions over it. I can perform this action in Java, but I am pretty sure that in .NET it can be done.

If someone can please answer this for me I would greatly appreciate it.

Raman Gill

Similar Threads
Thread Thread Starter Forum Replies Last Post
Contains function call not working correctly cnatale XSLT 7 May 8th, 2008 07:53 AM
Hello User, not working correctly? Neotriple BOOK: Beginning Visual Basic 2005 ISBN: 978-0-7645-7401-6 1 October 5th, 2006 11:39 AM
Proxxy Connections working, but not correctly??? ramangill VB.NET 0 August 10th, 2005 06:54 AM
document.LastModified not working correctly in php Annoyamouse PHP How-To 1 December 7th, 2004 10:04 AM
No error but not working correctly! Adam H-W Javascript 7 November 10th, 2003 09:34 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.