Informix Error -9250: Xadatasource type datasource_type_name already exists in database.

Reasons / Common Causes

-9250 fires when a CREATE XADATASOURCE TYPE statement names a type that already exists in the database — per the official guidance.

1. A CREATE XADATASOURCE TYPE statement reusing an existing type name, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Use a new, unused name for the xadatasource type, per the official guidance.

Examples

Recreating an existing xadatasource type

CREATE XADATASOURCE TYPE xads_t1 (...);   -- -9250 if xads_t1 already exists

Corrected

CREATE XADATASOURCE TYPE xads_t2 (...);

Diagnostic Checks

1. Check systabtypes/system catalog for the existing xadatasource type name, and choose an unused name.

Related Errors / Related Topics

• -9251 — "Xadatasource datasource_name already exists in database." The same class of duplicate-name error, for xadatasource instances rather than types.
• -9252 — "Xadatasource type datasource_type_name not found." The inverse case — dropping a type name that doesn't exist.

The named xadatasource type already exists — choose a new, unused name.