[ http://jira.jboss.com/jira/browse/JBAS-841?page=history ]
Scott M Stark reassigned JBAS-841:
----------------------------------
Assign To: (was: Scott M Stark)
> SQLUtil.fixConstraintName broken
> --------------------------------
>
> Key: JBAS-841
> URL: http://jira.jboss.com/jira/browse/JBAS-841
> Project: JBoss Application Server
> Type: Bug
> Components: CMP service
> Reporter: SourceForge User
>
>
> SourceForge Submitter: pilhuhn .
> SQLUtil.fixConstraintName() uses the max table name
> length to get the maximum length of a PK_constraint.
> Unfortunately, there are databases, that have different
> lenght for different things.
> E.g.
> The limit for table names in DB2 for Windows, OS/2 and
> Unix was lifted to 128 in
> v6. Column names can be 30 bytes long. Primary keys are
> still limited to
> 18
> So fcName() would check for 128 bytes, even if a column
> can only be 30 chars in length.
> Even worse: pks can only be 18 chars in length...
> Possible solution:
> Add even more entries to standardjbosscmp-jdbc.xml that
> override the settings obtained from
> DatabaseMetaData.getColumnNameLength().
> This would be three optional elements
> -table-name-length
> -column-name-length
> -primarykey-name-length
> Are there other databases out, that are so broken?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
