错误堆砌的人生

只是做了一个文件上传（已完工），但错误百出。今天贴上来，纪念下。我在想这一生是不是将会这样进行下去……  

Description:com.jacob.com.ComFailException: Invoke of: Item

Source: Microsoft Word javax.servlet.ServletException: java.lang.NoClassDefFoundError: com/jacob/com/Dispatch 

java.lang.NoClassDefFoundError: com/jacob/com/Dispatch   java.lang.ClassNotFoundException: com.jacob.com.Dispatch   com.jacob.com.ComFailException: Invoke of: ItemSource: Microsoft WordDescription:解决办法，是由于循环中的变量出现了问题，查看，把i＝0，改为i=1

-------------------------------------------------------------------------------- org.apache.jasper.JasperException: java.io.FileNotFoundException: c:/upload/tm.doc (请求的操作无法在使用用户映射区域打开的文件上执行。)是由于，所需的文件已经被打开   ------------------------------------------------------------------------------- java.lang.NullPointerException这种错误是java代码中的错误。

主要有以下几种原因： 1、使用了未初始化的变量（虽然已经声明）

2、使用了未初始化的对象（虽然已经声明）

3，使用了关键字或已存在的类名作变量对象方法或类名。

  -------------------------------------------

 java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]解析得到的定位器无效。 --------------------------------- 循环出错

java.lang.NullPointerException Source: Microsoft Word  [Microsoft][ODBC SQL Server Driver]函数序列错误

End of InputStream reached before satisfying length specified when InputStream was set  

 com.jacob.com.ComFailException: Invoke of: PasteSource: Microsoft Word  

com.jacob.com.ComFailException: Invoke of: OpenSource: Microsoft WordDescription: ?j?j 

 com.jacob.com.ComFailException: Invoke of: PasteSource: Microsoft WordDescription:

 com.jacob.com.ComFailException: Invoke of: OpenSource: Microsoft Word

java.lang.ClassCastException: Dispatch object expected 

com.jacob.com.ComFailException: A COM exception has been encountered:At Invoke of: TablesDescription: ±??÷?????ó????????§? ql.

SQLException:[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '＝' 附近有语法错误。

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在此上下文中不允许使用 '单选题'。此处只允许使用常量、表达式或变量。不允许使用列名。

 java.sql.SQLException: No suitable driver found for dbc:microsoft:sqlserver://localhost:1433;DatabaseName=Questionlibrary

 2008-4-26 11:23:28 org.apache.catalina.loader.WebappClassLoader modified严重:     Resource '/WEB-INF/classes/MSWord/JavaToWord.class' is missing2008-4-26 11:23:28 org.apache.catalina.core.StandardContext reload信息: Reloading this Context has started  

SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在此上下文中不允许使用 '单选题'。此处只允许使用常量、表达式或变量。不允许使用列名。 

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '＝' 附近有语法错误。

java.lang.NullPointerException  java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法将 NULL 值插入列 '课程ID'，表 'Questionlibrary.dbo.知识点表'；该列不允许空值。INSERT 失败。 

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '＝' 附近有语法错误。

java.lang.NullPointerException 

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK__知识点表__课程ID__07F6335A' 冲突。该冲突发生于数据库 'Questionlibrary'，表 '课程表', column '课程ID'。 /先更新作为主键的表

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '＝' 附近有语法错误。java.lang.NullPointerException  .

sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]违反了 UNIQUE KEY 约束 'UQ__知识点表__07020F21'。不能在对象 '知识点表' 中插入重复键。  java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '＝' 附近有语法错误。

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '＝' 附近有语法错误。

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]违反了 UNIQUE KEY 约束 'UQ__知识点表__07020F21'。不能在对象 '知识点表' 中插入重复键。   java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]列名 '单选题' 无效。

java.lang.NullPointerException   a.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '.1' 附近有语法错误。

java.lang.NullPointerException ava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '１' 附近有语法错误。

java.lang.NullPointerException 由于文件许可权错误，word无法完成保存操作由于文件许可权错误，word无法完成保存操作c:/documnet~1/admin~1/...../~wrd00003.doc   query.getResult()==:com.microsoft.jdbc.base.BaseResultSet@1d5a0

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

出现Can't start a cloned connection while in manual transaction mode错误，从网上找到原因及解决办法如下： 原因一般是当你在一个SQL SERVER的JDBC连接上执行多个STATEMENTS的操作，或者是手动事务状态（AutoCommit=false) 并且使用默认的模式. direct (SelectMethod=direct) 模式. 解决办法当你使用手动事务模式时，必须把SelectMethod 属性的值设置为 Cursor, 或者是确保在你的连接只有一个STATEMENT操作。修改url 加入SelectMethod=cursor即可

如:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ys;SelectMethod=Cursor;User=ys;Password=ys");   If you pass "SelectMethod=cursor" attribute in connectio url, will allow more than one active statement per connection."

jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;","user","pwd"The reason for this is;When SelectMethod is set to direct, SQL Server does not support multiple active statements on a single connection within a transaction; however, when auto-commit mode is enabled (the default), the Microsoft SQL Server JDBC driver provides the ability to have multiple JDBC statements open on a single JDBC connection. This is done by cloning physical SQL Server connections as needed. To avoid cloning physical SQL Server connections in this circumstance, you should create only one Statement, PreparedStatement, CallableStatement, or DatabaseMetaData object per JDBC Connection object. Be sure to invoke the "close" methods on these objects when you are finished with them, that is, before creating another object of the types described.Sridhar PaladuguMicrosoft Developer SupportJDBC Webdata 

 

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]违反了 UNIQUE KEY 约束 'UQ__知识点表__07020F21'。不能在对象 '知识点表' 中插入重复键。 ava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]违反了 UNIQUE KEY 约束 'UQ__知识点表__07020F21'。不能在对象 '知识点表' 中插入重复键。 

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

  java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 '适用对象' 无效。

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.applicableObjectId:0driverName:com.microsoft.jdbc.sqlserver.SQLServerDriver

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.  

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]违反了 UNIQUE KEY 约束 'UQ__知识点表__07020F21'。不能在对象 '知识点表' 中插入重复键。

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 '适用对象' 无效。

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.applicableObjectId:0driverName:com.microsoft.jdbc.sqlserver.SQLServerDriver  

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.  原因是返回的ResultSet对象的游标还在数据集的最上方，需要加一句：rs.next()！

Unsupported method: ResultSet.first

Java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.  

 java.lang.NullPointerException ava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).  

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).将.executeQuery();  改成.execute();  应该就没问题了.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法将 NULL 值插入列 '课程ID'，表 'Questionlibrary.dbo.试题表'；该列不允许空值。INSERT 失败。

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]操作数类型冲突: int 与 image 不兼容

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK__试题表__出题教师ID__1B0907CE' 冲突。该冲突发生于数据库 'Questionlibrary'，表 '教师表', column '教师ID'。  

 

 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.