Question

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]将数据类型 varchar 转换为 numeric 时出错。

这是什么错啊 怎么转换就对了啊
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]将数据类型 varchar 转换为 numeric 时出错。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown Source)

Answer 1

定义类型错误

varchar(..)字符改为numeric(..)数字

如字符这样改时会错，查一下内容
'123a'

这样转换OK
'123'

Answer 2

varchar转换成String

Answer 3

convert.tonumeric