1.
2.
Insert ID = "Insertcontent"Parameterclass = "Com. unmi. Content" >
3.
Insert into person (ID, name, serviceid) values (# ID #, # name #, # serviceid #)
4.
Insert >
// The three child segments can be null)
1.
[Error Note] MyBatis SQLException: Invalid column type: 1111,
Problem description:
Org. springframework. jdbc. uncategorizedSQLException: Error setting null for parameter #1 with JdbcType OTHER. try setting a different JdbcType for this parameter
Java. SQL. SQLException: ORA-24778: Unable to open the connection,
Weblogic log reported: java. SQL. SQLException: ORA-24778: Unable to open the connection. The analysis function is used to perform multiple operations on a remote table. First, view
Some java. SQL. sqlexception exceptions are frequently encountered,
ORA-00904:Invalid invalid column name
ORA-00942:Table or view does not exist table or view does not exist
ORA-01400:Cannot insert null into () cannot insert null
When using Oracle, you always encounter java. SQL. the SQLException error caused me to be exhausted on the Internet, so I checked several common ones in one breath and listed them here. english is from the official website. I have simply translated
Ora-00904:invalid Column name is invalidOra-00942:table or view does not exist tables or views do not existOra-01400:cannot insert null into () cannot insert a null valueORA-00936: Missing An expressionOra-00933:sql command did not end correctlyORA-0
I often encounter some exceptions in Java. SQL. sqlexception. I collected some previous documents from the Internet and listed them in the original English documents for future debugging!ORA-00904: Invalid column name invalid column nameORA-00942:
Java. SQL. sqlexception: Io exception: the network adapter cocould not establish the connection is a problem I encountered today.
This is due to many reasons, and there are answers online. My main problem is that the line in hibernate. properties is
In the MySQL database, the datetime type is used to store the time. When reading this field using JDBC, The resultset should be used. gettimestamp () to get a java. SQL. timestamp type data. In this case, neither resultset. getdate () nor resultset.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.