Re: [Gusdev-gusdev] DBD::Oracle::db prepare failed

[Steve F. <sfi...@pc...>]

Chetna-

I am not sure what is causing the problem.

However, I can see that the code which is failing is not doing the best 
job of reporting what went wrong.

How about you make the following patch to the file 
$PROJECT_HOME/GUS/ObjRelP/lib/perl/DbiDbHandle.pm:

On around line 74 you will find the method  prepareAndExecute.

Comment it out, and replace it with this:

sub prepareAndExecute {
  my ($self, $sql_cmd) = @_;
  if ($verbose) { print STDERR"\n\nprepareAndExecute: $sql_cmd \n"; }

  my $sth = $self->prepare($sql_cmd) || print STDERR "Prepare FAILED: " 
. $self->errstr() . "\n sql_cmd:  \n $sql_cmd \n";
  $sth->execute() || print STDERR "Execute FAILED: " . $self->errstr() . 
"\n sql_cmd:  \n $sql_cmd \n";
  return $sth;
}

then try the build again.

let me know what happens.

steve

Chetna Warade wrote:

>Hello All,
>
>I have followed the step by step documentation from
>Terry and also reffered section 2.4 but I am still
>getting the same error:  I am also printing the values
>such as userid, host etc.. that assures that the login
>exists,
>Here's snapshot:
>
># build GUS install -append
>
>ant -f /var/local/checkout/install/build.xml install
>-Dproj=GUS -DtargetDir=/var/local/gus_home -Dcomp=
>-DprojectsDir=/var/local/checkout  -Dappend=true  
>-logger org.apache.tools.ant.NoBannerLogger | grep ']'
>
>     [echo] .
>     [echo] Installing CBIL/Bio
>     [echo] .
>     [echo] Installing CBIL/CSP
>     [echo] .
>     [echo] Installing CBIL/Util
>   [concat] Warning: Could not find any of the files
>specified in concat task.
>     [echo] .
>     [echo] Installing GUS/Common
>     [echo] .
>     [echo] Installing GUS/DBAdmin
>     [echo] .
>     [echo] Installing GUS/GOPredict
>     [echo] .
>     [echo] Installing GUS/ObjRelP
>     [echo] generating Perl Objects
>     [exec] Reading properties from
>/root/.gus.properties
>     [exec] DBI subclasses
>'GUS::ObjRelP::DbiDbHandle::db' and ::st are not
>setup, RootClass ignored at
>/var/local/gus_home/lib/perl/GUS/ObjRelP/DbiDatabase.pm
>line 152
>     [exec] DBD::Oracle::db prepare failed: ORA-00942:
>table or view does not exist (DBD ERROR:
>OCIStmtExecute/Describe) at
>/var/local/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm
>line 78.
>     [exec] prepareAndExecute FAILED:
>GUS::ObjRelP::DbiDbHandle=HASH(0x83dd120)->errstr
>     [exec] Can't call method "execute" without a
>package or object reference at
>/var/local/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm
>line 79.
>     [exec] GUS::ObjRelP::DbiDbHandle
>dbi:Oracle:host=kiwi.rcr.uga.edu;sid=CTEGD GUSReadOnly
>GUSReadOnly1111  0 1
>
>BUILD FAILED
>file:/var/local/checkout/GUS/build.xml:194: exec
>returned: -1
>
>Total time: 6 seconds
>
>Thanks in advance,
>Chetna
>
>
>--- Terry Clark <tw...@cs...> wrote:
>  
>
>>Chetna, this looks like the circular dependence in
>>the build. 
>>There's a work around for this documented at 
>>  
>>http://www.gusdb.org/documentation/installguide.html
>>in section 2.4.
>>
>>Terry
>>    
>>
>
>
>
>
>__________________________________
>Do you Yahoo!?
>The New Yahoo! Shopping - with improved product search
>http://shopping.yahoo.com
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: The SF.net Donation Program.
>Do you like what SourceForge.net is doing for the Open
>Source Community?  Make a contribution, and help us add new
>features and functionality. Click here: http://sourceforge.net/donate/
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>  
>