Six Stars

Mapping file (.xml) in connection properties - parameters and content

Hi all,
there is a guide or some information about parameters/structure for db mapping file?
I refer to xml files used to translate dbtype <-> talend type (see in "metadata -> Connection" and create generic jdbc connection, or in "Preferences -> Talend -> Specific settings -> Metadata for talend").
After jdbc-odbc bridge was depreacated, I'm migrating Lotus notes ODBC to JDBC (domsql).
This strange jdbc is based on sqllite, but all columns retrieved are varchar 2000000000 long.
It's possible to set a fixed value like defaultLength?
I trie to use mapping_MSSQL.xml but column length remain 2000000000.
thanks
bye
1 REPLY
Community Manager

Re: Mapping file (.xml) in connection properties - parameters and content

Hi 
The mapping file is for specific database, it will not take effect if you create a general JDBC connection. You need to modify manually the data type and length after the schema is retrieved
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business