You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacopo Cappellato (JIRA)" <ji...@ofbiz.org> on 2006/09/13 06:57:16 UTC

[JIRA] Closed: (OFBIZ-47) Quote SQL92 identifiers used in table definitions

     [ http://jira.undersunconsulting.com/browse/OFBIZ-47?page=all ]
     
Jacopo Cappellato closed OFBIZ-47:
----------------------------------

    Resolution: Won't Fix

> Quote SQL92 identifiers used in table definitions
> -------------------------------------------------
>
>          Key: OFBIZ-47
>          URL: http://jira.undersunconsulting.com/browse/OFBIZ-47
>      Project: [OFBiz] Open For Business
>         Type: Improvement
>   Components: entity
>     Reporter: Jeff Turner
>     Assignee: Jira Administrator

>
>
> Hi,
> We used 'position' as a field name, not knowing that it is a SQL92 reserved word, which causes certain databases like Frontbase to break.
> It would be nice if Ofbiz would quote-escape words it knows to be reserved to prevent this problem.
> See http://jira.atlassian.com/browse/JRA-4202 for the original issue

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.undersunconsulting.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira