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.

How are database connections handled?

3 posts in Appeon (partner product) Last posting was on 2008-11-18 13:07:34.0Z
Chris Posted on 2008-11-13 15:16:50.0Z
From: Chris <chris.vansant@eds.com>
Subject: How are database connections handled?
Newsgroups: sybase.public.appeon
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <appz77wtuwx1$.mloez0quo0l3$.dlg@40tude.net>
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 13 Nov 2008 07:16:50 -0800
X-Trace: forums-1-dub 1226589410 10.22.241.152 (13 Nov 2008 07:16:50 -0800)
X-Original-Trace: 13 Nov 2008 07:16:50 -0800, vip152.sybase.com
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2244
Article PK: 21596

My C/S PB app connects to the database when the user initially logs on and
disconnects when the user logs off. There are no other
connections/disconnections throughout the app. So a connection is active
to the database for the entire duration of the app, which could be hours.

How does Appeon handle DB connections? Does it just maintain the code that
I have in my app, or does it change the way connections are made, since we
are in a web environment? In other words, does appeon connect and
disconnect each time my app makes a call to the DB?

Or do I need to change my app to consider the web environment and implement
connections/disconnections each time I call the database?

Thanks,
Chris


Sally Li Posted on 2008-11-17 06:43:08.0Z
Sender: 4e17.4921028b.1804289383@sybase.com
From: Sally Li
Newsgroups: sybase.public.appeon
Subject: Re: How are database connections handled?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4921127c.4f35.1681692777@sybase.com>
References: <appz77wtuwx1$.mloez0quo0l3$.dlg@40tude.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Nov 2008 22:43:08 -0800
X-Trace: forums-1-dub 1226904188 10.22.241.41 (16 Nov 2008 22:43:08 -0800)
X-Original-Trace: 16 Nov 2008 22:43:08 -0800, 10.22.241.41
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2247
Article PK: 13348

Hi Chris,

Appeon utilizes EAServer to handle the database connection.
Hereinafter is abstracted from EAServer System
Administration Guide and EAServer Programmer's Guide. I hope
it can help your understand how does EAServer(Appeon) handle
the DB connection. "A connection cache maintains a pool of
available connections that EAServer components use to
interact with third-tier data servers. You must configure
connection caches for the specific user and database
combinations used by your components. A connection cache
entry improves performance by eliminating the overhead
associated with setting up a connection when one is
required." "Connection Manager controls caches of
connections that EAServer components use to interact with
third-tier servers. Connection management allows EAServer to
service hundreds of clients using only a few third-tier
database server connections."

For more detail information please post your issue to
EAServer Forum so that you can get more help from EAServer
experts.

In appeon, you don’t need to change the Client/Server code
to make it work on the Web, you just need to implement the
following to set up the database connection:
1. Create connection cache either in EAServer Manger or
through AEM.
2. Set up the mapping between the transaction object and the
connection cache.
For this part you can refer Appeon Help | Appeon Server
Configuration Guide | AEM User Guide | Application
Properties | Transaction Object and Appeon Server
Configuration Guide | AEM User Guide | Server Properties |
Connection Cache

Regards
Sally

> My C/S PB app connects to the database when the user
> initially logs on and disconnects when the user logs off.
> There are no other connections/disconnections throughout
> the app. So a connection is active to the database for
> the entire duration of the app, which could be hours.
>
> How does Appeon handle DB connections? Does it just
> maintain the code that I have in my app, or does it change
> the way connections are made, since we are in a web
> environment? In other words, does appeon connect and
> disconnect each time my app makes a call to the DB?
>
> Or do I need to change my app to consider the web
> environment and implement connections/disconnections each
> time I call the database?
>
> Thanks,
> Chris


Chris Posted on 2008-11-18 13:07:34.0Z
From: Chris <chris.vansant@eds.com>
Subject: Re: How are database connections handled?
Newsgroups: sybase.public.appeon
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
References: <appz77wtuwx1$.mloez0quo0l3$.dlg@40tude.net> <4921127c.4f35.1681692777@sybase.com>
Message-ID: <mnxohyzyyqbu.1hakdy453ccwf$.dlg@40tude.net>
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 18 Nov 2008 05:07:34 -0800
X-Trace: forums-1-dub 1227013654 10.22.241.152 (18 Nov 2008 05:07:34 -0800)
X-Original-Trace: 18 Nov 2008 05:07:34 -0800, vip152.sybase.com
Lines: 67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2252
Article PK: 13353

Sally,
I guess I didn't mention that I am using the .Net implementation of Appeon,
which does not use the EAServer. Can you respond to the original question
in regards to how DB connections are handled when using the .Net
implementation?

Thanks,
Chris

On 16 Nov 2008 22:43:08 -0800, Sally Li wrote:

> Hi Chris,
>
> Appeon utilizes EAServer to handle the database connection.
> Hereinafter is abstracted from EAServer System
> Administration Guide and EAServer Programmer's Guide. I hope
> it can help your understand how does EAServer(Appeon) handle
> the DB connection. "A connection cache maintains a pool of
> available connections that EAServer components use to
> interact with third-tier data servers. You must configure
> connection caches for the specific user and database
> combinations used by your components. A connection cache
> entry improves performance by eliminating the overhead
> associated with setting up a connection when one is
> required." "Connection Manager controls caches of
> connections that EAServer components use to interact with
> third-tier servers. Connection management allows EAServer to
> service hundreds of clients using only a few third-tier
> database server connections."
>
> For more detail information please post your issue to
> EAServer Forum so that you can get more help from EAServer
> experts.
>
> In appeon, you don’t need to change the Client/Server code
> to make it work on the Web, you just need to implement the
> following to set up the database connection:
> 1. Create connection cache either in EAServer Manger or
> through AEM.
> 2. Set up the mapping between the transaction object and the
> connection cache.
> For this part you can refer Appeon Help | Appeon Server
> Configuration Guide | AEM User Guide | Application
> Properties | Transaction Object and Appeon Server
> Configuration Guide | AEM User Guide | Server Properties |
> Connection Cache
>
> Regards
> Sally
>> My C/S PB app connects to the database when the user
>> initially logs on and disconnects when the user logs off.
>> There are no other connections/disconnections throughout
>> the app. So a connection is active to the database for
>> the entire duration of the app, which could be hours.
>>
>> How does Appeon handle DB connections? Does it just
>> maintain the code that I have in my app, or does it change
>> the way connections are made, since we are in a web
>> environment? In other words, does appeon connect and
>> disconnect each time my app makes a call to the DB?
>>
>> Or do I need to change my app to consider the web
>> environment and implement connections/disconnections each
>> time I call the database?
>>
>> Thanks,
>> Chris