Environment: myeclipse6.5
Problem: Java. SQL. sqlexception: ORA-00932: Data Type inconsistent: it should be date, but get binary
Project: Background Management
Code:
<S: Form Action = "queryaction! Queryassetinfobyprodate "method =" Post"
Theme = "simple" name = "form" enctype = "multipart/form-Data">
<Table width = "40%" border = "0" cellpadding = "0" cellspacing = "0" id = "additemstable"> <br/>
<Tr>
<TD>
Production date: & nbsp;
</TD>
<TD>
<S: textfield id = "tbassetinfobuydatet" name = "tbassetinfo. tbassetinfobuydatet"
Onclick = "mycalendar. setdate (this)" cssstyle = "width: 150px"
Readonly = "true">
</S: textfield>
</TD>
<TD>
<S: Submit id = "Submit" value = "query" onclick = "Return checkisnull ();"/>
</TD>
</Tr>
</Table>
</S: Form>
Solution: tbassetinfobuydatet is incorrect. It should be bassetinfoprodate.
Summary: if the data corresponding to the field does not exist, this error is reported. Pay attention to it later.
Note: Java. SQL. sqlexception: ORA-00932: inconsistent data types: Should be date, but get other binary solutions:
1. http://topic.csdn.net/u/20110516/14/97a28e4a-415d-4555-bd16-f55d90b0adf2.html
2. http://topic.csdn.net/u/20110516/14/97a28e4a-415d-4555-bd16-f55d90b0adf2.html
3. http://topic.csdn.net/u/20100606/11/ee29fb8e-091d-4083-87d5-f6165dd02943.html