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.

Connection Cache error

6 posts in Appeon (partner product) Last posting was on 2006-02-10 12:55:04.0Z
Miguel Posted on 2004-01-30 21:37:51.0Z
From: "Miguel" <miguelcarvajal555@hotmail.com>
Newsgroups: sybase.public.appeon
Subject: Connection Cache error
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 200.30.106.134
X-Original-NNTP-Posting-Host: 200.30.106.134
Message-ID: <401aceaf@forums-1-dub>
Date: 30 Jan 2004 13:37:51 -0800
X-Trace: forums-1-dub 1075498671 200.30.106.134 (30 Jan 2004 13:37:51 -0800)
X-Original-Trace: 30 Jan 2004 13:37:51 -0800, 200.30.106.134
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:57
Article PK: 20556

Hello.....

I am trying to migrate a application PB 8.0.3 Buil 9933 with
Appeon 2.5. I create my connection Cache but not work and leaves the
following error:

"Ping of Desarrollo Connection Cache failed: JCM.getCache() could not
retrieve cache for the user/password/server values sipplied.
com.sybase.jaguar.util.JException: The connection cache was not found"

My data base is ASA 12,5 and use iAnywhere JDBC-ODBS Bridge Driver for
conection Cahe. The
parameters are:
Database Type: Sybase_ASE
Server Name: jdbc:odbc:Dataserver,5000
User Name: sa
Password:
(Blank)

Dlll or Class Name: ianywhere.ml.jdbcodbc.IDriver
Radio Button: JDBC

Enable cahe-by-nameacces: yes
Enable connection sanity check: yes

In Windows, environment variables
CLASSPATH: C:\Program Files\Sybase\SQL Anywhere
8\java\jodbc.jar;
Path: C:\Program Files\Sybase\SQL Anywhere
8\win32\dbjodbc8.dll;

I use EAServer 4.2 Build 42012

What I can do so that my Connection Cahe works?



MIGUEL CARVAJAL


Julie Jiang Posted on 2004-02-03 09:42:43.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <401aceaf@forums-1-dub>
Subject: Re: Connection Cache error
Lines: 207
Organization: Appeon Corporation
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_013F_01C3EA7B.25548940"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
NNTP-Posting-Host: 61.144.207.53
X-Original-NNTP-Posting-Host: 61.144.207.53
Message-ID: <401f6d13@forums-1-dub>
Date: 3 Feb 2004 01:42:43 -0800
X-Trace: forums-1-dub 1075801363 61.144.207.53 (3 Feb 2004 01:42:43 -0800)
X-Original-Trace: 3 Feb 2004 01:42:43 -0800, 61.144.207.53
X-Authenticated-User: appeon
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:62
Article PK: 12364

Hi Miguel,
 
According to the analysis by an Appeon engineer, a possible cause of the connection cache ping failure is that the ASA JDBC driver and EAServer failed to locate the dbjodbc8.dll file.
 
The engineer suggests to take the following steps to avoid the problem:
 
1) Upgrade ASA to ASA 8.0.2 build 4361 or ASA 9
#3 Copy jodbc.jar and dbjodbc8.dll files from ASA 9
 
2) (Assuming ASA is installed to Drive C) Navigate to the folder C:\Program Files\Sybase\SQL Anywhere 8\java\jodbc.jar, and copy the jodbc.jar file to the %JAGUAR%\java\lib folder.
 
3) (Assuming EAServer is installed to Drive C) Navigate to the folder C:\Program Files\Sybase\SQL Anywhere 8\win32\dbjodbc8.dll, and copy the dbjodbc8.dll file to one of the following directories (depending on which version of JDB is applied):
   C:\Program Files\Sybase\Shared\jdk1.2.2_10\jre\bin
   C:\Program Files\Sybase\Shared\jdk1.3.1_06\jre\bin
   C:\Program Files\Sybase\Shared\jdk1.4.1_01\jre\bin
4) Restart EAServer.
 
