geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christopher James Blythe (JIRA)" <...@geronimo.apache.org>
Subject [jira] Created: (DAYTRADER-11) AccountProfile field "password" conflicts with DB2 v9.1 keyword
Date Fri, 01 Sep 2006 15:10:22 GMT
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

        

Mime
View raw message