Changing the type list to only include "TABLE" prevents the VIEWs from being imported. Does anyone think its worth creating a JIRA issue to control the database entity types (TABLES,VIEWS,etc.) to be imported from the UI?

On 01/14/2014 09:55 AM, Christian Carlow wrote:
Looks like getTableNames() of DatabaseUtil.java is responsible for building the table name list according to:
String[] types = {"TABLE", "VIEW", "ALIAS", "SYNONYM"};

No parameter exist to control the table type to get so I guess there isn't a way to prevent VIEWs from being imported as of right now.

On 01/14/2014 09:41 AM, Christian Carlow wrote:
I got the entitymodel.xml content to generate in the page source after applying the patch from OFBIZ-5484 but the import included VIEWs. Does anyone know how to import only the table data using this tool?

On 01/14/2014 08:57 AM, Christian Carlow wrote:
There were 5 or so issues with this file that were resolved. getValidatorsSize() was changed to getValidators().size(). I'll create a JIRA issue to resolve this issue.

On 01/14/2014 08:52 AM, Christian Carlow wrote:
I get this error when trying to access https://localhost:8443/webtools/control/view/ModelInduceFromDb:

org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 126 in the jsp file: /entity/ModelInduceFromDb.jsp
The method getValidatorsSize() is undefined for the type ModelField


On 01/14/2014 08:17 AM, Christian Carlow wrote:
I looked at https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data regarding legacydb and it seems like worthy alternative method. What's great about BSH (when its working correctly) is that you can stop the script at the command line and have it output results as operations are performed which makes debugging easier.

On 01/14/2014 08:05 AM, Christian Carlow wrote:
I need to import data from an existing ERP MSSQL database into OFBiz. So far I've only used the BSH connection to run scripts that include the MSSQL jdbc to access the data. I'm looking for a different method than BSH because it seems to encounter issues that I haven't been able to resolve without a server restart which makes import script development much more time consuming.

Does anyone know of a better environment where the MSSQL jdbc can be used to access external data while still having access to the OFBiz environment like BSH?

I got the idea for using BSH from this webpage which is a bit out of date: http://www.opensourcestrategies.com/ofbiz/entities_services.php (A Word About BeanShell section)






Reply via email to