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)