[
https://issues.apache.org/jira/browse/OFBIZ-330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14327400#comment-14327400 ]
Pierre Smits commented on OFBIZ-330:
------------------------------------
I will close this issue as HSQL isn't the default rdbms of OFBiz, but Apache Derby is.
If and when there issues related to HSQL arise new JIRA issues can be created.
> problems displaying UOMs in the fixed asset screen when using hsql
> ------------------------------------------------------------------
>
> Key: OFBIZ-330
> URL:
https://issues.apache.org/jira/browse/OFBIZ-330> Project: OFBiz
> Issue Type: Bug
> Components: accounting
> Environment: Database: HSQL
> Reporter: Ricardo Chavez
> Assignee: Pierre Smits
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)
Locked
