Hi,
I mentioned this table name too long for oracle thing in a previous post as
well.
Another thing I don't understand is the need for xml document to map
java types to sql column types for specific DBs. DatabaseMetaData and
ResultSetMeta data
gives the types when looking at an existing DB and java.sql.Types gives you
the
standard type mapping from java to sql. It is the drivers responsibility to
make the mapping
to the database specific column names if they are not ANSI SQL. A good example
for Oracle is that if you specify thru JDBC to create a VARCHAR column the
driver
makes this VARCHAR2(oracle specific) in the database.
To be fair, there are some things that can't be done cross platform and these
specific
things need to be kept somewhere.
Jonas' http://www.bullsoft.com/ejb does CMP without these type mapping files.
Eric
Montebove Luciano wrote:
> Found the bug that prevent news-app from working with Oracle.
> When Orion encounter a disallowed-field in a CMP Entity Bean like date for
> Oracle (oracle.xml) change the name of the table field to _name (i.e.:
> _date) but in Oracle (my version is 8.0.5) _ generate this error:
>
> Database error: ORA-00911: invalid character
>
> I solved modifying manually orion-ejb-jar.xml but this is not a comfortable
> solution.
> Couldn't you add a tag in the the database-schemas xmls to personalize the
> change of field names?
> A similar problem is for table names that with long package names create
> table names too long for Oracle.
>
> Best Regards
>
> Luciano Montebove
> Finsiel
> [EMAIL PROTECTED]
