Hello all, i have a few questions concerning the creation of database schemas (btw we're using Oracle, but this should not
1. Internal Tables for OJB I find no file repository_internal.xml which has length enties 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 creates only VARCHAR2 fields of lenght 50, no matter which length is specified in the repository.xml. Most JDBC types are mapped to VARCHAR2 an not to their corresponding Oracle types. Can i configure this target (crossdb) to use correct length ans data types? 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 and generates a CREATE TABLE script from 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]>
