PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "WORENKLEIN, David, GCM" <David dot Worenklein at gcm dot com>
Subject: RE: Sybperl 2.0 on Sybase- IQ server
Date: Apr 27 1999 4:23PM

Hmm, maybe I'm remembering another language.

-----Original Message-----
From: Michael Peppler [mailto:mpeppler@peppler.org]
Sent: Tuesday, April 27, 1999 10:36 AM
To: SybPerl Discussion List
Subject: RE: Sybperl 2.0 on Sybase- IQ server


WORENKLEIN, David, GCM writes:
 > My understanding is that Sybperl will disconnect some time after the
handle
 > goes out of scope, but it's up to the Perl garbage collector to decide
 > exactly when it happens.  Even if a it usually happens when the handle
goes
 > out of scope, you can't depend on it in future versions of Perl.

Could you point me to some docs or messages that discuss this? 
If this is correct then we should add explicit closing of connections
($dbh->ct_close() I guess) to the Sybase::CTlib module.

Michael

 > 
 > -----Original Message-----
 > From: Michael Peppler [mailto:mpeppler@peppler.org]
 > Sent: Tuesday, April 27, 1999 9:50 AM
 > To: SybPerl Discussion List
 > Subject: Sybperl 2.0 on Sybase- IQ server
 > 
 > 
 > Amy Chua writes:
 >  > I am new to sybperl and currently learning to use sybperl to access an
IQ
 >  > server, to retrieve data and generate a report. I ran into some
problems
 >  > whereby sometimes my program "hang" the IQ server.  I suspect the
problem
 >  > with ct_connect, but I am not sure whether I need to do a "disconnect"
 > from
 >  > the IQ server. As much as I know, there doesn't seem to be a
"disconnect"
 >  > command in CTlib module. Does Sybperl automatically disconnect from
the
 >  > server once CS_CMD_DONE??
 > 
 > Sybperl disconnects automatically when the database handle ($Y in your 
 > example script) goes out of scope, or becomes undefined.
 > 
 > So for example:
 > 
 > 
 > {
 >    my $dbh = Sybase::CTlib->ct_connect(...);
 >    $dbh->ct_execute(...);
 >    
 > }
 > # Here the connection has been closed, because $dbh has gone out of
 > # scope. 
 > 
 > Michael
 > -- 
 > Michael Peppler         -||-  Data Migrations Inc.
 > mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
 > Int. Sybase User Group  -||-  http://www.isug.com
 > Sybase on Linux mailing list: ase-linux-list@isug.com
 > 

-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com