Visit Our UNIX and Linux User Community


Perl - DB Commits


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Perl - DB Commits
# 1  
Old 09-23-2009
Perl - DB Commits

Hello,

I have a problem with DB handling in Perl.

Module 1 ---calls--> Module 2

Module 1 creates a DB Connection and passes the DB handle to Module2.

In module 2, I perform some Selects and Updates using this DB Handle.

Now Selects are ok....but after Update, when I give
Code:
dbh->commit()

.....I see nothing is done in the database.

Could somebody please let me know how to debug this...or what might be happening in the background.

ThanksSmilie

Previous Thread | Next Thread
Test Your Knowledge in Computers #522
Difficulty: Medium
11,223 = 0x2BD7
True or False?

9 More Discussions You Might Find Interesting

1. Programming

PERL: In a perl-scripttTrying to execute another perl-script that SETS SOME VARIABLES !

I have reviewed many examples on-line about running another process (either PERL or shell command or a program), but do not find any usefull for my needs way. (Reviewed and not useful the system(), 'back ticks', exec() and open()) I would like to run another PERL-script from first one, not... (1 Reply)
Discussion started by: alex_5161
1 Replies

2. Programming

Perl: restrict perl from automaticaly creating a hash branches on check

My issue is that the perl script (as I have done it so far) created empty branches when I try to check some branches on existence. I am using multydimentional hashes: found it as the best way for information that I need to handle. Saing multidimentional I means hash of hashes ... So, I have ... (2 Replies)
Discussion started by: alex_5161
2 Replies

3. UNIX for Advanced & Expert Users

perl and HP-UX : instmodsh in combination with software depot : update inventory for installed Perl

we create a HP-UX software depot with a new perl-modul. after installation of the software depot, the perl module i can't find with instmodsh in the inventory for installed Perl modules. - i have learned of using instmodsh command : i find out what modules are already installed on my system. ... (0 Replies)
Discussion started by: bora99
0 Replies

4. Shell Programming and Scripting

HELP on Perl array / sorting - trying to convert Korn Shell Script to Perl

Hi all, Not sure if this should be in the programming forum, but I believe it will get more response under the Shell Programming and Scripting FORUM. Am trying to write a customized df script in Perl and need some help with regards to using arrays and file handlers. At the moment am... (3 Replies)
Discussion started by: newbie_01
3 Replies

5. Shell Programming and Scripting

Hidden Characters in Regular Expression Matching Perl - Perl Newbie

I am completely new to perl programming. My father is helping me learn said programming language. However, I am stuck on one of the assignments he has given me, and I can't find very much help with it via google, either because I have a tiny attention span, or because I can be very very dense. ... (4 Replies)
Discussion started by: kittyluva2
4 Replies

6. Shell Programming and Scripting

Perl :How to print the o/p of a Perl script on console and redirecting same in log file @ same time.

How can i print the output of a perl script on a unix console and redirect the same in a log file under same directory simultaneously ? Like in Shell script, we use tee, is there anything in Perl or any other option ? (2 Replies)
Discussion started by: butterfly20
2 Replies

7. Shell Programming and Scripting

perl/unix: script in command line works but not in perl

so in unix this command works works and shows me a list of directories find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt but when i try running a perl script to run this command my $query = 'find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt';... (2 Replies)
Discussion started by: kpddong
2 Replies

8. Shell Programming and Scripting

Passing date formats in Perl: i.e. Jul/10/2007 -> 20070710 (yyyymmdd) - Perl

Hi , This script working for fine if pass script-name.sh Jul/10/2007 ,I want to pass 20070710(yyyymmdd) .Please any help it should be appereciated. use Time::Local; my $d = $ARGV; my $t = $ARGV; my $m = ""; @d = split /\//, $d; @t = split /:/, $t; if ( $d eq "Jan" ) { $m = 0 }... (7 Replies)
Discussion started by: akil
7 Replies

9. Shell Programming and Scripting

[Perl] Accessing array elements within a sed command in Perl script

I am trying to use a script to replace the header of each file, whose filename are stored within the array $test, using the sed command within a Perl script as follows: $count = 0; while ( $count < $#test ) { `sed -e 's/BIOGRF 321/BIOGRF 332/g' ${test} > 0`; `cat 0 >... (2 Replies)
Discussion started by: userix
2 Replies
Perl::Critic::Policy::Modules::ProhibitConditionalUseStaUsernContributed Perl Perl::Critic::Policy::Modules::ProhibitConditionalUseStatements(3pm)

NAME
Perl::Critic::Policy::Modules::ProhibitConditionalUseStatements - Avoid putting conditional logic around compile-time includes. AFFILIATION
This Policy is part of the core Perl::Critic distribution. DESCRIPTION
Modules included via "use" are loaded at compile-time. Placing conditional logic around the "use" statement has no effect on whether the module will be loaded. Doing so can also serve to confuse the reader as to the author's original intent. If you need to conditionally load a module you should be using "require" instead. This policy will catch the following forms of conditional "use" statements: # if-elsif-else if ($a == 1) { use Module; } if ($a == 1) { } elsif ($a == 2) { use Module; } if ($a == 1) { } else { use Module; } # for/foreach for (1..$a) { use Module; } foreach (@a) { use Module; } # while while ($a == 1) { use Module; } # unless unless ($a == 1) { use Module; } # until until ($a == 1) { use Module; } # do-condition do { use Module; } if $a == 1; do { use Module; } while $a == 1; do { use Module; } unless $a == 1; do { use Module; } until $a == 1; # operator-do $a == 1 || do { use Module; }; $a == 1 && do { use Module; }; $a == 1 or do { use Module; }; $a == 1 and do { use Module; }; # non-string eval eval { use Module; }; Including a module via "use" in bare blocks, standalone do blocks, or string evals is allowed. # bare block { use Module; } # do do { use Module; } # string eval eval "use Module"; CONFIGURATION
This Policy is not configurable except for the standard options. AUTHOR
Peter Guzis <pguzis@cpan.org> COPYRIGHT
Copyright (c) 2010-2011 Peter Guzis. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of this license can be found in the LICENSE file included with this module. perl v5.14.2 2012-06-07Perl::Critic::Policy::Modules::ProhibitConditionalUseStatements(3pm)

Featured Tech Videos