WSAD5.1 + oracle9i problem ora-00600 on one machine-reference
Source: Internet
Author: User
I installed WSAD5.1 + oracle9i on one machine for standalone debugging.
First, install oracle9i Standard Edition (2.5G) on the local machine );
Then, create the test database ebank239
1. Use TOAD to export the tables table structure, sequence, functions function, procdure stored procedure, and packages package from X. X. X.84.
2. Use TOAD to export the table data ebankdata. SQL file
3. Create a tablespace in the ebank239 database
4. Import the tables table structure and sequence on ebank239,
Functions function, procdure stored procedure, packages package
5. Import table data ebankdata. SQL on ebank239
Then, start the application on the local WSAD server, modify the configuration file, and connect to the local database ebank239.
An error occurred while executing the login OP:
SQLException: ORACLE ORA-00600
After debugging, it is found that the stored procedure returns 0 correctly. When the result set returned by the stored procedure is written to iColl, it is executed.
ResultSet authInfoiCollRs = (ResultSet) stmt. getObject (baseRsPos );
An error is reported. Multiple debugging attempts are considered to be a database driver problem. Because the database on X. X. X.84 is ORACLE816, the oracle driver in the WSAD application may need to be upgraded.
Then, upgrade the built-in driver classes12.jar of ORACLE9i under WebContentWEB-INFlib.
After the WSAD server is restarted, the application runs normally.
The above is for your reference.
To those friends who are troubled by such problems ^_^
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.