• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: EOGeneralAdaptorException -- updateValuesInRowDescribedByQualifier
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: EOGeneralAdaptorException -- updateValuesInRowDescribedByQualifier


  • Subject: Re: EOGeneralAdaptorException -- updateValuesInRowDescribedByQualifier
  • From: Nathan Hampton <email@hidden>
  • Date: Thu, 31 Mar 2005 16:02:11 -0800

I'm having this problem with an application, but Art's suggestion doesn't solve the problem. The database information was imported from CSV files, but the WO app is the only thing accessing the database when this problem is occurring. I can't delete the rows -- I'd just have to import them again -- and the rows didn't exist before the "change" (import). I had thought that it might be an encoding problem (the imported information being UTF-8 and the app using Mac Roman, or something like that), but it happens even with records that have been entered through the WO application. My boss discovered this morning that everything works properly for records where the PK is less than 100, but it always produces an error for PKs greater than 200 (we haven't been able to check any in the 100-200 range). Potentially useful information is below, and any ideas would be very much appreciated.

Thanks!

--NCH

On 17 Sep 2003, at 7:18 PM, Jonathan Fleming wrote:

I used to wonder I how I got this error but now I've found that it happens when I've altered a value directly in a db column (it happens on OpenBase and MSSQLServer2000), however, if I return the value back to how it was before the application runs fine again or alternativley if i delete that row everything will be OK.
What I'd like to know is how do you get out of this error from within the application or your code? Basically if something happens in production where you may need to enter data directly into the database how can you be sure this error isn't going to present itself when that particular user logs in and commits a change to the affected db row?


Regards
Jonathan 8^)

:::Potentially Useful Information:::

WO: 5.2.3
OS: Panther/Panther Server (tried on both)
DB: MySQL (whatever version ships with the above)

Stack Trace:

[2005-03-31 14:48:23 PST] <WorkerThread2> com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier -- com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database
at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextI nformationAdded(EODatabaseContext.java:4676)
at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseConte xt.java:6384)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingCo ntext(EOObjectStoreCoordinator.java:415)
at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.j ava:3165)
at JobFollowUp.save(JobFollowUp.java:277)


EODatabaseOperation:
{
_dbSnapshot =
{
assignDate = 2005-01-29 08:00:00 Etc/GMT;
caseWorkerID = 77;
clientID = 242;
closeDate = 2005-02-03 08:00:00 Etc/GMT;
costOfMaterials = NULL;
followUpDate1 = NULL;
followUpDate2 = NULL;
followUpNotes = NULL;
followUpResult1ID = 0;
followUpResult2ID = NULL;
hourlyRate = NULL;
hoursWorked = NULL;
jobDescription = "Two grab bars in tub area (client will show if not marked).";
jobID = 257;
jobPK = 257;
notes = "";
orderDate = 2005-01-21 08:00:00 Etc/GMT;
private_status = 0;
workTypeID = 4;
workerComments = "Client's husband showed placement.";
workerID = 6;
};
_entity = "Job";
_newRow =
{
assignDate = 2005-01-29 08:00:00 Etc/GMT;
caseWorkerID = 77;
clientID = 242;
closeDate = 2005-02-03 08:00:00 Etc/GMT;
costOfMaterials = NULL;
followUpDate1 = 2005-03-31 22:48:22 Etc/GMT;
followUpDate2 = NULL;
followUpNotes = NULL;
followUpResult1ID = 1;
followUpResult2ID = NULL;
hourlyRate = NULL;
hoursWorked = NULL;
jobDescription = "Two grab bars in tub area (client will show if not marked).";
jobID = 257;
jobPK = 257;
notes = "";
orderDate = 2005-01-21 08:00:00 Etc/GMT;
private_status = -2;
workTypeID = 4;
workerComments = "Client's husband showed placement.";
workerID = 6;
};
_object = "
{
values =
{
notes = "";
followUpResult1ID = 0;
followUpResult2ID = NULL;
closeDate = 2005-02-03 08:00:00 Etc/GMT;
costOfMaterials = NULL;
client = "<HSClient 147864 _EOIntegralKeyGlobalID[Client (java.lang.Integer)242]>";
caseWorker = "<HSCaseWorker 248adb _EOIntegralKeyGlobalID[CaseWorker (java.lang.Integer)77]>";
workerComments = "Client's husband showed placement.";
jobID = 257;
assignedTo = "<HSWorker 7f61bb _EOIntegralKeyGlobalID[Worker (java.lang.Integer)6]>";
hoursWorked = NULL;
followUpResult1 = "<HSCallbackResult 20ab60 _EOIntegralKeyGlobalID[CallbackResult (java.lang.Integer)1]>";
followUpResult2 = "null";
workType = "<NCHAttribute 43b93b _EOIntegralKeyGlobalID[NCHAttribute (java.lang.Integer)4]>";
private_status = NULL;
hourlyRate = NULL;
followUpNotes = NULL;
orderDate = 2005-01-21 08:00:00 Etc/GMT;
followUpDate1 = 2005-03-31 22:48:22 Etc/GMT;
followUpDate2 = NULL;
assignDate = 2005-01-29 08:00:00 Etc/GMT;
jobDescription = "Two grab bars in tub area (client will show if not marked).";
};
this = "<HSJob bbddbf _EOIntegralKeyGlobalID[Job (java.lang.Integer)257]>";
}";
_adaptorOps = (
{
_qualifier = "
(
(jobPK = 257)
(jobID = 257)
(workTypeID = 4)
(orderDate = (com.webobjects.foundation.NSTimestamp)'2005-01-21 08:00:00 Etc/GMT')
(closeDate = (com.webobjects.foundation.NSTimestamp)'2005-02-03 08:00:00 Etc/GMT')
(jobDescription = 'Two grab bars in tub area (client will show if not marked).')
(notes = '')
(caseWorkerID = 77)
(followUpDate1 = null)
(followUpDate2 = null)
(workerID = 6)
(assignDate = (com.webobjects.foundation.NSTimestamp)'2005-01-29 08:00:00 Etc/GMT')
(clientID = 242)
(followUpNotes = null)
(hoursWorked = null)
(hourlyRate = null)
(costOfMaterials = null)
(workerComments = 'Client's husband showed placement.')
)";
_adaptorOperator = "EOAdaptorUpdateOperator";
_entity = "Job";
_exception = com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier -- com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database;
_changedValues =
{
followUpResult1ID = 1;
private_status = -2;
followUpDate1 = 2005-03-31 22:48:22 Etc/GMT;
};
});
_globalID = _EOIntegralKeyGlobalID[Job (java.lang.Integer)257];
_databaseOperator = "EODatabaseUpdateOperator";
}


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


  • Prev by Date: RE: java 1.4.2_07 NSMacOSRomanStringEncoding Exception
  • Next by Date: How to maintain session through a DirectAction call
  • Previous by thread: Re: bold print showing as regular in deployment
  • Next by thread: How to maintain session through a DirectAction call
  • Index(es):
    • Date
    • Thread