Configure Return Type with MySQL 5/CF 9 Driving Me Crazy

[nlk10010]

To make it simple, I have FB 4.01 running on Windows 7. I am also running MySQL 5.1.36 and the CF 9 internal server.

I create a test project and then try to create a Data Service for one of the MySQL tables (call it TTFBH00). I use the Wizard and let it create the CFC by introspecting the table and data types. The service is created with a return type of Ttfbh00[] and most of the data types are correct. No problem there.

I THEN want to use Configure Return Type to create a new Data Type (call it LoadLine[]). I invoke "Configure Return Type" on the getallttfbh00 operation and let it use sample data. The problem is when the list of data is displayed most of the data types are WRONG (i.e. different from the ones returned when I initially created the service). For example, many numeric fields are typed as Strings and of course I can't edit the types. I've tried using Configure Return Type on a different operation (e.g. getttfbh00) and I get the exact same list of erroneous field/type pairings as I did with getallttfbh00. The first record in the table (i.e. with lowest primary key) has actual data in the fields, as does the sample record when I use getttfbh00.

Right now I'm reduced to setting the incorrect fields to NULL in the table just so I can edit the types but I have no idea why the two operations (initial creation of service and "Configure Return Type") return different types for the same fields (much less why they are simply wrong in the second case).

I've searched "Configure Return Type error" and similar but really haven't come up with anything addressing this issue (although my search did remind me I could use the "set fields to NULL" trick as a torturous workaround).

Thanks for any info.

[Guest]

What is the type of the column/property that is converted to String? You may be facing this issue https://bugs.adobe.com/jira/browse/FB-27678

-Radhakrishna

[nlk10010]

Radhakrishna:

Actually, I believe that bug report was filed as a result of the posting of a thread in which I participated.

The issue here, I think, is a bit different: MySQL as opposed to SQL server, I get INT and TinyINT fields (as well as DECIMALS) returned as strings. While the introspection is correct when the service is created, the anomaly appears even when using "Configure Return Type" on a get method (in addition to, of course the getall method).

Of course these could be related or even be the "same" bug, I don't know. BTW, has the referenced bug been addressed yet?

Thanks.