菜鸟请教SQLCODE: -204, SQLSTATE: 42704问题.
DB2新手,现在刚装了9.7版,但在查询时提示: StatementCallback; bad SQL grammar [select PROTECTED_RES ,TYPE_, AUTHORITY_NAME from OA_SA_RESOURCEr ,OA_SA_RES_AUTHa
where r.RES_ID=a.RES_ID order by PROTECTED_RES Desc
]; nested exception is com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.OA_SA_RESOURCE
Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.OA_SA_RESOURCE请问是不是建库建表后,还要分配权限,是不是权限问题造成的? 是通过JDBC连接进行查询的。
页:
[1]