[ 
https://issues.apache.org/jira/browse/OFBIZ-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12627617#action_12627617
 ] 

BJ Freeman commented on OFBIZ-1941:
-----------------------------------

if I understand you, you want to create a entity model from your database.
the only step I have not seen is using the webtools to generate you entity 
models from the database
https://demo.hotwaxmedia.com/webtools/control/view/ModelInduceFromDb
created them from the table definition of the db.

all the code for this is in
framework\webtools\webapp\webtools\entity\ModelInduceFromDb.jsp


> 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.

Reply via email to