5) (Assuming that ase_odbc is the data source which is set up in ODBC manager and used to connect to ASE database) The ServerName shall be similar to "jdbc:odbc:dsn=ase_odbc"
Thanks,
Julie Jiang
Appeon Corporation
 
"Miguel" <miguelcarvajal555@hotmail.com> wrote in message news:401aceaf@forums-1-dub...
> Hello.....
>
> I am trying to migrate a  application PB 8.0.3 Buil 9933 with
> Appeon 2.5. I create my connection Cache but not work and leaves the
> following error:
>
> "Ping of Desarrollo Connection Cache failed:  JCM.getCache() could not
> retrieve cache for the user/password/server values sipplied.
> com.sybase.jaguar.util.JException:  The connection cache was not found"
>
> My data base is ASA 12,5 and use iAnywhere JDBC-ODBS Bridge Driver for
> conection Cahe. The
> parameters are:
>                            Database Type: Sybase_ASE
>                            Server Name:    jdbc:odbc:Dataserver,5000
>                            User Name:       sa
>                             Password:
> (Blank)
>
>                         Dlll or Class Name:  ianywhere.ml.jdbcodbc.IDriver
>                         Radio Button:          JDBC
>
>                     Enable cahe-by-nameacces:  yes
>                     Enable connection sanity check:  yes
>
> In Windows, environment variables
>             CLASSPATH:  C:\Program Files\Sybase\SQL Anywhere
> 8\java\jodbc.jar;
>             Path:                    C:\Program Files\Sybase\SQL Anywhere
> 8\win32\dbjodbc8.dll;
>
> I use EAServer 4.2 Build 42012
>
> What I can do so that my Connection Cahe works?
>
>
>
> MIGUEL CARVAJAL
>
>
>


Miguel Posted on 2004-02-03 17:12:05.0Z
From: "Miguel" <miguelcarvajal555@hotmail.com>
Newsgroups: sybase.public.appeon
References: <401aceaf@forums-1-dub> <401f6d13@forums-1-dub>
Subject: Re: Connection Cache error
Lines: 262
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C3EA4C.59458C10"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 200.30.106.134
X-Original-NNTP-Posting-Host: 200.30.106.134
Message-ID: <401fd665@forums-1-dub>
Date: 3 Feb 2004 09:12:05 -0800
X-Trace: forums-1-dub 1075828325 200.30.106.134 (3 Feb 2004 09:12:05 -0800)
X-Original-Trace: 3 Feb 2004 09:12:05 -0800, 200.30.106.134
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:64
Article PK: 20558

 

Julie................
 
Indeed.
 
With the changes that you indicated to me, my connection cache worked well.
 
Thanks..
 
Miguel Carvajal
"Julie Jiang" <julie.jiang@appeon.net> wrote in message news:401f6d13@forums-1-dub...
Hi Miguel,
 
According to the analysis by an Appeon engineer, a possible cause of the connection cache ping failure is that the ASA JDBC driver and EAServer failed to locate the dbjodbc8.dll file.
 
The engineer suggests to take the following steps to avoid the problem:
 
1) Upgrade ASA to ASA 8.0.2 build 4361 or ASA 9
#3 Copy jodbc.jar and dbjodbc8.dll files from ASA 9
 
2) (Assuming ASA is installed to Drive C) Navigate to the folder C:\Program Files\Sybase\SQL Anywhere 8\java\jodbc.jar, and copy the jodbc.jar file to the %JAGUAR%\java\lib folder.
 
3) (Assuming EAServer is installed to Drive C) Navigate to the folder C:\Program Files\Sybase\SQL Anywhere 8\win32\dbjodbc8.dll, and copy the dbjodbc8.dll file to one of the following directories (depending on which version of JDB is applied):
   C:\Program Files\Sybase\Shared\jdk1.2.2_10\jre\bin
   C:\Program Files\Sybase\Shared\jdk1.3.1_06\jre\bin
   C:\Program Files\Sybase\Shared\jdk1.4.1_01\jre\bin
4) Restart EAServer.
 
5) (Assuming that ase_odbc is the data source which is set up in ODBC manager and used to connect to ASE database) The ServerName shall be similar to "jdbc:odbc:dsn=ase_odbc"
Thanks,
Julie Jiang
Appeon Corporation
 
