- java.sql.SQLSyntaxErrorException: ORA-01791: not a SELECTed expression
查询中使用了DISTINCT或者GROUP BY子句时,order by中的排序字段就必须出现在select列表中,否则就会报上述错误。
- java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into `````
ORA-01400: 无法将 NULL 插入
- java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint
数据唯一性约束
java.sql.SQLException: ORA-01489: result of string concatenation is too long |
java.sql.BatchUpdateException: error occurred during batching: ORA-01438: value larger than specified precision allowed for this column |