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

Nattanicha commented on OFBIZ-1941:
-----------------------------------

Sorry if I confused all of You. My objective for this issue is about 
INTEGRATION. So, it does not mean that I need Foxpro to be one of databases 
(among many databases that are provided to use with OFBiz, for example, derby, 
mysql and postgresql) that can be connected and put all of OFBiz data. I just 
need OFBiz to provide entity configuration to connect with DBF file.

This issue came from my experience when I created new application on OFBiz and 
this new one need to be connected with Foxpro. The most important problem that 
I faced is there is no entity definition for Foxpro database. I cannot create 
entity to connect with existing DBF file. I need to find the way to do it with 
myself. Many people in Thailand also faced this problem (but I don't know how 
about others). So, if the entity configuration and approach to connect Foxpro 
can be provided into default OFBiz, it should be the most appreciated. We can 
use our new application with Foxpro that can be integrated with other 
applications in OFBiz which are connected other databases.

I can find the approach to do this by creating fieldtypevisualfoxpro.xml, 
modified entityengine.xml and using Visual Foxpro ODBC. Moreover, I faced that 
this way can be used only in Windows, I have plan to develop JDBC for foxpro 
database.

Anyway, when I created my new application, I created entity model. I need to 
put no time stamp because I don't need it create new variables about time stamp 
into DBF file (that longer than 8 characters). So, I cannot put 
enable-lock=true because I don't have time stamp variables created in. The way 
I done this is I modified variables in ModelEntity.java about time stamp to be 
not longer than 8 characters, then I can use my new application that can be 
connected to DBF that is provided lock machanism. This is not a good way 
because I changed the static variables inside ModelEntity.java. That's why I 
need to ask about this solution.

> 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