Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the difference between mysql and oracle when inserting mybatisation". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Let's look at an exception first.

# Cause: java.sql.SQLException: ORA-00911: invalid character

; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00911: invalid character

:

Java.sql.SQLException: ORA-00911: invalid character

I'm sure you can see that this is an invalid character error.

The source of the problem is used in the experiment.

Of the mapper xml file

The sql statement is:

Insert into C_USER (ID,LOGIN_NAME,PASSWORD,EMAIL)

Values (# {id}, # {loginName}, # {password}, # {email})

There's nothing wrong with it now.

When you change to oracle, you will report the above error. If you check the error carefully, you will find nothing. If you report the error, you will also tell you which character is zero.

As a matter of fact, this piece is still not taken very seriously. If you look at it carefully, you will find the small semicolon in front of the mistake.

Then try to remove the small semicolon after sql, no problem.

1 should look at the exception word by word in the future

Don't add a semicolon to the sql of 2 oracle

This is the end of the content of "what is the difference between mysql and oracle when mybatisation is inserted". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.