Firebird/InterBase CMP type mappings

[kashpaw]

How come The cmp mapping of String for Interbase is varchar(64)? If I want to store a larger string I get a data truncation error. If I increase the size of the varchar in the mapping I get a different error from one of the firebird system tables, something about RDB$... or something. How do I store a String larger than 64?

And what about JAVA_OBJECT mapping to varchar(2000)? How come it isn't blob, which is supported in interbase?

Dain or David, can you tell me where to go? (Maybe to the interbase manuals... I've browsed them and discovered nothing pertinent....)

Thanks.
kashpaw

[kashpaw]

I realize I wasn't very clear in my previous posting. I changed the size of the String mapping in the standard conf file. Are these values in the standardcmp-jdbc.xml (or whatever that name of the file is that holds the default mappings)chosen for any particular reason? Are they odd? I know I can override them by specifying a mapping file in the META-INF of the jar. I guess I'll try that next.

[kashpaw]

Yeah, the override using jbosscmp-jdbc.xml worked just fine. I guess it didn't work in standard due to db pilot error, so never mind. Altho the defaults for VARCHAR and JAVA_OBJECT strike me as odd.