"Miguel" <miguelcarvajal555@hotmail.com> wrote in message news:401aceaf@forums-1-dub...
> Hello.....
>
> I am trying to migrate a  application PB 8.0.3 Buil 9933 with
> Appeon 2.5. I create my connection Cache but not work and leaves the
> following error:
>
> "Ping of Desarrollo Connection Cache failed:  JCM.getCache() could not
> retrieve cache for the user/password/server values sipplied.
> com.sybase.jaguar.util.JException:  The connection cache was not found"
>
> My data base is ASA 12,5 and use iAnywhere JDBC-ODBS Bridge Driver for
> conection Cahe. The
> parameters are:
>                            Database Type: Sybase_ASE
>                            Server Name:    jdbc:odbc:Dataserver,5000
>                            User Name:       sa
>                             Password:
> (Blank)
>
>                         Dlll or Class Name:  ianywhere.ml.jdbcodbc.IDriver
>                         Radio Button:          JDBC
>
>                     Enable cahe-by-nameacces:  yes
>                     Enable connection sanity check:  yes
>
> In Windows, environment variables
>             CLASSPATH:  C:\Program Files\Sybase\SQL Anywhere
> 8\java\jodbc.jar;
>             Path:                    C:\Program Files\Sybase\SQL Anywhere
> 8\win32\dbjodbc8.dll;
>
> I use EAServer 4.2 Build 42012
>
> What I can do so that my Connection Cahe works?
>
>
>
> MIGUEL CARVAJAL
>
>
>


Andrea Bonifazio Posted on 2004-12-10 11:09:08.0Z
From: "Andrea Bonifazio" <abonifazio@vegatecnologie.it>
Newsgroups: sybase.public.appeon
References: <401aceaf@forums-1-dub> <401f6d13@forums-1-dub> <401fd665@forums-1-dub>
Subject: Re: Connection Cache error
Lines: 311
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0010_01C4DEB1.08578E70"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Original-NNTP-Posting-Host: host7-123.pool8254.interbusiness.it
Message-ID: <41b983d0@forums-2-dub>
X-Original-Trace: 10 Dec 2004 03:09:04 -0800, host7-123.pool8254.interbusiness.it
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Dec 2004 03:09:05 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Dec 2004 03:09:08 -0800
X-Trace: forums-1-dub 1102676948 10.22.108.75 (10 Dec 2004 03:09:08 -0800)
X-Original-Trace: 10 Dec 2004 03:09:08 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:618
Article PK: 20830

Thanks Julie and Miguel...
Starting few days ago, I faced the same problem, and your emails helped me a lot in solving it.

Thanks,
Andrea Bonifazio

 

"Miguel" <miguelcarvajal555@hotmail.com> ha scritto nel messaggio news:401fd665@forums-1-dub...
 

Julie................
 
Indeed.
 
With the changes that you indicated to me, my connection cache worked well.
 
Thanks..
 
Miguel Carvajal
"Julie Jiang" <julie.jiang@appeon.net> wrote in message news:401f6d13@forums-1-dub...
Hi Miguel,
 
According to the analysis by an Appeon engineer, a possible cause of the connection cache ping failure is that the ASA JDBC driver and EAServer failed to locate the dbjodbc8.dll file.
 
The engineer suggests to take the following steps to avoid the problem:
 
1) Upgrade ASA to ASA 8.0.2 build 4361 or ASA 9
#3 Copy jodbc.jar and dbjodbc8.dll files from ASA 9
 
2) (Assuming ASA is installed to Drive C) Navigate to the folder C:\Program Files\Sybase\SQL Anywhere 8\java\jodbc.jar, and copy the jodbc.jar file to the %JAGUAR%\java\lib folder.
 
