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.

Unpredictable cache connect error using JDBC

2 posts in General Discussion (old) Last posting was on 2000-03-21 14:54:49.0Z
Eddie Lewis Posted on 2000-03-21 02:52:16.0Z
Newsgroups: sybase.public.easerver
From: "Eddie Lewis" <eddie.lewis@inte.com.au>
Subject: Unpredictable cache connect error using JDBC
Date: Tue, 21 Mar 2000 13:52:16 +1100
Lines: 29
Organization: Intecom Systems
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: mail.intecom.com.au 210.9.112.10
Message-ID: <347_39cXdBuk$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26038
Article PK: 156045

Running Jaguar 3.5 Enterprise
NT4.0 PB 7 client
Oracle 8.1.5

Cache properties have sanity checks on with .props file in the conncache
directory


When the application connects to the server for the first time we sometimes
get the following error.

Mar 20 11:23:09 2000: n_customer uf_cacheconnect - Unable to connection
using CacheName = CapsADataJDBC.
SQLCODE: -1
SQLDBCODE: 999
SQLERRTEXT: Non SQL Error : InvocationTargetException: On getConnection.

The script then continues
Mar 20 11:23:09 2000: DEBUG: capsServer/n_customer/$Deactivate (unbind)

We cannot tie this down to a timing issue (ie. the db connection being
dropped by Oracle) as it can happen regularly. If the connection is being
dropped, then the sanity check would handle this - the sanity checks do work
well as we have stopped and restarted the db instance without any cache
problems.

Any ideas on the above error would be appreciated.


Scott McReynolds [Sybase] Posted on 2000-03-21 14:54:49.0Z
Newsgroups: sybase.public.easerver
From: "Scott McReynolds [Sybase]" <scottmc@sybase.com>
Subject: Re: Unpredictable cache connect error using JDBC
Date: Tue, 21 Mar 2000 07:54:49 -0700
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 158.159.8.50
Message-ID: <347_K1G7ZY0k$GA.285@forums.sybase.com>
References: <347_39cXdBuk$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26020
Article PK: 156034

Eddie,

Which driver are you using? Thick or thin?

Scott

"Eddie Lewis" <eddie.lewis@inte.com.au> wrote in message
news:39cXdBuk$GA.201@forums.sybase.com...
> Running Jaguar 3.5 Enterprise
> NT4.0 PB 7 client
> Oracle 8.1.5
>
> Cache properties have sanity checks on with .props file in the conncache
> directory
>
>
> When the application connects to the server for the first time we
sometimes
> get the following error.
>
> Mar 20 11:23:09 2000: n_customer uf_cacheconnect - Unable to connection
> using CacheName = CapsADataJDBC.
> SQLCODE: -1
> SQLDBCODE: 999
> SQLERRTEXT: Non SQL Error : InvocationTargetException: On getConnection.
>
> The script then continues
> Mar 20 11:23:09 2000: DEBUG: capsServer/n_customer/$Deactivate (unbind)
>
> We cannot tie this down to a timing issue (ie. the db connection being
> dropped by Oracle) as it can happen regularly. If the connection is being
> dropped, then the sanity check would handle this - the sanity checks do
work
> well as we have stopped and restarted the db instance without any cache
> problems.
>
> Any ideas on the above error would be appreciated.
>
>