Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

default connection pool size in ASA

2 posts in General Discussion Last posting was on 2004-10-05 14:33:06.0Z
vinay Posted on 2004-10-05 13:32:59.0Z
Message-ID: <4162A286.4030003@cisco.com>
From: vinay <vhampapu@cisco.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: default connection pool size in ASA
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 64.104.139.200
X-Original-Trace: 5 Oct 2004 06:32:55 -0700, 64.104.139.200
Lines: 12
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Oct 2004 06:32:56 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Oct 2004 06:32:59 -0700
X-Trace: forums-1-dub 1096983179 10.22.108.75 (5 Oct 2004 06:32:59 -0700)
X-Original-Trace: 5 Oct 2004 06:32:59 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3698
Article PK: 7602

Hello,

I am using ASA 9.0.1 with jConnect-5_5. From my JDBC program,
I am trying to setup a connection pool with a size of 10 but
ending up in "JZ00L" error - Login error. Looks like I am
exceeding the default max pool size. What is the ASA default
max pool size ? Is there a way I can see and increase the pool
size from Interactive SQL ?

Thanks,
Vinay


David Fishburn Posted on 2004-10-05 14:33:06.0Z
Newsgroups: ianywhere.public.general
Subject: Re: default connection pool size in ASA
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <4162A286.4030003@cisco.com>
Organization: iAnywhere Solutions
Message-ID: <Xns95796B3F7ED95fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
NNTP-Posting-Host: 10.25.100.215
X-Original-NNTP-Posting-Host: 10.25.100.215
Date: 5 Oct 2004 07:33:06 -0700
X-Trace: forums-1-dub 1096986786 10.25.100.215 (5 Oct 2004 07:33:06 -0700)
X-Original-Trace: 5 Oct 2004 07:33:06 -0700, 10.25.100.215
Lines: 36
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3702
Article PK: 7601

vinay <vhampapu@cisco.com> wrote in news:4162A286.4030003@cisco.com
of ianywhere.public.general:

v> I am using ASA 9.0.1 with jConnect-5_5. From my JDBC program,
v> I am trying to setup a connection pool with a size of 10 but
v> ending up in "JZ00L" error - Login error. Looks like I am
v> exceeding the default max pool size. What is the ASA default
v> max pool size ? Is there a way I can see and increase the pool
v> size from Interactive SQL ?

If you are running dbeng9.exe (the *personal* server), then this
has a hard coded limit of 10 connections.

To exceed that, you must run dbsrv9.exe (the *network* server).

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList