Re: EOGeneralAdaptorException -- updateValuesInRowDescribedByQualifier
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