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.

MSSqlserver 2000 conn cache with SSA

2 posts in Appeon (partner product) Last posting was on 2005-04-20 10:45:16.0Z
Johan Persson Posted on 2005-04-19 12:32:17.0Z
From: "Johan Persson" <johan.persson@yarrow.se>
Newsgroups: sybase.public.appeon
Subject: MSSqlserver 2000 conn cache with SSA
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 228.241.13.217.in-addr.dgcsystems.net
X-Original-NNTP-Posting-Host: 228.241.13.217.in-addr.dgcsystems.net
Message-ID: <4264fa51$1@forums-1-dub>
Date: 19 Apr 2005 05:32:17 -0700
X-Trace: forums-1-dub 1113913937 217.13.241.228 (19 Apr 2005 05:32:17 -0700)
X-Original-Trace: 19 Apr 2005 05:32:17 -0700, 228.241.13.217.in-addr.dgcsystems.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:785
Article PK: 20893

Hi,
I have Appeon 2.8 and PB8 testing MS SQLServer jdbc driver,
it connects ok and data is shown. Now I would like to configure
com.sybase.jaguar.conncache.ssa=true, it does not seem to work.
Does MS SQLServer (or Appeon) support ANSISQL99 SSA
(set session auhorization) ?

tia
johan


Julie Jiang Posted on 2005-04-20 10:45:16.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 210.21.221.178
References: <4264fa51$1@forums-1-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: MSSqlserver 2000 conn cache with SSA
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <426632bc$1@forums-1-dub>
Date: 20 Apr 2005 03:45:16 -0700
X-Trace: forums-1-dub 1113993916 64.79.161.40 (20 Apr 2005 03:45:16 -0700)
X-Original-Trace: 20 Apr 2005 03:45:16 -0700, web110.discountasp.net
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:788
Article PK: 20891

Hi Johan,

Appeon engineers designed a similar case and configured
com.sybase.jaguar.conncache.ssa=true. The testing result is successful.

Please check the following to make sure the configuration is correct:
1. Check the driver files (msbase.jar, mssqlserver, and jarmsutil.jar) used by
SQL server is located at the %JAGUAR%\java\lib directory: .
The files have different versions. Make sure the file sizes are equal or close
to the following.

msbase.jar: 281KB

mssqlserver.jar: 66KB

msutil.jar: 58KB

2. After you set the properties of the connection cache, make sure the
connection cache can be successfully pinged.

3. Make sure that the connection cache is mapped correction to the application
transaction object in AEM.

4. Try to restart the EAServer and test again.

If the problem still exists, please provide your test case, connection cache
configuration screenshots, and the following log files: Jaguarhttprequest.log,
Jaguarhttpservlet.log, Jaguar.log, and LogSystem.log.

Regards,
Julie




On 19 Apr 2005 05:32:17 -0700,
in sybase.public.appeon

Johan Persson <johan.persson@yarrow.se> wrote:
>Hi,
>I have Appeon 2.8 and PB8 testing MS SQLServer jdbc driver,
>it connects ok and data is shown. Now I would like to configure
>com.sybase.jaguar.conncache.ssa=true, it does not seem to work.
>Does MS SQLServer (or Appeon) support ANSISQL99 SSA
>(set session auhorization) ?
>
>tia
>johan
>
>