Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Data Type Configuration | The Database-Specific Data Type Mapping Files | extTypeMapping | Customize data type configuration
 
Customize data type configuration
To configure a custom data type in Adapter for JDBC, perform the following steps:
1. Create a directory with the name, custom in the Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\config directory.
2. Copy the database-specific data type mapping configuration file from the Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\config directory to the custom directory. For example, copy OracleTypeMapping.xml file from source location to target location.
3. Open the database-specific type mapping configuration file from the custom directory and modify it as required. For example, to configure the SDO_GEOMETRY data type in an Oracle database, open the OracleTypeMapping.xml file in custom directory, customize the file as per your specification, adhering to the TypeMapping.xsd schema located in the Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\config directory.
4. Save the file.
5. Restart the Integration Server.
Note:
If the modified file fails validation, Adapter for JDBC ignores the file and the adapter connections will work with the default configuration files.