http://qs321.pair.com?node_id=734099

B-A-T has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I am trying to store a data structure in using Apache::Session::MySQL.
The session creation and retrieval works fine for scalar values,HoH or Array etc,
but the session is not written if i try to store a tree data structure (N-ary tree http://search.cpan.org/~rkinyon/Tree-1.01/lib/Tree.pm) The code is as follows: --
my %session; tie %session,'Apache::Session::MySQL', undef, { DataSource => 'dbi:mysql:sessions', UserName => 'login', Password => 'pass', LockDataSource => 'dbi:mysql:sessions', LockUserName => 'login', LockPassword => 'pass' }; my $id = $session{_session_id}; $session{TIMESTAMP} =time; $session{tree} = $treeP; ## $treeP is a N-ary Tree $session{uname} = $uname; untie(%session) || die " Cant untie! \n"; ##-- in another code my %session1; tie %session1,'Apache::Session::MySQL', undef, { DataSource => 'dbi:mysql:sessions', UserName => 'login', Password => 'pass', LockDataSource => 'dbi:mysql:sessions', LockUserName => 'login', LockPassword => 'pass' }; my $u = $session1{uname}; ## this value is undef if I try to store the + tree as well in the above code print STDERR "name $u \n"; untie(%session1) or die "CANT CLOSE!! \n";
========

Can anyone help?

Thanks in advance...

cheers!