Okay, here is my off-the-cuff guess.

Why not change package class_Y from
@ISA = qw( class_X );
to
@ISA = qw( DBI class_X );