Home > database >  Oracle query error
Oracle query error

Time:10-01

Org. Springframework. JDBC. BadSqlGrammarException: StatementCallback;
Bad SQL grammar [select kc. * from user_kc fairly rk left join exam_info kc on (kc kcid=rk kcid) where rk userid='1' and kc kcid!='1');
Nested exception is Java. SQL. SQLException: invalid column name
-- -- -- -- -- -- -- -- -- --
The select kc * from user_kc fairly rk left join exam_info kc on (kc kcid=rk kcid) where rk userid='1' and kc kcid!
='1'This statement in PLSQL test no problem, but not a login?

CodePudding user response:

Link is the same library"

CodePudding user response:

Development environment called statement, there is a clear case?

CodePudding user response:

Is to use the same user connections?

CodePudding user response:

A: data source with fault

CodePudding user response:

Great possibilities are PL/SQL login server and the inconsistency of the page, or user name is different, lead to access is not the same table

Whether a formal environment, a test environment? Two table structure is inconsistent?
  • Related