All Questions
Tagged with mybatis-mapper oracle-database
4 questions
0
votes
0
answers
29
views
MyBatis update annotation failed - ORACLE ERROR ORA-00933 [duplicate]
In a classic spring boot application I've this query in Mapper
@Update("UPDATE MY_TABLE SET STATUS_CODE=#{status} WHERE ID_DOC=#{idDoc};")
void updateStatus(@Param("status") final ...
- 801
0
votes
2
answers
63
views
Using if statement to select table inside FROM statement in ORACLE
please someone help me.
I want to convert this query from mybatis to ORACLE
SELECT *
FROM TABLE_A
<if paramA is not null>
, ( SELECT *
FROM TABLE_B
) B
</if>
...
- 3
0
votes
1
answer
189
views
Insert data in 2 tables MyBatis Error Command not properly ended
I´m trying to insert data in 2 tables, I have mybatis method with 2 single inserts but when I execute it it throws:
Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL ...
- 43
1
vote
2
answers
2k
views
coalesce mybatis switch case
Iam using coalesce mybatis switch case in my query, where iam getting error like
Error querying database. Cause: java.sql.SQLException: ORA-01427:
single-row subquery returns more than one row
...
- 13