Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re^5: Error running CGI on tomcat

by rdfield (Priest)
on Sep 13, 2007 at 11:23 UTC ( #638771=note: print w/ replies, xml ) Need Help??

in reply to Re^4: Error running CGI on tomcat
in thread Error running CGI on tomcat

There should be an error stack in your sqlnet.log file, the error above is a generic error, and more detailed infomation should be recorded in the log file.


Comment on Re^5: Error running CGI on tomcat
Replies are listed 'Best First'.
Re^6: Error running CGI on tomcat
by sdeshpan (Initiate) on Sep 13, 2007 at 17:50 UTC
    Can you please help me locate the sqlnet.log file? Is it the one under the deafult C:\Documents and Settings\<user> folder? Also, I just found out that the Oracle DB connectivity code works fine as a PL file from the command line using perl.exe. It is only through a CGI script (web) that it is failing. I am not sure, but may be the code cannot read ORACLE_HOME in the CGI, running on tomcat! Any ideas on how I can make the Windows Environment Variables visible to the CGI script?
      You could check the environment in both scripts:
      foreach my $key (%ENV) { print "$key => $ENV{$key}; }
      and make sure that they are the same. You might also want to check @INC too: your tomcat installation might be pointing to a different perl (& libraries) than your command line.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://638771]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2015-10-09 03:46 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (233 votes), past polls