[
https://issues.apache.org/jira/browse/OFBIZ-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12627455#action_12627455
]
Jacques Le Roux commented on OFBIZ-1941:
----------------------------------------
Hi Nattanicha,
As BJ already pointed ou in ML this would be barely usable as you mentionned in
user ML
{quote}I must modify variables in ModelEntity.java because Foxpro cannot uses
fields names that are longer than 8 characters.{quote}
and above
{quote}Foxpro need to be put no-auto-stamp="true" for entity because Foxpro
does not support variable name that is longer than 8 characters.{quote}
This last comment is not clear to me. Do you mean that only field names (DB
columns) can't be longer than 8 characters or other DB elements (relations
names, indexes, etc.) are also concerned ?
I don' t close this issue for now in case someone has a solution or ideas. But
unfortunately I guess this is what will happen because we would need to have a
complete rewritting of entities definitions. Of course if you provide this
rewritting we could propose a patch for possibly other/future users but it will
never be commited in OFBiz and would have to be updated as the data model is
not freezed...
> fieldtypevisualfoxpro.xml
> -------------------------
>
> Key: OFBIZ-1941
> URL: https://issues.apache.org/jira/browse/OFBIZ-1941
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Environment: Windows, JDBC-ODBC bridge
> Reporter: Nattanicha
> Priority: Minor
> Attachments: fieldtypevisualfoxpro.xml
>
> Original Estimate: 336h
> Remaining Estimate: 336h
>
> Normally, OFBiz provides many field type files in framework\entity\fieldtype
> that can be used with many types of database. Visual foxpro is also a
> database type that need to be used to connect with OFBiz. Many legacy systems
> was developed by using Foxpro and need to be connected to new ERP system.
> By using fieldtypevisualfoxpro.xml, users must use Visual Foxpro ODBC driver
> (http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx) to be a driver to
> connect with DBF file because I cannot find DBF JDBC driver for free. Anyway,
> entity creation in entitymodel.xml for Foxpro need to be put
> no-auto-stamp="true" for entity because Foxpro does not support variable name
> that is longer than 8 characters. This problem should be fixed later if we
> need to use foxpro in OFBiz with Locking.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.