[#SDK-14661] FDS \ LCDS - FDS Dataservices fails to update or commit changes - (mySQL db vs sample db)

Flex SDK

FDS \ LCDS - FDS Dataservices fails to update or commit changes - (mySQL db vs sample db)

Created: 02/15/08 12:27 PM Updated: 03/12/08 03:20 PM

Component/s:

mx: Application, mx: General, Data Binding, Data Manager, Data Model, Events, Flash Integration, MXML Components, MXML Scripting, RPC: General, RPC: HTTPService, RPC: RemoteObject

Security Level:

Public (All JIRA Users )

File Attachments:

READ ME FIRST.txt (2 kb)
2.

src.zip (532 kb)

Severity:	Non Functioning
Reproducibility:	Every Time
Discoverability:	High
Found in Version:	SDK Moxie RC4
Affected OS(s):	Windows - XP
Steps to Reproduce:	« Hide --- > In version RC 6 -- Steps to reproduce: 1. Create a LCDS project with CF 8 as server tech, select a mysql data source, build a simple test app 2. Make a change to the data. Test Project Notes: The project folder contains several examples to demonstrate the issues: Assumptions: Coldfusion8 with LCDS installed on localhost IIS 7 as web server C:\inetpub\wwwroot Standard exmaple db from CF install --- cfartgalery CF mapping to apps C:\inetpub\wwwroot\apps Examples: miniMedia.mxml -- working example of simple dataservice usage -- Changes to collection appear to work as expected. Test control. companiesDem.mxml -- Identical to working test, except change of datasource to more complex table with mySql backend. -- Data loads, but application fails with errors when data is updated. ds.commit "update" Error: Unknown Property: 'constructor'. at mx.collections::ListCollectionView/http://www.adobe.com/2006/actionscript/flash/proxy::getProperty()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\collections\ListCollectionView.as:692] at mx.data::Conflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\Conflict.as:82] at mx.data::DataStore/http://www.adobe.com/2006/flex/mx/internal::processConflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\DataStore.as:2292] at mx.data::CommitResponder/result()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\CommitResponder.as:363] at mx.rpc::AsyncRequest/acknowledge()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AsyncRequest.as:74] at NetConnectionMessageResponder/resultHandler()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\messaging\channels\NetConnectionChannel.as:469] at mx.messaging::MessageResponder/result()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\messaging\MessageResponder.as:199] contactmgr.mxml - more complex app using different table in mysql db - Changes to array collection can be viewed, but same Error: Unknown Property: 'constructor' appears when update is clicked. Actual Results: Application crashes when data commit "update" is called. Error: Unknown Property: 'constructor'. at mx.collections::ListCollectionView/http://www.adobe.com/2006/actionscript/flash/proxy::getProperty()[E:\dev\flex\sdk\frameworks\projects\framework\src\mx\collections\ListCollectionView.as:690] at mx.data::Conflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\Conflict.as:82] at mx.data::DataStore/http://www.adobe.com/2006/flex/mx/internal::processConflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\DataStore.as:2292] at mx.data::CommitResponder/result()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\CommitResponder.as:363] at mx.rpc::AsyncRequest/acknowledge()[E:\dev\flex\sdk\frameworks\projects\rpc\src\mx\rpc\AsyncRequest.as:81] at NetConnectionMessageResponder/resultHandler()[E:\dev\flex\sdk\frameworks\projects\rpc\src\mx\messaging\channels\NetConnectionChannel.as:477] at mx.messaging::MessageResponder/result()[E:\dev\flex\sdk\frameworks\projects\rpc\src\mx\messaging\MessageResponder.as:206] Expected Results: Should work! Workaround (if any): None -- Critical show stopper! Show » --- > In version RC 6 -- Steps to reproduce: 1. Create a LCDS project with CF 8 as server tech, select a mysql data source, build a simple test app 2. Make a change to the data. Test Project Notes: The project folder contains several examples to demonstrate the issues: Assumptions: Coldfusion8 with LCDS installed on localhost IIS 7 as web server C:\inetpub\wwwroot Standard exmaple db from CF install --- cfartgalery CF mapping to apps C:\inetpub\wwwroot\apps Examples: miniMedia.mxml -- working example of simple dataservice usage -- Changes to collection appear to work as expected. Test control. companiesDem.mxml -- Identical to working test, except change of datasource to more complex table with mySql backend. -- Data loads, but application fails with errors when data is updated. ds.commit "update" Error: Unknown Property: 'constructor'. at mx.collections::ListCollectionView/http://www.adobe.com/2006/actionscript/flash/proxy::getProperty()[E:\dev\3.0.x\frameworks\projects\framework\src\mx\collections\ListCollectionView.as:692] at mx.data::Conflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\Conflict.as:82] at mx.data::DataStore/http://www.adobe.com/2006/flex/mx/internal::processConflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\DataStore.as:2292] at mx.data::CommitResponder/result()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\CommitResponder.as:363] at mx.rpc::AsyncRequest/acknowledge()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\rpc\AsyncRequest.as:74] at NetConnectionMessageResponder/resultHandler()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\messaging\channels\NetConnectionChannel.as:469] at mx.messaging::MessageResponder/result()[E:\dev\3.0.x\frameworks\projects\rpc\src\mx\messaging\MessageResponder.as:199] contactmgr.mxml - more complex app using different table in mysql db - Changes to array collection can be viewed, but same Error: Unknown Property: 'constructor' appears when update is clicked. Actual Results: Application crashes when data commit "update" is called. Error: Unknown Property: 'constructor'. at mx.collections::ListCollectionView/http://www.adobe.com/2006/actionscript/flash/proxy::getProperty()[E:\dev\flex\sdk\frameworks\projects\framework\src\mx\collections\ListCollectionView.as:690] at mx.data::Conflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\Conflict.as:82] at mx.data::DataStore/http://www.adobe.com/2006/flex/mx/internal::processConflict()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\DataStore.as:2292] at mx.data::CommitResponder/result()[C:\depot\flex\branches\enterprise_bridgeman\frameworks\mx\data\CommitResponder.as:363] at mx.rpc::AsyncRequest/acknowledge()[E:\dev\flex\sdk\frameworks\projects\rpc\src\mx\rpc\AsyncRequest.as:81] at NetConnectionMessageResponder/resultHandler()[E:\dev\flex\sdk\frameworks\projects\rpc\src\mx\messaging\channels\NetConnectionChannel.as:477] at mx.messaging::MessageResponder/result()[E:\dev\flex\sdk\frameworks\projects\rpc\src\mx\messaging\MessageResponder.as:206] Expected Results: Should work! Workaround (if any): None -- Critical show stopper!
Language Found:	English
Bugbase Id:	none
QA Owner:	Joann Chuang Anderson
Resolved by:	David O'Leary
Participants:	Dan Zeitman, David O'Leary, Joann Chuang Anderson, Lauren Park, Trevor Baker and wichan
Browser:	Internet Explorer 6.x

All

Comments

Sort Order:

[ Permlink | « Hide ]

Dan Zeitman - [02/15/08 12:29 PM ]

-- See the SQL and Flex Config folders for config file source and mySQL database.script
Do feel free to contact me directly: Dan@dvpweb.com if require setup instructions

[ Permlink | « Hide ]

Lauren Park - [02/15/08 03:01 PM ]

re-assigned to David who is investigating this

[ Permlink | « Hide ]

David O'Leary - [02/15/08 03:43 PM ]

emailed customer for CF log files

[ Permlink | « Hide ]

wichan - [02/15/08 05:05 PM - edited ]

[ Permlink | « Hide ]

Trevor Baker - [02/15/08 06:12 PM - edited ]

This is using the flex2 HF3 and lcds 2.5.1 in CF8. While it is reproducible, it has nothing to do with Moxie SDK3/FB3 or BlazeDS.

[ Permlink | « Hide ]

Dan Zeitman - [02/16/08 12:00 PM ]

Trevor - Project was last tested with FB 3 RC6. Not working, Not clear what you mean by flex2 HF3.

The project references the swc's shipped with CF8, when yo urun that new project wizard, but should have been pointing to Flex Moxie, not Flex 2.01 -- I may have changed the reference in my frustration to try to get it to work.

Suggestions?

[ Permlink | « Hide ]

Dan Zeitman - [02/16/08 12:06 PM ]

>>> Wichan wrote :::: And later deleted this comment -- Not sure why????
Author: wichan
Date: 02/15/08 05:05 PM
Comment:
Since it was data conflict with the server version, we removed the properties comparsion and found that the problem was caused by tiny_int type. After I remove the followings where causes, it worked

These were what I removed from the CompanysDAO.cfc
and KEYACCOUNT = <cfqueryparam value="#arguments.oldBean.getKEYACCOUNT()#" cfsqltype="CF_SQL_TINYINT" />
and ACTIVEACCOUNT = <cfqueryparam value="#arguments.oldBean.getACTIVEACCOUNT()#" cfsqltype="CF_SQL_TINYINT" />

MySQL Boolean is a tiny_int type. --- One would assume that the CF wizard would take such data types that into account if one changes the field from textinput to checkbox ?

Any thoughts....

[ Permlink | « Hide ]

David O'Leary - [03/03/08 09:42 AM ]

Logged ColdFusion bug 71395 for this as it has nothing to do with Moxie SDK3/FB3 or BlazeDS. Also logged 71350, ENH 71349 and 71348 against the cfeclipse wizard.

[ Permlink | « Hide ]

Dan Zeitman - [03/03/08 11:12 AM ]

--- Code is ultimately generated in Flexbuilder.
SQL tiny int isn't being addressed, similar issue with mySQL - LONGTEXT

Who really owns this issue... It looks like all three teams need to address mySQL integration.

[ Permlink | « Hide ]

Joann Chuang Anderson - [03/04/08 04:47 PM ]

Assigning to David, since I was not involved in the investigation/resolution.

[ Permlink | « Hide ]

David O'Leary - [03/11/08 12:10 PM ]

This is not a SDK issue. The underlying cause is the CFML code connecting to MySQL. Ultimately this will have to be investigated and resolved by the Coldfusion Engineering Team.

[ Permlink | « Hide ]

Dan Zeitman - [03/12/08 03:20 PM ]

David -

Please update this bug entry to include the re-assigned CF bug# so all interested can follow it's progress.

Dan