What are the challenges you face when working across database platforms? Take the survey

auto selected generators

rjschaverjschave Posts: 13
I have several integer fields in a table that contain the words Length or Width in the field name. the program correctly selects the SQL int data generator for the Length fields, but selects the Business ID generator for the width fields.

I'm not sure why the word 'width' in the field name triggers the Business ID generator instead of the SQL int generator. What criteria is used to determine when a business generator is used over a SQL datatype generator? Is this a settings that can be modified?


  • Options

    Thank you for your post. Within the config directory of the application we have defined all of the generators as XML and set various properties which are loaded when the application starts.

    For Business IDs (Ids.xml), we have a setting saying what to match the generator to. For this generator, it is:

    " <matches field="ID" score="5" /> "

    As width contains ID within the field name, the generator is automatically matching to the field name.

    You can modify this by removing the configuration, I'll investigate the matching more to see if it can be improved.


  • Options
    Interesting. Thanks for the tip. I suppose normally it wouldn't be a big deal, but this table has over 12 fields with the word 'width' in the name so changing the generator was getting monotonous.

    It sounds like your matching if the field name contains a value. Consider adding options for begins with and ends with.
Sign In or Register to comment.