Apple

2007/4/19, Cheong Hee (Datasonic) <email@hidden>:

I have an application that is using this fetch defined in "getAllObjects":

     ....



     .....etc

Everything "seems" working, however when fetch this particular table, this message has thrown out :: It was complaining the class cast exception that instead of ProjectExecutionTemplate, WO looks that the objects fetched are of ProjectActorRoleTemplate class!! The SQL trace shows correctly that all 12 rows are fetched.

=== trace 1 === error

[2007-04-19 16:00:17 SGT] <WorkerThread0> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT DISTINCT t0.ABBREVIATION_NAME, t0.CODE, t0.IS_ACTIVE, t0.IS_DEFAULT, t0.SEQUENCE_NUMBER, t0.TEMPLATE_KEY, t0.VDESCRIPTION, t0.VNAME FROM PROJECT_EXECUTION_TEMPLATE t0 WHERE UPPER(t0.VNAME) LIKE UPPER(?) ESCAPE '|'" withBindings: 1:"%"(vName)>
[2007-04-19 16:00:17 SGT] <WorkerThread0> 12 row(s) processed
[2007-04-19 16:00:17 SGT] <WorkerThread0> === Commit Internal Transaction
java.lang.ClassCastException: com.rhino.model.ProjectActorRoleTemplate
at com.rhino.model.ProjectExecutionTemplate.getAllObjects(ProjectExecutionTemplate.java:206)

whitch row is 206?
one of these?
EOFetchSpecification fs = new EOFetchSpecification("ProjectExecutionTemplate", nameQualifier, null, true, true, sortOrdering);
NSArray foundList = context.objectsWithFetchSpecification(fs);

at ProjectExecutionPage.initializeDisplayGroup(ProjectExecutionPage.java:110)

So, spent some time on error searching... and finally reach a point that if I changed the primary key in ProjectExecutionTemplate database, e.g.:

(NULL,NULL,1,NULL,NULL,1000007,NULL,'Design/Development'), ==> changed to

(NULL,NULL,1,NULL,NULL,10007,NULL,'Design/Development'), ==> Note that "1000007" to "10007"

When run the app again, everything worked! See below:

==== trace 2 ==== good one

[2007-04-19 16:03:45 SGT] <WorkerThread1> evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT DISTINCT t0.ABBREVIATION_NAME, t0.CODE, t0.IS_ACTIVE, t0.IS_DEFAULT, t0.SEQUENCE_NUMBER, t0.TEMPLATE_KEY, t0.VDESCRIPTION, t0.VNAME FROM PROJECT_EXECUTION_TEMPLATE t0 WHERE UPPER(t0.VNAME) LIKE UPPER(?) ESCAPE '|'" withBindings: 1:"%"(vName)>
[2007-04-19 16:03:45 SGT] <WorkerThread1> 12 row(s) processed
[2007-04-19 16:03:45 SGT] <WorkerThread1> === Commit Internal Transaction

So what my question is: what has gone wrong actually?

Primary key overflow?

Faults in MYSQL or WO or "programmer"? (primary key is defined as int(11) in MYSQL)

How could Class Cast Exception happen in the first place? (though both subclass from Template..)

Puzzled....Appreciate comments. [WO5.2.4/MYSQL v 5.0.22]

Cheers

Cheong Hee

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

This email sent to email@hidden

References:
	>Fetch objects: Error in MYSQL or WO (From: "Cheong Hee (Datasonic)" <email@hidden>)
	>Re: Fetch objects: Error in MYSQL or WO (From: "Daniele Corti" <email@hidden>)
	>Re: Fetch objects: Error in MYSQL or WO (From: "Cheong Hee (Datasonic)" <email@hidden>)