Solved

Signed Applet Problem

Posted on 2004-09-22
4
301 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…

815 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now