You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by "Matt Hogstrom (JIRA)" <de...@geronimo.apache.org> on 2006/10/18 20:38:35 UTC
[jira] Closed: (DAYTRADER-11) AccountProfile field "password"
conflicts with DB2 v9.1 keyword
[ http://issues.apache.org/jira/browse/DAYTRADER-11?page=all ]
Matt Hogstrom closed DAYTRADER-11.
----------------------------------
Fix Version/s: 1.2
Resolution: Fixed
Applied to trunk as it changes schemas and is inappropriate for 1.x releases.
> AccountProfile field "password" conflicts with DB2 v9.1 keyword
> ---------------------------------------------------------------
>
> Key: DAYTRADER-11
> URL: http://issues.apache.org/jira/browse/DAYTRADER-11
> Project: DayTrader
> Issue Type: Improvement
> Components: EJB Tier
> Affects Versions: 1.2, 1.1, 1.1.1
> Environment: DB2 v9.1
> Reporter: Christopher James Blythe
> Priority: Minor
> Fix For: 1.2
>
> Attachments: daytrader-11.txt
>
>
> The DB2 v9.1 documentation now states that "password" is a reserved word that should not be used for table/column names, etc. In the AccountProfile ejb we use a "password" field that is mapped directly to a "password" column in the database.
> http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0001095.htm
> In order to prevent this keyword clash, I have modified the AccountProfile field from "password" to "passwd" and made the necessary changes in the ejb source, TradeDirect, sql schema, and plan files.
> The associated patch is attached...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira