???
改成nvarchar呢?有没有问题?
改成nvarchar呢?有没有问题?
解决方案 »
- java runtime执行命令行和预期结果不一致
- Java的GC机制到底怎么回事
- TESTKILLER里面的 310-055 的填空题 怎么没有答案啊 ?
- *****跪求*****Jtree不知道可以添加多个根节点不?如果可以请问怎么做啊.
- Collection的原代码看不到?
- 如何定义一个数组类呢?
- 新人求助, 一个java的基础问题
- 师傅们,帮我看看这段代码把,我用jb运行时他只向数据库中添加了两条记录。
- 也许只有高手才能回答这个问题了
- java IO 的类太复杂了,我到底该用哪些啊?
- 手机数据传输倒计算机,如何实现??
- 类GridBagLayout中的setConstraints方法怎么使用?
因为varchar是变长的,而char是固定长度的。
通常出错的情况是:因为字段是char,而输入的字符数没有达到设定的长度而出错;相反varchar就没有此况。
sql 语句一般都是一样的。
我没有这个问题,无论使用varchar还是char我都没有输到设定长度。
我没有使用sql语句,我只是用了几个简单的组件,database,querydataset,jdbtable,jdbnavtoolbar,jdbstatuslabel.
See com.borland.dx.sql.dataset.ResolutionException error code: BASE+2com.borland.dx.sql.dataset.ResolutionException: An error occurred deleting a row in the "heart_fieldinfo" table at com.borland.dx.sql.dataset.ResolutionException.a(Unknown Source) at com.borland.dx.sql.dataset.ResolutionException.a(Unknown Source) at com.borland.dx.sql.dataset.l.a(Unknown Source) at com.borland.dx.sql.dataset.QueryResolver.deleteRow(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.a(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.d(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.c(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source) at com.borland.dx.sql.dataset.Database.saveChanges(Unknown Source) at com.borland.dx.sql.dataset.QueryDataSet.saveChanges(Unknown Source) at com.borland.dx.dataset.DataSet.saveChanges(Unknown Source) at com.borland.dbswing.JdbNavToolBar.actionPerformed(JdbNavToolBar.java:1219) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1504) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:378) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:216) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:230) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:230) at java.awt.Component.processMouseEvent(Component.java:3717) at java.awt.Component.processEvent(Component.java:3546) at java.awt.Container.processEvent(Container.java:1164) at java.awt.Component.dispatchEventImpl(Component.java:2595) at java.awt.Container.dispatchEventImpl(Container.java:1213) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125) at java.awt.Container.dispatchEventImpl(Container.java:1200) at java.awt.Window.dispatchEventImpl(Window.java:912) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:319) at java.awt.EventDispatchThread.pumpOneEvent(EventDispatchThread.java:103) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:84)Chained exception:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Value can not be converted to requested type. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseData.getBigDecimal(Unknown Source) at com.microsoft.jdbc.base.BaseData.getBigDecimal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObject(Unknown Source) at com.borland.dx.sql.dataset.j.setParameter(Unknown Source) at com.borland.dx.sql.dataset.j.setWhereParameters(Unknown Source) at com.borland.dx.sql.dataset.t.a(Unknown Source) at com.borland.dx.sql.dataset.l.a(Unknown Source) at com.borland.dx.sql.dataset.QueryResolver.deleteRow(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.a(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.d(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.c(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source) at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source) at com.borland.dx.sql.dataset.Database.saveChanges(Unknown Source) at com.borland.dx.sql.dataset.QueryDataSet.saveChanges(Unknown Source) at com.borland.dx.dataset.DataSet.saveChanges(Unknown Source) at com.borland.dbswing.JdbNavToolBar.actionPerformed(JdbNavToolBar.java:1219) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1504) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:378) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:216) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:230) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:230) at java.awt.Component.processMouseEvent(Component.java:3717) at java.awt.Component.processEvent(Component.java:3546) at java.awt.Container.processEvent(Container.java:1164) at java.awt.Component.dispatchEventImpl(Component.java:2595) at java.awt.Container.dispatchEventImpl(Container.java:1213) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125) at java.awt.Container.dispatchEventImpl(Container.java:1200) at java.awt.Window.dispatchEventImpl(Window.java:912) at java.awt.Component.dispatchEvent(Component.java:2499) at java.awt.EventQueue.dispatchEvent(EventQueue.java:319) at java.awt.EventDispatchThread.pumpOneEvent(EventDispatchThread.java:103) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:84)
com.borland.dx.sql.dataset.ResolutionException: An error occurred deleting a row in the "heart_fieldinfo" table你的错误信息提示的是你在删除一行记录!!!不是Update或者Insert
我发现我的数据库连接,有时候会莫名其妙的断开,过一会儿又连上了。难道是jbuilder4本身的问题?
更奇怪的是我今天上午又作了几个试验,发现varchar有时候也可以更新了,但是有的时候却不能,我只是改变了sqlserver2000中的表结构(主要是数据类型),源代码没有变化。
你先用trim()方法去掉左右空格试试。
jdbtable中的varchar字段不能够删除,而且插入的时候不能插入字母,但是可以插入数字,否则就出错。而对于char就没有这些问题。请高手指点指点!