Hi, i think the mapping in the jaws.xml file is not portable between different databases as it could be. In my case I am using Oracle and DB2/400. On Oracle the preferred Datatype is VARCHAR2 and in DB2/400 it is CHAR (sometimes VARCHAR). So I think it makes it easier to set the mapping between the jdbc type and the sql type in the mappings like it is. And in the <entity> section only the <jdbc-type> and the length is set. So you can change simple the mapping for example from Oracle to DB2/400 and it works. Now I can set the <jdbc-type> but without the length so I have to use the <sql-type>. Sorry about my bad english... CU --- Ingo Bruell OBL GmbH ([EMAIL PROTECTED]) Hude (Oldenburg) Germany
