sql錯誤

找不到列
Unknown column 'fillMen' in 'field list'

2.列名在sql語句中寫了2次
Column 'fillMan' specified twice

3.下面2條 數據庫插入對應的列都是int類型的? 所插入的數據類型不符合要求時報錯
Data truncated for column 'gatheringMoney' at row 1

Data truncation: Out of range value adjusted for column 'amount' at row 1

4.
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

5.修改一個表時無法取得同一個表的數據
ERROR 1093 (HY000): You can't specify target table 'context' for update in FROM
clause

6.主鍵 未自動增長
ERROR 1062 ：

7.int 類型字符過長
com.mysql.jdbc.exceptions.MySQLDataException: '2.5026744582E10' in column '1' is outside valid range for the datatype INTEGER.

8.沒找到錯誤 沒影響數據讀取
java.sql.SQLException: Operation not allowed after ResultSet closed

9.類型錯誤 最常見的是數字類型錯誤
Data truncated for column 'gatheringMoney' at row 1

10.換另一個項目時 數據庫連接池沒換 （未解）
Name java: is not bound in this Context
換了之后 似乎還是不行
=====
java:/comp/env/jdbc/ConnSqlSer
前面多了一個'/'
應為java:comp/env/jdbc/ConnSqlSer
=======
11.\（未解）
java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in

12.executeQuery()方法改成execute()（未解）
Can not issue data manipulation statements with executeQuery().

Can not issue data manipulation statements with executeQuery().

struts錯誤

?Failed to obtain specified collection? 下拉框沒值
警告: No FormBeanConfig found under 'yuanLiaoRuKuForm'? 配置文件Form出錯

?

Cannot find bean: "org.apache.struts.taglib.html.BEAN" in any scope
<html:text >標簽外面沒有嵌套<html:form >標簽

No getter method for property: "outDate" of bean: "com.System.storage.form.YuanliaoPandianForm"
在form里面沒有定義 此字段的get方法

?

Cannot get a connection, pool error Timeout waiting for idle object?? 數據庫錯誤

?Operation not allowed after ResultSet closed??可能是結果集關閉了

?

//在Action里面調用的DAO類 沒有進行重新實例化
2008-5-12 20:02:09 org.apache.struts.action.RequestProcessor processException
警告: Unhandled Exception thrown: class java.lang.NullPointerException
2008-5-12 20:02:09 org.apache.catalina.core.StandardWrapperValve invoke
嚴重: Servlet.service() for servlet action threw exception
java.lang.NullPointerException
?at com.System.storage.action.FinishedAction.finishedCheckAdd(FinishedAction.java:151)
?at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

//在C標簽里從一個對象里取值時 ， 所請求的是對象里沒有的屬性
An error occurred while evaluating custom action attribute "value" with value "${rows.storageAmount}": Unable to find a value for "storageAmount" in object of class "com.System.storage.domain.Finished" using operator "." (null)

forward 轉向 連接到了一個還沒開始寫的action里面 而那個action所對應的jsp頁面還沒改
Resources cannot be null.

找不到下面這個action
Cannot retrieve mapping for action /finished/finishedChuKuSearch
?Cannot retrieve mapping for action /purveyAdd? 如果把jsp頁面的action寫錯了 就這樣報

/jspfinance/client/ShouKuanJiLu_Sel.jsp(172,0) The end tag "&lt;/html:form" is unbalanced

類型轉換錯誤 一般是參數類型寫錯 在公共方法或者配置文件里面找
com.System.finance.client.form.GatheringForm cannot be cast to com.System.finance.client.form.InvoiceForm
??
struts標簽里面 寫進了html標簽內的屬性
/jspclient/KeHuDangAn_Ins.jsp(44,88) equal symbol expected
/jspfinance/client/TuiHuanHuo_Ins.jsp(70,42) quote symbol expected
/jspstorage/material/YuanLiaoChuKu_Ins.jsp(84,31) equal symbol expected
org.apache.jasper.JasperException: /scDept/dingDanXinZeng.jsp(333,167) equal symbol expected

jsp頁面上action寫錯了
Cannot retrieve mapping for action /finished/finishedCheckAdd

配置文件出錯
The content of element type "action-mappings" must match "(action)*".

轉載于:https://www.cnblogs.com/jiandanfy/archive/2008/06/11/1217568.html

總結

以上是生活随笔為你收集整理的java 项目中遇到的错误的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。