today for code development to meet the Type definition error: [simple Type, class oracle JDBC. OracleConnection]; Nested-exception is… After checking all the data, I finally found that it was caused by the wm_concat() function in Oracle. Wm_concat () will return different field types depending on the oracle version. Clob type will be returned in oracle11g and varchar type will be returned in oracle10g.
the solution is as follows:
select qlrid,to_char(wm_concat(qlr)) as qlr,to_char(wm_concat(qlrzjh)) as qlrzjh from qlr t group by qlrid;
div>
Read More:
- How to Solve mybatis returns null when querying Oracle database with char type field
- How to save big data in Oracle to CLOB
- Error attempting to get column ‘failure_msg‘ from result set
- Oci-22053: overflow error problem
- Concat error caused by tensorflow version
- SQL query time group_ Was cut by group_ CONCAT()
- Ctfhub error injection
- Oracle ORA-00984:column not allowed here
- ERROR: invalid byte sequence for encoding “UTF8”: 0x00
- Solution to the problem that SQL database query result field contains new line character, which leads to copy to excel dislocation
- The COMMIT TRANSACTION request has no corresponding BEGIN
- ERROR 1406 (22001): Data Too Long, field len 30, data len 48
- On the coercion of C language
- nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property
- An unable to locate appropriate constructor on class solution appears
- Mybatis integrates Oracle query and reports an error in the datetime type field
- Definition of bracket type in typescript
- Analysis of compilation errors of “error conflicting types for function”
- 12-web security — error injection based on SQL Server — and, convert, cast