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


in reply to Shared DBI handle supporting threads and processes

my $ins_sql = ... my $sel_sql = ...

Imho, SELECT and INSERT are not all that interesting. UPDATE is more of a challenge.

Replies are listed 'Best First'.
Re^2: Shared DBI handle supporting threads and processes
by marioroy (Prior) on Apr 13, 2020 at 07:20 UTC

    Greetings erix. I updated the example by adding the missing 'do' method to the shared class. Also, updating a record.

      Thanks for the example. I ran it, and the DB was populated, but the code ended in the error:
      Bizarre copy of ARRAY in list assignment at C:/Users/USERNAME/eclipse- +workspace/.metadata/.plugins/org.epic.debug/perl5db.pl line 6548, <__ +ANONIO__> line 4. END failed--call queue aborted, <__ANONIO__> line 4. at C:/Users/USERNAME/eclipse-workspace/PROJECT/mce_example_3.pl line +0, <__ANONIO__> line 4.
      So I opened perl5db.pl, and line 6548 reads:
      ... sub _dump_trace_calc_saved_single_arg { my ($nothard, $arg) = @_; # <-- LINE 6548 my $type; if ( not defined $arg ) { # undefined parameter return "undef"; } ...
      Any ideas?
          /org.epic.debug/perl5db.pl

        You seem to be running the code not only with the perldebuger but inside the Eclipse IDE too.

        - Ron