problems displaying UOMs in the fixed asset screen when using hsql
------------------------------------------------------------------
Key: OFBIZ-330
URL: http://issues.apache.org/jira/browse/OFBIZ-330
Project: OFBiz (The Open for Business Project)
Issue Type: Bug
Components: accounting
Environment: Database: HSQL
Reporter: Ricardo Chavez
Priority: Minor
Hello everybody. I've encoutered the following problems when working with the
default database manager (HSQL):
When editing or creating a new fixed asset, the UOM and CommonCalendar
drop-down fields don't show any elements. Upon examinig the log, I've found the
following:
2006-09-26 10:51:05,984 (http-0.0.0.0-8443-Processor4) [
GenericDelegator.java:1713:ERROR]
---- exception report ----------------------------------------------------------
Failure in findByCondition operation for entity [UomAndType]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the
following:SELECT UOM.UOM_ID AS UOM_ID, UOM.UOM_TYPE_ID AS UOM_TYPE_ID,
UOM.ABBREVIATION AS ABBREVIATION, UOM.DESCRIPTION AS DESCRIPTION,
UOMTP.UOM_TYPE_ID AS TYPE_UOM_TYPE_ID, UOMTP.PARENT_TYPE_ID AS
TYPE_PARENT_TYPE_ID, UOMTP.HAS_TABLE AS TYPE_HAS_TABLE, UOMTP.DESCRIPTION AS
TYPE_DESCRIPTION FROM UOM UOM INNER JOIN UOM_TYPE UOMTP ON UOM.UOM_TYPE_ID =
UOMTP.UOM_TYPE_ID ORDER BY UOM_TYPE_ID ASC (ambiguous Column reference:
UOM_TYPE_ID in statement [... (same statement as above) ...]). Rolling back
transaction.
(etc., etc.)
Switching to Derby fixes the problem, which leads me to think it's a problem
with HSQL.
Regards,
-- Ricardo Chavez
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
