We've got an entity field name in our project that is longer than the 30 character limit for Oracle. When a query is run with this entity, the generated query string includes aliases for each column in the table. The problem we are running into is that the alias being generated for the column behind this field is identical to the entity field name on the code side, so the alias violates the 30 character limit for Oracle identifiers.

Any ideas on how to get around this?

This is fixed in 1.0.2005.1 version

Are you using an older version? If so, I'd recommend you migrate to 1.0.2005.1, with almost no pain, rather than openning your LLBLGen Pro project again and regenerate.

Hmmmm, we've upgraded to 1.0.2005.1 already, and are using it now. That's the version this is ocurring under.

To give some background - this project was originally created under SQL Server and we're now in the process of migrating our application to an Oracle backend. It was using 1.0.2005.1 when we originally ran it under SQL server as well.

We've run a full (non-safe) regeneration since switching to the Oracle backend, so we assumed any old SQL server related code should be gone.

The problem query is below, the "CatalogItemShipingChargeIsPerItem" alias is the one giving us fits. It perfectly matches the name of that column as we mapped it in the designer.

Query: SELECT "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CTLG_PRICE_ITEM_ROW_ID" AS "Id", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CATALOG_PRICE_ITEM_ID" AS "EffId", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CATALOG_ITEM_ROW_ID" AS "CatalogItemRowId", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."MODIFIED_BY_ID" AS "ModifiedById", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CATALOG_PRICE_NAME" AS "CatalogPriceName", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CATALOG_PRICE" AS "CatalogPrice", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CATALOG_ITEM_SHIPPING_CHARGES" AS "CatalogItemShippingCharges", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CTLG_ITEM_SHPNG_CHRGE_PER_ITEM" AS "CatalogItemShipingChargeIsPerItem", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."LIST_PRICE" AS "ListPrice", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."IS_TAXABLE" AS "IsTaxable", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CREATED_DATE" AS "CreatedDate", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."MODIFIED_DATE" AS "ModifiedDate", "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."EFF_DATE" AS "EffDate" FROM (( "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"  INNER JOIN "OMWB_LOGIN1"."V_CM_CATALOG_ITEM_PRICE_BYID"  ON  "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CTLG_PRICE_ITEM_ROW_ID"= "OMWB_LOGIN1"."V_CM_CATALOG_ITEM_PRICE_BYID"."CTLG_PRICE_ITEM_ROW_ID") INNER JOIN "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM"  ON  "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM"."CATALOG_ITEM_ROW_ID"= "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM_PRICE"."CATALOG_ITEM_ROW_ID") WHERE ( ( "OMWB_LOGIN1"."TBL_CM_CTLG_ITEM"."CATALOG_ITEM_ID" = :EffId1))

            Parameter: :EffId1 : Binary. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: binary lob.

Oh you mean column alias, I thought you were talking about a table alias, which could get too long before, that one is fixed indeed. this one isn't. If you run into this issue, please rename the field in the designer so it's shorter.