database connectivity

From: seth (satyen.sheth_at_gmail.com)
Date: 01/29/05

  • Next message: Peter J. Holzer: "Re: CAN-2005-0077" 
    Date: 28 Jan 2005 15:36:55 -0800

    Hi:

    I'm writing some code using DBI in perl and using mysql version 3.xx

    I am doing the following:

    sub Setup {
    .. create handle ( DBI::connect ... )
    .. insert to mysql
    $self->{"dbh"} = $dbh;
    }

    sub Update {
    my $self = shift;
    my $dbh = $self->{"dbh"};

    .. do more sql updates
    }

    the sql updates fail in the "Update" method.

    I want to find out if my $dbh is still able to talk to the database
    properly between the first sql query and the second one.

    Besides $dbh->ping is there any other $dbh utility to help verify if my
    handle object is sane between the two methods?

    -thanks

  • Next message: Peter J. Holzer: "Re: CAN-2005-0077"