3) (Assuming EAServer is installed to Drive C) Navigate to the folder C:\Program Files\Sybase\SQL Anywhere 8\win32\dbjodbc8.dll, and copy the dbjodbc8.dll file to one of the following directories (depending on which version of JDB is applied):
   C:\Program Files\Sybase\Shared\jdk1.2.2_10\jre\bin
   C:\Program Files\Sybase\Shared\jdk1.3.1_06\jre\bin
   C:\Program Files\Sybase\Shared\jdk1.4.1_01\jre\bin
4) Restart EAServer.
 
5) (Assuming that ase_odbc is the data source which is set up in ODBC manager and used to connect to ASE database) The ServerName shall be similar to "jdbc:odbc:dsn=ase_odbc"
Thanks,
Julie Jiang
Appeon Corporation
 
"Miguel" <miguelcarvajal555@hotmail.com> wrote in message news:401aceaf@forums-1-dub...
> Hello.....
>
> I am trying to migrate a  application PB 8.0.3 Buil 9933 with
> Appeon 2.5. I create my connection Cache but not work and leaves the
> following error:
>
> "Ping of Desarrollo Connection Cache failed:  JCM.getCache() could not
> retrieve cache for the user/password/server values sipplied.
> com.sybase.jaguar.util.JException:  The connection cache was not found"
>
> My data base is ASA 12,5 and use iAnywhere JDBC-ODBS Bridge Driver for
> conection Cahe. The
> parameters are:
>                            Database Type: Sybase_ASE
>                            Server Name:    jdbc:odbc:Dataserver,5000
>                            User Name:       sa
>                             Password:
> (Blank)
>
>                         Dlll or Class Name:  ianywhere.ml.jdbcodbc.IDriver
>                         Radio Button:          JDBC
>
>                     Enable cahe-by-nameacces:  yes
>                     Enable connection sanity check:  yes
>
> In Windows, environment variables
>             CLASSPATH:  C:\Program Files\Sybase\SQL Anywhere
> 8\java\jodbc.jar;
>             Path:                    C:\Program Files\Sybase\SQL Anywhere
> 8\win32\dbjodbc8.dll;
>
> I use EAServer 4.2 Build 42012
>
> What I can do so that my Connection Cahe works?
>
>
>
> MIGUEL CARVAJAL
>
>
>


Andreas Andreou Posted on 2004-02-02 15:34:39.0Z
From: "Andreas Andreou" <andreas.andreou@uk.mci.com>
Newsgroups: sybase.public.appeon
References: <401aceaf@forums-1-dub>
Subject: Re: Connection Cache error
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: nat-660.emea.mci.com
X-Original-NNTP-Posting-Host: nat-660.emea.mci.com
Message-ID: <401e6e0f$1@forums-1-dub>
Date: 2 Feb 2004 07:34:39 -0800
X-Trace: forums-1-dub 1075736079 194.203.214.148 (2 Feb 2004 07:34:39 -0800)
X-Original-Trace: 2 Feb 2004 07:34:39 -0800, nat-660.emea.mci.com
X-Authenticated-User: appeon
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:58
Article PK: 20552

I had the very same error message and this may seem a too simplistic
solution but let us know if you have tried it. When I first setup a
connection cache with EASErver, I was always getting that message even
though the parameters where the same as a working existing connection. I
closed Jaguar and restarted it, and it was then working fine. Seems that
Jaguar does not know about your new cache until you do this.

I have managed to get a connection cache working in both ASE and ASA. Have
you checked that the ODBC driver connects outside of Jaguar as well?
"Dataserver" ie. from the control panel, ODBC settings.

