Login

    Register

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.
Managed Hosting

PROJECT CATEGORIES

 

SQLiteCFC
Project Home Forums Known Issues Contact Project

SQLiteCFC Issue: Flex Object Remoting Fails

Name: Flex Object Remoting Fails
ID: 1
Project: SQLiteCFC
Type: Bug
Area: Front End
Severity: High
Status: Open
Related URL:
Creator: Samuel Dismond III
Created: 10/30/13 11:02 AM
Updated: 12/05/13 1:38 PM
Description: SETUP
Flex 4.6+
CF9,0,1,274733
MySQL 5.4+
Windows 7 professional
IIS7
Git

SCENARIO
I have a working very large three-tier application that I demo on my laptop. After discovering RAM constraints processing big files, I decided to temp save binaries mid-processing to SQLite (speed is not an issue). I implemented your CFC without problem. Testing on each component tier passes. However, Remoting from AIR to CF, the VO is received by the service, but the return silently fails.

Reverting to the Git branch before your code - the system works.

Implementing the driver by dropping it in the JVM classpath and configuring a pre-made datasource works (CFQUERY).

Not sure why your code fails. Possibly a quirk with CF and the javaloader that I do not have time to investigate further? For now sticking with the Xerial JAR in my class path and CFQuery.

Thanks for your work thus far!
History: Created by srd3 (Samuel Dismond III) : 10/30/13 11:02 AM

Comment by srd3 (Samuel Dismond III) : 10/31/13 8:38 AM
Howdy-

WORKAROUND
I am so curious, I can't leave quirky bugs unsolved. The problem I reported above appears to be quirky behavior with CF arrays that have been generated from cfquery (via cfloop). When the array is dupmped at the tier level there is no problem. However, when the array is sent appropriately wrapped in a VO in Flex remoting, silent failure without a trace (in any error logs).

Through _a lot_ of incremental trial and error, I discovered that using the duplicate() function on the array before sending over the wire inexplicably solves the problem.

Comment by shawn.grigson (Shawn Grigson) : 12/05/13 1:38 PM
Thanks for the feedback!

I plan to move this project to Github soon, so pull requests will make keeping things updated (and keeping the code updated on your end) a lot easier.

So was the problem primarily on your end (sending over the data) or on the side of SqliteCFC?

To add a comment to this bug, please login using the link above.

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.