close
JSP在select一個新建SEQUENCE時，出現以下錯誤：
An error occurred when executing the SQL command:
select multilang$id.nextval from dual
ERROR: current transaction is aborted, commands ignored until end of transaction block [SQL State=25P02]
Execution time: 0s
1 statement(s) failed.
select multilang$id.nextval from dual
ERROR: current transaction is aborted, commands ignored until end of transaction block [SQL State=25P02]
Execution time: 0s
1 statement(s) failed.
經過使用edbplus去測試，會出現權限不足的錯誤，
原來，是授權時，除了SELECT，還要給UPDATE的權限，以便在SELECT <seq_name>.NEXTVAL from dual;這種動作時，
除了取得序列值外，還要更新sequence的值。
全站熱搜
留言列表
ESB (2)