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.

PowerDynamo Connection Cache Bug

6 posts in General Discussion (old) Last posting was on 2000-03-31 18:52:19.0Z
Jose Perez Posted on 2000-03-21 19:28:08.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 21 Mar 2000 14:28:08 -0500
From: Jose Perez <jperez@hartz.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: PowerDynamo Connection Cache Bug
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 16
NNTP-Posting-Host: mailhost.hartz.com 207.240.133.18
Message-ID: <347_38D7CD48.A2053CC@hartz.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25987
Article PK: 156001

I am having trouble getting a Dynamo permanent connection in a web page.

I can create the connection, and can ping it successfully.

However, when I try to get the connection via the site.getconnection()
function, I get the error message "connection does not exist".

I have checked the spelling, etc.

This occurs with both ODBC database connections and Jaguar MASP
connections.

The work around I am using is to create temporary connections on the
fly, but I understand from the documentation that this method is costly.

Any help would be appreciated.

jperez@hartz.com


Roy Kiesler [TeamSybase] Posted on 2000-03-21 19:39:11.0Z
Newsgroups: sybase.public.easerver
From: "Roy Kiesler [TeamSybase]" <SPAM_FREE_rkiesler@noblestar.com>
Subject: Re: PowerDynamo Connection Cache Bug
Date: Tue, 21 Mar 2000 14:39:11 -0500
Lines: 31
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: clients.accint.com 141.154.97.1
Message-ID: <347_dVIOj22k$GA.290@forums.sybase.com>
References: <347_38D7CD48.A2053CC@hartz.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25986
Article PK: 156000

Hate to state the obvious, but have you assigned that connection to the
Dynamo site root in Sybase Central?

--
pbm_hopethishelps,
Roy Kiesler [TeamSybase]
Sybase Developers Network (SDN) - http:///www.sybase.com/sdn

"Jose Perez" <jperez@hartz.com> wrote in message
news:38D7CD48.A2053CC@hartz.com...
> I am having trouble getting a Dynamo permanent connection in a web page.
>
> I can create the connection, and can ping it successfully.
>
> However, when I try to get the connection via the site.getconnection()
> function, I get the error message "connection does not exist".
>
> I have checked the spelling, etc.
>
> This occurs with both ODBC database connections and Jaguar MASP
> connections.
>
> The work around I am using is to create temporary connections on the
> fly, but I understand from the documentation that this method is costly.
>
> Any help would be appreciated.
>
> jperez@hartz.com
>


Jose Perez Posted on 2000-03-31 18:50:43.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 31 Mar 2000 13:50:43 -0500
From: Jose Perez <jperez@hartz.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: PowerDynamo Connection Cache Bug
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 32
NNTP-Posting-Host: mailhost.hartz.com 207.240.133.18
Message-ID: <347_38E4F383.A7369332@hartz.com>
References: <347_38D7CD48.A2053CC@hartz.com> <347_dVIOj22k$GA.290@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25055
Article PK: 154169

Yes, I have. I also assigned it to the document. Same problem.

We are running a file based site. The Dynamo version is 3.0, with patch. I
believe the full release number is 3.0.0.691

Thanks in advance.

"Roy Kiesler [TeamSybase]" wrote:

> Hate to state the obvious, but have you assigned that connection to the
> Dynamo site root in Sybase Central?
>
> --
> pbm_hopethishelps,
> Roy Kiesler [TeamSybase]
> Sybase Developers Network (SDN) - http:///www.sybase.com/sdn
>
> "Jose Perez" <jperez@hartz.com> wrote in message
> news:38D7CD48.A2053CC@hartz.com...
> > I am having trouble getting a Dynamo permanent connection in a web page.
> >
> > I can create the connection, and can ping it successfully.
> >
> > However, when I try to get the connection via the site.getconnection()
> > function, I get the error message "connection does not exist".
> >
> > I have checked the spelling, etc.
> >
> > This occurs with both ODBC database connections and Jaguar MASP
> > connections.
> >
> > The work around I am using is to create temporary connections on the
> > fly, but I understand from the documentation that this method is costly.
> >
> > Any help would be appreciated.
> >
> > jperez@hartz.com
> >


Jose Perez Posted on 2000-03-31 18:39:53.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 31 Mar 2000 13:39:53 -0500
From: Jose Perez <jperez@hartz.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: "Roy Kiesler [TeamSybase]" <SPAM_FREE_rkiesler@noblestar.com>
Subject: Re: PowerDynamo Connection Cache Bug
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 34
NNTP-Posting-Host: mailhost.hartz.com 207.240.133.18
Message-ID: <347_38E4F0F9.22907ED3@hartz.com>
References: <347_38D7CD48.A2053CC@hartz.com> <347_dVIOj22k$GA.290@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25059
Article PK: 154172

Yes, I have. I also assigned it directly to the document.

Does it make a difference that the connection was created AFTER the document?

We are running a file based site.

The version of Dynamo is 3, with patch. I believe the full release number is
3.0.0.691

Thanks in advance.

"Roy Kiesler [TeamSybase]" wrote:

