How to fix the Oracle error JMS-00224: Typemap is invalid – must be populated with SQLType/OraDataFactory mappings to receive messages from Sys.AnyData destinations?

In this post, you’ll learn more about the Oracle ErrorJMS-00224: Typemap is invalid – must be populated with SQLType/OraDataFactory mappings to receive messages from Sys.AnyData destinations with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

JMS-00224: Typemap is invalid – must be populated with SQLType/OraDataFactory mappings to receive messages from Sys.AnyData destinations

Reason for the Error JMS-00224: Typemap is invalid – must be populated with SQLType/OraDataFactory mappings to receive messages from Sys.AnyData destinations

Cause: The typemap of the session is null or empty. For destinations of tpye Sys.AnyData, the typemap must contain OraDataFactory objects for all possible types that may be stored in the queue/topic

How to fix the Error JMS-00224: Typemap is invalid – must be populated with SQLType/OraDataFactory mappings to receive messages from Sys.AnyData destinations ?

You can fix this error in Oracle by following the below steps

Action: Use the AQjmsSession.getTypeMap() method get the typemap. Then use the put() method to register SQLType names and their corresponding OraDataFactory objects