"Miguel" <miguelcarvajal555@hotmail.com> wrote in message
news:401aceaf@forums-1-dub...
> Hello.....
>
> I am trying to migrate a application PB 8.0.3 Buil 9933 with
> Appeon 2.5. I create my connection Cache but not work and leaves the
> following error:
>
> "Ping of Desarrollo Connection Cache failed: JCM.getCache() could not
> retrieve cache for the user/password/server values sipplied.
> com.sybase.jaguar.util.JException: The connection cache was not found"
>
> My data base is ASA 12,5 and use iAnywhere JDBC-ODBS Bridge Driver for
> conection Cahe. The
> parameters are:
> Database Type: Sybase_ASE
> Server Name: jdbc:odbc:Dataserver,5000
> User Name: sa
> Password:
> (Blank)
>
> Dlll or Class Name: ianywhere.ml.jdbcodbc.IDriver
> Radio Button: JDBC
>
> Enable cahe-by-nameacces: yes
> Enable connection sanity check: yes
>
> In Windows, environment variables
> CLASSPATH: C:\Program Files\Sybase\SQL Anywhere
> 8\java\jodbc.jar;
> Path: C:\Program Files\Sybase\SQL Anywhere
> 8\win32\dbjodbc8.dll;
>
> I use EAServer 4.2 Build 42012
>
> What I can do so that my Connection Cahe works?
>
>
>
> MIGUEL CARVAJAL
>
>
>


Steven Posted on 2006-02-10 12:55:04.0Z
From: "Steven" <steven@atherfax.com>
Newsgroups: sybase.public.appeon
Organization: 168.224.1.14
References: <401aceaf@forums-1-dub> <401e6e0f$1@forums-1-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Connection Cache error
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <43ec7e1a$1@forums-2-dub>
X-Original-Trace: 10 Feb 2006 03:50:50 -0800, web110.discountasp.net
Lines: 70
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Feb 2006 03:50:51 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Feb 2006 04:55:04 -0800
X-Trace: forums-1-dub 1139576104 10.22.108.75 (10 Feb 2006 04:55:04 -0800)
X-Original-Trace: 10 Feb 2006 04:55:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1334
Article PK: 12947

On 2 Feb 2004 07:34:39 -0800,
in sybase.public.appeon

Andreas Andreou <andreas.andreou@uk.mci.com> wrote:
>I had the very same error message and this may seem a too simplistic
>solution but let us know if you have tried it. When I first setup a
>connection cache with EASErver, I was always getting that message even
>though the parameters where the same as a working existing connection. I
>closed Jaguar and restarted it, and it was then working fine. Seems that
>Jaguar does not know about your new cache until you do this.
>
>I have managed to get a connection cache working in both ASE and ASA. Have
>you checked that the ODBC driver connects outside of Jaguar as well?
>"Dataserver" ie. from the control panel, ODBC settings.
>
>"Miguel" <miguelcarvajal555@hotmail.com> wrote in message
>news:401aceaf@forums-1-dub...
>> Hello.....
>>
>> I am trying to migrate a application PB 8.0.3 Buil 9933 with
>> Appeon 2.5. I create my connection Cache but not work and leaves the
>> following error:
>>
>> "Ping of Desarrollo Connection Cache failed: JCM.getCache() could not
>> retrieve cache for the user/password/server values sipplied.
>> com.sybase.jaguar.util.JException: The connection cache was not found"
>>
>> My data base is ASA 12,5 and use iAnywhere JDBC-ODBS Bridge Driver for
>> conection Cahe. The
>> parameters are:
>> Database Type: Sybase_ASE
>> Server Name: jdbc:odbc:Dataserver,5000
>> User Name: sa
>> Password:
>> (Blank)
>>
>> Dlll or Class Name: ianywhere.ml.jdbcodbc.IDriver
>> Radio Button: JDBC
>>
>> Enable cahe-by-nameacces: yes
>> Enable connection sanity check: yes
>>
>> In Windows, environment variables
>> CLASSPATH: C:\Program Files\Sybase\SQL Anywhere
>> 8\java\jodbc.jar;
>> Path: C:\Program Files\Sybase\SQL Anywhere
>> 8\win32\dbjodbc8.dll;
>>
>> I use EAServer 4.2 Build 42012
>>
>> What I can do so that my Connection Cahe works?
>>
>>
>>
>> MIGUEL CARVAJAL
>>
>>
>>
>
>

For some reaason after I took a working system > replaced two .jsps > restarted
Jaguar I got the following error: Server startup failed - no connections
allowed.

I reversed the change > restarted > refreshed > restarted > and still I get
'Server startup failed - no connections allowed'.

Any ideas ?

I can Ping in Jag Manager successfully.