in reply to Re^3: Error running CGI on tomcat in thread Error running CGI on tomcat
Hi,
I tried this format of the connection string, but it now gives this error:
Error ORA-12560: TNS:protocol adapter error (DBD ERROR: OCIServerAttach) connecting to DBI:Oracle:ORADEV
Any ideas? I am banging my head, wondering what environment variables etc might be missing!!!
Re^5: Error running CGI on tomcat
by rdfield (Priest) on Sep 13, 2007 at 11:23 UTC
|
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.
| [reply] |
|
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?
| [reply] |
|
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.
| [reply] [d/l] |
|