In the future please post bugs like this to the jboss-dev list (which I
added to this email).
The JBossCMP does was not written to support the schema.table syntax.
Now it may work but I definitely was not thinking about this when I
wrote the sql generators. Support for the schema will be added when
feature "[545051] Add optional <schema> tag" is implemented.
Until then you can hack this file or not use the schema.table syntax.
-dain
Darryl Thompson wrote:
> Hello,
> I have found a bug the JBoss 3.0.0. production
> release that is in the following module: SQLUtil
>
> There is code that gets the sql "max table name" size
> as follows:
>
> public static String fixTableName(String
> tableName, DataSource dataSource)
> throws DeploymentException {
>
> Connection con = null;
> try {
> con = dataSource.getConnection();
> DatabaseMetaData dmd = con.getMetaData();
>
> // fix length
> int maxLength = dmd.getMaxTableNameLength();
> if(maxLength > 0 && tableName.length() >
> maxLength) {
> ...
> }
> In the case of Oracle 8i if the table name is
> greater than 30 your code perform some sort or
> truncation resulting in a different table name than
> what appears in the jbosscmp-jdbc.xml file.
>
> The problem is you are not considering a case where
> the SCHEMA name is prepended to the ACTUAL table name
> causing a greater size than what the table name is
> (e.g., ORDER_PRODUCT_USAGEPLAN is less than 30,
> versus COEADMIN.ORDER_PRODUCT_USAGEPLAN == 32). I have
> a short-term workaround but I am hoping you guys will
> check for schema name being attached to the table name
> (does table have a "." in it and if so trunc from 0
> up to and including the ".", then get table name
> length) and make the appropriate calculation minus the
> schema name.
> i think this is a big issue because lots of big
> shops use the schema name when referencing tables.
>
> Regards,
> Darryl Thompson
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -
http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
