Solved

Signed Applet Problem

Posted on 2004-09-22
4
305 Views
Last Modified: 2008-02-01
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)
0
Comment
Question by:biggin777
4 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 250 total points
ID: 12127657
Try setting the row ids manually depending on the key columns
0
 
LVL 92

Assisted Solution

by:objects
objects earned 250 total points
ID: 12128902
> I use an ODBC connection to access the database

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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
xampp tool 12 56
hibernate jars 4 45
Which non-HTML GUI front end to use with Java? 3 24
Html Table Looping (part 2) 5 28
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This video teaches viewers about errors in exception handling.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question