Java开发网 - Re:关于java修改数据库地问题，大家帮忙啊！

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate

打印话题 寄给朋友 订阅主题

作者

关于java修改数据库地问题，大家帮忙啊！

zeus1220

发贴: 1
积分: 0

于 2007-03-28 17:04

请问各位前辈，我用JBuilder7编了一个JAVA程序，用DataBase建立数据库连接组件并有一QueryDataset建立的查询组件。然后我添加了一个jdbNavToolBar组件，设置dataSet参数为QueryDataset。运行程序可以显示查询的内容，但当我修改、添加等数据库操作时就抱错。请问是为什么？怎么解决呢？我用的是SQL2000数据库,登陆名是可以写数据库的.

出现如下消息框：
DataSet has no unique row identifiers. Note: For QueryDataSets you need to disable metaDataUpdate.ROWID in the MetaDataUpdate property, in addition to setting the RowId property on a column.

See com.borland.dx.dataset.DataSetException error code: BASE+37com.borland.dx.dataset.DataSetException: DataSet has no unique row identifiers. Note: For QueryDataSets you need to disable metaDataUpdate.ROWID in the MetaDataUpdate property, in addition to setting the RowId property on a column. at com.borland.dx.dataset.DataSetException.a(Unknown Source) at com.borland.dx.dataset.DataSetException.z(Unknown Source) at com.borland.dx.dataset.StorageDataSet.db(Unknown Source) at com.borland.dx.dataset.StorageDataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.startEditCheck(Unknown Source) at com.borland.dx.dataset.DataSet.startEdit(Unknown Source) at com.borland.dbswing.TableMaskCellEditor.textModified(TableMaskCellEditor.java:336) at com.borland.dbswing.TableMaskCellEditor.insertUpdate(TableMaskCellEditor.java:315) at javax.swing.text.AbstractDocument.fireInsertUpdate(AbstractDocument.java:180) at javax.swing.text.AbstractDocument.insertString(AbstractDocument.java:542) at com.borland.dbswing.DBPlainDocument.insertString(DBPlainDocument.java:77) at javax.swing.text.JTextComponent.replaceSelection(JTextComponent.java:844) at javax.swing.text.DefaultEditorKit$DefaultKeyTypedAction.actionPerformed(DefaultEditorKit.java:801) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1384) at javax.swing.JComponent.processKeyBinding(JComponent.java:2078) at javax.swing.JComponent.processKeyBindings(JComponent.java:2104) at javax.swing.JComponent.processKeyEvent(JComponent.java:2050) at com.borland.dbswing.TableMaskCellEditor.processKeyEvent(TableMaskCellEditor.java:623) at javax.swing.text.JTextComponent.replaceInputMethodText(JTextComponent.java:2793) at javax.swing.text.JTextComponent.processInputMethodEvent(JTextComponent.java:2654) at java.awt.Component.processEvent(Component.java:3558) at java.awt.Container.processEvent(Container.java:1164) at java.awt.Component.dispatchEventImpl(Component.java:2593) at java.awt.Container.dispatchEventImpl(Container.java:1213) at java.awt.Component.dispatchEvent(Component.java:2497) at java.awt.EventQueue.dispatchEvent(EventQueue.java:339) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)
还有那个ROWID是在哪里的啊？

作者	Re:关于java修改数据库地问题，大家帮忙啊！ [Re:zeus1220]
cxp108 发贴: 363 积分: 12	于 2007-03-29 18:12 你必须为QueryDataSets指明一个ID字段这个字段就是QueryDataSets所指向的表的unique字段或p_key

已读帖子

新的帖子

被删除的帖子