[ 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