> Hate to state the obvious, but have you assigned that connection to the
> Dynamo site root in Sybase Central?
>
> --
> pbm_hopethishelps,
> Roy Kiesler [TeamSybase]
> Sybase Developers Network (SDN) - http:///www.sybase.com/sdn
>
> "Jose Perez" <jperez@hartz.com> wrote in message
> news:38D7CD48.A2053CC@hartz.com...
> > I am having trouble getting a Dynamo permanent connection in a web page.
> >
> > I can create the connection, and can ping it successfully.
> >
> > However, when I try to get the connection via the site.getconnection()
> > function, I get the error message "connection does not exist".
> >
> > I have checked the spelling, etc.
> >
> > This occurs with both ODBC database connections and Jaguar MASP
> > connections.
> >
> > The work around I am using is to create temporary connections on the
> > fly, but I understand from the documentation that this method is costly.
> >
> > Any help would be appreciated.
> >
> > jperez@hartz.com
> >


Jose Perez Posted on 2000-03-31 18:39:41.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 31 Mar 2000 13:39:41 -0500
From: Jose Perez <jperez@hartz.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: "Roy Kiesler [TeamSybase]" <SPAM_FREE_rkiesler@noblestar.com>
Subject: Re: PowerDynamo Connection Cache Bug
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 34
NNTP-Posting-Host: mailhost.hartz.com 207.240.133.18
Message-ID: <347_38E4F0EC.F8E9D7BF@hartz.com>
References: <347_38D7CD48.A2053CC@hartz.com> <347_dVIOj22k$GA.290@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25060
Article PK: 154174

Yes, I have. I also assigned it directly to the document.

Does it make a difference that the connection was created AFTER the document?

We are running a file based site.

The version of Dynamo is 3, with patch. I believe the full release number is
3.0.0.691

Thanks in advance.

"Roy Kiesler [TeamSybase]" wrote:

> Hate to state the obvious, but have you assigned that connection to the
> Dynamo site root in Sybase Central?
>
> --
> pbm_hopethishelps,
> Roy Kiesler [TeamSybase]
> Sybase Developers Network (SDN) - http:///www.sybase.com/sdn
>
> "Jose Perez" <jperez@hartz.com> wrote in message
> news:38D7CD48.A2053CC@hartz.com...
> > I am having trouble getting a Dynamo permanent connection in a web page.
> >
> > I can create the connection, and can ping it successfully.
> >
> > However, when I try to get the connection via the site.getconnection()
> > function, I get the error message "connection does not exist".
> >
> > I have checked the spelling, etc.
> >
> > This occurs with both ODBC database connections and Jaguar MASP
> > connections.
> >
> > The work around I am using is to create temporary connections on the
> > fly, but I understand from the documentation that this method is costly.
> >
> > Any help would be appreciated.
> >
> > jperez@hartz.com
> >


Roy Kiesler [TeamSybase] Posted on 2000-03-31 18:52:19.0Z
Newsgroups: sybase.public.easerver
From: "Roy Kiesler [TeamSybase]" <SPAM_FREE_rkiesler@noblestar.com>
Subject: Re: PowerDynamo Connection Cache Bug
Date: Fri, 31 Mar 2000 13:52:19 -0500
Lines: 76
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: clients.accint.com 141.154.97.1
Message-ID: <347_vo9WIL0m$GA.290@forums.sybase.com>
References: <347_38D7CD48.A2053CC@hartz.com> <347_dVIOj22k$GA.290@forums.sybase.com> <347_38E4F0EC.F8E9D7BF@hartz.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25056
Article PK: 154170

What happens when you reference the connection directly, i.e., without
calling site.getConnection()?

e.g.,

sqlString = "SELECT product.prod_id, vendor.name, product.name, os.name,
product.price "
+ "FROM category, os, product, vendor "
+ "WHERE ( product.os_id = os.os_id ) and ( product.cat_id =
category.cat_id ) and "
+ "( vendor.vendor_id = product.vendor_id ) and "
+ "( product.cat_id = " + document.value.cat_id + " ) "
+ "ORDER BY vendor.name, product.name ASC";

list = connection.CreateQuery( sqlString ); // direct reference, no
getConnection()
var nRows = list.GetRowCount();

--
pbm_hopethishelps,
Roy Kiesler [TeamSybase]
Sybase Developers Network (SDN) - http:///www.sybase.com/sdn

"Jose Perez" <jperez@hartz.com> wrote in message
news:38E4F0EC.F8E9D7BF@hartz.com...
> Yes, I have. I also assigned it directly to the document.
>
> Does it make a difference that the connection was created AFTER the
document?
>
> We are running a file based site.
>
> The version of Dynamo is 3, with patch. I believe the full release number
is
> 3.0.0.691
>
> Thanks in advance.
>
>
>
> "Roy Kiesler [TeamSybase]" wrote:
>
> > Hate to state the obvious, but have you assigned that connection to the
> > Dynamo site root in Sybase Central?
> >
> > --
> > pbm_hopethishelps,
> > Roy Kiesler [TeamSybase]
> > Sybase Developers Network (SDN) - http:///www.sybase.com/sdn
> >
> > "Jose Perez" <jperez@hartz.com> wrote in message
> > news:38D7CD48.A2053CC@hartz.com...
> > > I am having trouble getting a Dynamo permanent connection in a web
page.
> > >
> > > I can create the connection, and can ping it successfully.
> > >
> > > However, when I try to get the connection via the site.getconnection()
> > > function, I get the error message "connection does not exist".
> > >
> > > I have checked the spelling, etc.
> > >
> > > This occurs with both ODBC database connections and Jaguar MASP
> > > connections.
> > >
> > > The work around I am using is to create temporary connections on the
> > > fly, but I understand from the documentation that this method is
costly.
> > >
> > > Any help would be appreciated.
> > >
> > > jperez@hartz.com
> > >
>