Signed Applet Problem

I'm using a signed applet to access a database on SQL Server2000.  I can get read access to the DB but when I try to write to the jdbTable I(JBuilder).  I get the following error.   I use an ODBC connection to access the database.  I have also changed the ROWID and MetaDataUpdate properties as it said in the note below.  I have the primary key set to column 1 "ID" and it's ROWID to true and the rest of the columns to false.


See com.borland.dx.dataset.DataSetException error code:  BASE+37
com.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.DBTextDataBinder.textModified(DBTextDataBinder.java:1576)
      at com.borland.dbswing.DBTextDataBinder.insertUpdate(DBTextDataBinder.java:1560)
      at javax.swing.text.AbstractDocument.fireInsertUpdate(Unknown Source)
      at javax.swing.text.AbstractDocument.handleInsertString(Unknown Source)
      at javax.swing.text.AbstractDocument.insertString(Unknown Source)
      at javax.swing.text.PlainDocument.insertString(Unknown Source)
      at com.borland.dbswing.DBPlainDocument.insertString(DBPlainDocument.java:77)
      at javax.swing.text.AbstractDocument.replace(Unknown Source)
      at javax.swing.text.JTextComponent.replaceSelection(Unknown Source)
      at javax.swing.text.DefaultEditorKit$DefaultKeyTypedAction.actionPerformed(Unknown Source)
      at javax.swing.SwingUtilities.notifyAction(Unknown Source)
      at javax.swing.JComponent.processKeyBinding(Unknown Source)
      at javax.swing.JComponent.processKeyBindings(Unknown Source)
      at javax.swing.JComponent.processKeyEvent(Unknown Source)
      at java.awt.Component.processEvent(Unknown Source)
      at java.awt.Container.processEvent(Unknown Source)
      at java.awt.Component.dispatchEventImpl(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source)
      at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(Unknown Source)
      at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(Unknown Source)
      at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source)
      at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source)
      at java.awt.Component.dispatchEventImpl(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.run(Unknown Source)
biggin777Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
CEHJCommented:
Try setting the row ids manually depending on the key columns
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
objectsCommented:
> I use an ODBC connection to access the database

I'd suggest changing your driver, there's a free one available from M$.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.