1, the problem is that the application to open the page out of the data is not correct, PLSQL connect to the database of the query result is correct,
Environment for weblogic + oracle (RAC cluster two nodes)
2, a detailed description and analysis done
(1) production found application at the front desk to open a blank page, no data is returned (normal data should be returned by the development also seen program, is through an SQL statement, execution returns a few lines and then integrated display)
(2) extraction process in this statement, write a few variables in, PLSQL query, display the correct data, PLSQL execution according to article 6,
(3) check the weblogic log, check the SQL execution log, found that returned to article 1, (this should be the problem, weblogic execution statement returns the amount of data and PLSQL returned inconsistent)
(4) the suspect dirty read originally, but this problem many days, reboot during application, the table also didn't lock, and communicated at the front desk operator, confirm PLSQL the results of a query is correct, the application displays incorrect,
(5) open SQL trac have seen no problem,
Action how to troubleshoot a great god,,, thank you,

CodePudding user response:

Whether the program in business operations, such as runtime delete, so you have the data operation PLSQL, programs run no data, still need to check the program code

CodePudding user response:

reference 1st floor sxq129601 response:

in whether the program run business operations such as delete, so you have the data operation PLSQL, programs run no data, but also need to check the program code

Is not the problem, because this problem more than ten days, during all the restart the application, thanks, and see what may,

CodePudding user response:

Don't understand weblogic,
Check under the conditions of correct? And compared to those variables are used in the program?

CodePudding user response:

reference js14982 reply: 3/f

don't understand weblogic,
Check under the conditions of correct? And compared to those variables are used in the program?

Conditions are right, the inside of the SQL trac variable called is correct,

CodePudding user response:

Whether weblogic configuration has a problem, whether is configured with the cluster, or match to the other libraries, and whether there is a match F5 and load of things

CodePudding user response:

reference 5 floor sxq129601 reply:

whether weblogic configuration has a problem, whether the configured clusters, or to other libraries, and if there is a load of things such as the match F5

I think the problem is not so complicated,
SQL directly print it out, if there is a variable, together with the variable print it out

CodePudding user response:

refer to 6th floor jdsnhan response:

Quote: refer to the fifth floor sxq129601 reply:

Whether weblogic configuration has a problem, whether is configured with the cluster, or match to the other libraries, and if there is a load of things such as the match F5

I think the problem is not so complicated,
SQL directly print it out, if there is a variable, together with the variable print out

Printing is what mean? I see have trac SQL statements and variables, and the key is to take the same statement, variable write statements, and the results of the PLSQL inconsistent ~!

CodePudding user response:

refer to 7th floor qq_21378183 response:

Quote: refer to the sixth floor jdsnhan response:

Quote: refer to the fifth floor sxq129601 reply:

Whether weblogic configuration has a problem, whether is configured with the cluster, or match to the other libraries, and if there is a load of things such as the match F5

I think the problem is not so complicated,
SQL directly print it out, if there is a variable, together with the variable print out

Printing is what mean? I see have trac SQL statements and variables, and the key is to take the same statement, variable write statements, and the results of the PLSQL inconsistent ~!

Looking for developers, the development of the log, or print out where there is a problem