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
Environment: DB2 v9.1
Reporter: Christopher James Blythe
Priority: Minor
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
