[
https://issues.apache.org/jira/browse/OFBIZ-5214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adrian Crum reassigned OFBIZ-5214:
----------------------------------
Assignee: (was: Adrian Crum)
> Different column sorting in entitymodel.xml and database causes PSQLException
> -----------------------------------------------------------------------------
>
> Key: OFBIZ-5214
> URL: https://issues.apache.org/jira/browse/OFBIZ-5214
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Kevin Tunstall
> Attachments: OFBIZ-5214.patch
>
>
> Due to r1486552, different column sorting in entitymodel.xml and database now
> causes a PSQLException, when an entity is selected without any selectFields.
> The index of the column in entitymodel.xml may not correspond to the index of
> the column in the database. Before r1486552, a select with all fields names
> instead of a "select *" was used.
> Example stacktrace:
> {quote}
> 2013-06-07 14:20:32,937 (main) [ EntityListIterator:346:WARN ] [ ] []
> Warning: auto-closed EntityListIterator because of exception:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while getting
> value : oldAmountPerQuantity [AMOUNT_PER_QUANTITY] (33) (Bad value for type
> BigDecimal : 2013-06-07 14:20:32.306+02)
> 2013-06-07 14:20:32,941 (main) [ GenericDelegator:1812:ERROR] [ ] []
> ---- exception report
> ----------------------------------------------------------
> Failure in findByCondition operation for entity [OrderAdjustment]:
> org.ofbiz.entity.GenericEntityException: Error creating GenericValue (SQL
> Exception while getting value : oldAmountPerQuantity [AMOUNT_PER_QUANTITY]
> (33) (Bad value for type BigDecimal : 2013-06-07 14:20:32.306+02)). Rolling
> back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error creating GenericValue (SQL Exception while getting value :
> oldAmountPerQuantity [AMOUNT_PER_QUANTITY] (33) (Bad value for type
> BigDecimal : 2013-06-07 14:20:32.306+02))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while getting value : oldAmountPerQuantity
> [AMOUNT_PER_QUANTITY] (33) (Bad value for type BigDecimal : 2013-06-07
> 14:20:32.306+02)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: Bad value for type BigDecimal : 2013-06-07 14:20:32.306+02
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: Bad value for type BigDecimal : 2013-06-07
> 14:20:32.306+02
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.toBigDecimal(AbstractJdbc2ResultSet.java:2816)
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBigDecimal(AbstractJdbc2ResultSet.java:2237)
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBigDecimal(AbstractJdbc2ResultSet.java:323)
> org.apache.commons.dbcp.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:340)
> org.apache.commons.dbcp.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:340)
> org.ofbiz.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:692)
> org.ofbiz.entity.util.EntityListIterator.currentGenericValue(EntityListIterator.java:178)
> org.ofbiz.entity.util.EntityListIterator.next(EntityListIterator.java:325)
> org.ofbiz.entity.util.EntityListIterator.getCompleteList(EntityListIterator.java:439)
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1802)
> org.ofbiz.entity.GenericDelegator.findByAnd(GenericDelegator.java:1735)
> org.ofbiz.entity.Delegator$findByAnd.call(Unknown Source)
> {quote}
> Here, the column actually read from the database was a date, but the column
> used in the JdbcValueHandler is a BigDecimal.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
