Hello again, the original message gave me the 'mailing list error' discussed last week, maybe it didn't find its way. So I give it a second try and would be glad if someone could drop me a couple of lines (although this post is quite long). Thanks.
Max -----Urspr�ngliche Nachricht----- Von: Geigl Maximilian, R235 Gesendet: Freitag, 4. Oktober 2002 10:04 An: [EMAIL PROTECTED] Betreff: [MAPPING] on mapping jdbc to dbms types Hello all, i have a few questions concerning the creation of database schemas (btw we're using Oracle, but this should not be of special importance here) 1. Internal Tables for OJB I find no file repository_internal.xml which has length entries for VARCHAR fields. I use the length from the HSQL OJB.script file now. Are these the correct length values and where do they come from (I guess not from an repository_internal.xml)? 2. Forward engineering tool (forward-db target in build.xml) I tried the forward-db target for my db schema against an Oracle instance, but it tries to create only VARCHAR2 fields of lenght 50, no matter which length is specified in the repository.xml. Most JDBC types are mapped to VARCHAR2 and not to their corresponding Oracle types. Can i configure this target (crossdb) to use correct length? 3. Repository verifier I tried the repository verifier against my Oracle database but it keeps giving me errors of the following form: --> DB Mapping Error: The column 'xxx' is of type 'NUMBER' and cannot be mapped to the jdbc type 'BIGINT'. --> DB Mapping Error: The column 'xxx' is of type 'DATE' and cannot be mapped to the jdbc type 'DATE'. --> DB Mapping Error: The column 'xxx' is of type 'NUMBER' and cannot be mapped to the jdbc type 'INTEGER'. However, my application seems to work correctly. How does the verifier work, where are the type mappings configured, is this mapping adjustable. Generally I'm looking for a convenient way to create DDL scripts from the repository file and to check an existing db schema against a repository specification (for now I wrote a (very) simple XSLT script that takes a repository file(s) and generates a CREATE TABLE script of it, using a table that specifies the mapping between jdbc and dbms types). Thanks for any suggestions. Max -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
