[jira] [Commented] (OFBIZ-12021) "description" and "comment" datatypes unnecessarily limited to 255 char
Locked
[jira] [Commented] (OFBIZ-12021) "description" and "comment" datatypes unnecessarily limited to 255 char
 
|
[ https://issues.apache.org/jira/browse/OFBIZ-12021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17206681#comment-17206681 ] Jacques Le Roux commented on OFBIZ-12021: ----------------------------------------- Here is a list of the error found locally: {noformat} Unit Test Results. Designed for use with JUnit and Ant. All Errors Class Name Status Type Time(s) ecommercetests testSendOrderConfirmation Error assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessage':'Service exception; see logs', 'responseMessage':'error'] Assertion failed: assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessage':'Service exception; see logs', 'responseMessage':'error'] at org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670) at org.apache.ofbiz.ecommerce.OrderNotificationTests.testSendOrderConfirmation(OrderNotificationTests.groovy:37) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 2.376 entitytests testStoreByCondition Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468) at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397) at org.apache.ofbiz.entity.test.EntityTestSuite.testStoreByCondition(EntityTestSuite.java:655) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_NODE_ID, PRIMARY_PARENT_NODE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_NODE WHERE ((DESCRIPTION = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.020 entitytests testEntityCache Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468) at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397) at org.apache.ofbiz.entity.test.EntityTestSuite.testEntityCache(EntityTestSuite.java:244) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.058 entitytests testFindDistinct Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468) at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397) at org.apache.ofbiz.entity.test.EntityTestSuite.testFindDistinct(EntityTestSuite.java:528) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT TESTING_SIZE, COMMENTS FROM OFBIZ.TESTING WHERE ((COMMENTS = ? AND TESTING_SIZE = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.019 entitytests testCryptoSubSelect Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468) at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397) at org.apache.ofbiz.entity.test.EntityCryptoTestSuite.testCryptoSubSelect(EntityCryptoTestSuite.java:196) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ?)) ORDER BY TESTING_CRYPTO_ID ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.107 entitytests testCryptoLookup Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:468) at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:397) at org.apache.ofbiz.entity.test.EntityCryptoTestSuite.testCryptoLookup(EntityCryptoTestSuite.java:145) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_CRYPTO_ID, TESTING_CRYPTO_TYPE_ID, UNENCRYPTED_VALUE, ENCRYPTED_VALUE, SALTED_ENCRYPTED_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_CRYPTO WHERE ((ENCRYPTED_VALUE = ? AND TESTING_CRYPTO_TYPE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.014 entitytests testOrderBy Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616) at org.apache.ofbiz.entity.test.EntityQueryTestSuite.testOrderBy(EntityQueryTestSuite.java:250) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (TESTING_TYPE_ID LIKE ?) ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.006 entitytests testWhere Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616) at org.apache.ofbiz.entity.test.EntityQueryTestSuite.testWhere(EntityQueryTestSuite.java:77) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE WHERE (DESCRIPTION = ?) ORDER BY DESCRIPTION ASC (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown Source) at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.005 entitytests testQueryList Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616) at org.apache.ofbiz.entity.test.EntityQueryTestSuite.testQueryList(EntityQueryTestSuite.java:104) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.005 entitytests testFetchSize Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616) at org.apache.ofbiz.entity.test.EntityQueryTestSuite.testFetchSize(EntityQueryTestSuite.java:352) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.004 entitytests testMaxRows Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616) at org.apache.ofbiz.entity.test.EntityQueryTestSuite.testMaxRows(EntityQueryTestSuite.java:326) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TESTING_TYPE_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.003 entitytests testDistinctAndSelect Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616) at org.apache.ofbiz.entity.test.EntityQueryTestSuite.testDistinctAndSelect(EntityQueryTestSuite.java:224) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.005 entitytests testSelect Error org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1662) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1616) at org.apache.ofbiz.entity.test.EntityQueryTestSuite.testSelect(EntityQueryTestSuite.java:197) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DESCRIPTION FROM OFBIZ.TESTING_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:419) at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:806) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:157) at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1600) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1648) Caused by: java.sql.SQLException: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:318) at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:401) Caused by: ERROR X0X67: Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ResultColumn.verifyOrderable(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) 0.005 invoicetests testGlPostingOnCancelCheckRun Error assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] Assertion failed: assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] at org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670) at org.apache.ofbiz.accounting.AutoInvoiceTests.testGlPostingOnCancelCheckRun(AutoInvoiceTests.groovy:258) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 0.056 invoicetests testGlPostingOnCancelInvoice Error assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] Assertion failed: assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] at org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670) at org.apache.ofbiz.accounting.AutoInvoiceTests.testGlPostingOnCancelInvoice(AutoInvoiceTests.groovy:186) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 0.010 paymenttests testGlPostingsOnVoidPayment Error assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] Assertion failed: assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] at org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670) at org.apache.ofbiz.accounting.AutoPaymentTests.testGlPostingsOnVoidPayment(AutoPaymentTests.groovy:355) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 0.564 paymenttests testGlPostingOnCheckRun Error assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] Assertion failed: assert ServiceUtil.isSuccess(serviceResult) | | false ['errorMessageList':['Exception thrown while performing entity find: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT DISTINCT ATR.IS_POSTED, ATR.GL_FISCAL_TYPE_ID, ATR.ACCTG_TRANS_TYPE_ID, ATR.TRANSACTION_DATE, ATR.POSTED_DATE, ATR.DESCRIPTION, ATR.GL_JOURNAL_ID, ATT.DESCRIPTION, ATR.INVOICE_ID, ATR.PAYMENT_ID, ATR.SHIPMENT_ID, ATR.RECEIPT_ID, ATR.INVENTORY_ITEM_ID, ATR.WORK_EFFORT_ID, ATR.FIXED_ASSET_ID, ATR.PHYSICAL_INVENTORY_ID, ATR.DESCRIPTION, ATE.ACCTG_TRANS_ID, ATE.ACCTG_TRANS_ENTRY_SEQ_ID, ATE.GL_ACCOUNT_ID, ATE.PRODUCT_ID, ATE.DEBIT_CREDIT_FLAG, ATE.AMOUNT, ATE.CURRENCY_UOM_ID, ATE.ORIG_AMOUNT, ATE.ORIG_CURRENCY_UOM_ID, ATE.ORGANIZATION_PARTY_ID, GLA.GL_ACCOUNT_TYPE_ID, GLA.ACCOUNT_CODE, GLA.ACCOUNT_NAME, GLAC.GL_ACCOUNT_CLASS_ID, ATE.PARTY_ID, ATE.RECONCILE_STATUS_ID, ATE.ACCTG_TRANS_ENTRY_TYPE_ID FROM (((OFBIZ.ACCTG_TRANS ATR INNER JOIN OFBIZ.ACCTG_TRANS_ENTRY ATE ON ATR.ACCTG_TRANS_ID = ATE.ACCTG_TRANS_ID) INNER JOIN OFBIZ.ACCTG_TRANS_TYPE ATT ON ATR.ACCTG_TRANS_TYPE_ID = ATT.ACCTG_TRANS_TYPE_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT GLA ON ATE.GL_ACCOUNT_ID = GLA.GL_ACCOUNT_ID) LEFT OUTER JOIN OFBIZ.GL_ACCOUNT_CLASS GLAC ON GLA.GL_ACCOUNT_CLASS_ID = GLAC.GL_ACCOUNT_CLASS_ID WHERE ((ATE.ORGANIZATION_PARTY_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ATE.GL_ACCOUNT_ID = ? AND ATR.TRANSACTION_DATE >= ? AND ATR.TRANSACTION_DATE < ?)) (Columns of type \'CLOB\' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.))'], 'responseMessage':'error'] at org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:415) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:670) at org.apache.ofbiz.accounting.AutoPaymentTests.testGlPostingOnCheckRun(AutoPaymentTests.groovy:432) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 0.021 {noformat} And a list of the failures: {noformat} Unit Test Results. Designed for use with JUnit and Ant. All Failures Class Name Status Type Time(s) partytests party-tests-0.testFindPartyWithSearchParameters Failure Error looking up RoleTypes: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) junit.framework.AssertionFailedError: Error looking up RoleTypes: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 0.098 partytests party-tests-0.testFindPartyWithNoSearchParameters Failure Error looking up RoleTypes: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) junit.framework.AssertionFailedError: Error looking up RoleTypes: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.) (SQL Exception while executing the following:SELECT ROLE_TYPE_ID, PARENT_TYPE_ID, HAS_TABLE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ROLE_TYPE ORDER BY DESCRIPTION ASC (Columns of type 'CLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.)) at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 0.003 scrumtests product-tests.testAddProductTimeToNewInvoice Failure ERROR: Could not complete the add all reported time on all completed timesheets from all workefforts for a product [file:/C:/projectsASF/Git/ofbiz-framework/plugins/scrum/minilang/ScrumServices.xml#addProductTimeToNewInvoice] process [problem invoking the [scrumAddWorkEffortTimeToInvoice] service with the map named [addTaskToInvoice] containing [{workEffortId=DEMO-TASK-4, userLogin=[GenericEntity:UserLogin][createdStamp,2020-10-03 12:51:58.833(java.sql.Timestamp)][createdTxStamp,2020-10-03 12:51:58.523(java.sql.Timestamp)][currentPassword,null()][disabledBy,null()][disabledDateTime,null()][enabled,N(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,Y(java.lang.String)][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2020-10-03 12:52:03.31(java.sql.Timestamp)][lastUpdatedTxStamp,2020-10-03 12:52:03.094(java.sql.Timestamp)][partyId,system(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,system(java.lang.String)], invoiceId=CI1, combineInvoiceItem=Y, locale=en, thruDate=2010-11-01 00:00:00.0}]: Service [scrumAddWorkEffortTimeToInvoice] Failed (null)] junit.framework.AssertionFailedError: ERROR: Could not complete the add all reported time on all completed timesheets from all workefforts for a product [file:/C:/projectsASF/Git/ofbiz-framework/plugins/scrum/minilang/ScrumServices.xml#addProductTimeToNewInvoice] process [problem invoking the [scrumAddWorkEffortTimeToInvoice] service with the map named [addTaskToInvoice] containing [{workEffortId=DEMO-TASK-4, userLogin=[GenericEntity:UserLogin][createdStamp,2020-10-03 12:51:58.833(java.sql.Timestamp)][createdTxStamp,2020-10-03 12:51:58.523(java.sql.Timestamp)][currentPassword,null()][disabledBy,null()][disabledDateTime,null()][enabled,N(java.lang.String)][externalAuthId,null()][hasLoggedOut,null()][isSystem,Y(java.lang.String)][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()][lastUpdatedStamp,2020-10-03 12:52:03.31(java.sql.Timestamp)][lastUpdatedTxStamp,2020-10-03 12:52:03.094(java.sql.Timestamp)][partyId,system(java.lang.String)][passwordHint,null()][requirePasswordChange,null()][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,system(java.lang.String)], invoiceId=CI1, combineInvoiceItem=Y, locale=en, thruDate=2010-11-01 00:00:00.0}]: Service [scrumAddWorkEffortTimeToInvoice] Failed (null)] at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) Exception thrown while performing entity find: Error doing find by and: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, OVERRIDE_ORG_PARTY_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY, AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_AUTHORITY_RATE_SEQ_ID, SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM WHERE ((AMOUNT IS NULL AND DESCRIPTION = ? AND INVOICE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, OVERRIDE_ORG_PARTY_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY, AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_AUTHORITY_RATE_SEQ_ID, SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM WHERE ((AMOUNT IS NULL AND DESCRIPTION = ? AND INVOICE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) junit.framework.AssertionFailedError: Exception thrown while performing entity find: Error doing find by and: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, OVERRIDE_ORG_PARTY_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY, AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_AUTHORITY_RATE_SEQ_ID, SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM WHERE ((AMOUNT IS NULL AND DESCRIPTION = ? AND INVOICE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, OVERRIDE_ORG_PARTY_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY, AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_AUTHORITY_RATE_SEQ_ID, SALES_OPPORTUNITY_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.INVOICE_ITEM WHERE ((AMOUNT IS NULL AND DESCRIPTION = ? AND INVOICE_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) 1.222 workefforttests workeffort-tests.testCreateTimesheets Failure Exception thrown while performing entity find: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID, FROM_DATE, THRU_DATE, STATUS_ID, APPROVED_BY_USER_LOGIN_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND PARTY_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID, FROM_DATE, THRU_DATE, STATUS_ID, APPROVED_BY_USER_LOGIN_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND PARTY_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) junit.framework.AssertionFailedError: Exception thrown while performing entity find: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID, FROM_DATE, THRU_DATE, STATUS_ID, APPROVED_BY_USER_LOGIN_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND PARTY_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')) (SQL Exception while executing the following:SELECT TIMESHEET_ID, PARTY_ID, CLIENT_PARTY_ID, FROM_DATE, THRU_DATE, STATUS_ID, APPROVED_BY_USER_LOGIN_ID, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.TIMESHEET WHERE ((COMMENTS = ? AND PARTY_ID = ?)) (Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'))) at org.apache.ofbiz.testtools.SimpleMethodTest.run(SimpleMethodTest.java:96) at org.apache.ofbiz.testtools.TestRunContainer.start(TestRunContainer.java:90) at org.apache.ofbiz.base.container.ContainerLoader.startLoadedContainers(ContainerLoader.java:153) at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:77) at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) at org.apache.ofbiz.base.start.Start.main(Start.java:89) {noformat} > "description" and "comment" datatypes unnecessarily limited to 255 char > ------------------------------------------------------------------------ > > Key: OFBIZ-12021 > URL: https://issues.apache.org/jira/browse/OFBIZ-12021 > Project: OFBiz > Issue Type: Improvement > Components: datamodel, framework/entity > Reporter: ddev > Priority: Minor > Fix For: Upcoming Branch > > Attachments: documentation-first-draft.diff, field-types-v2.diff > > Original Estimate: 10m > Remaining Estimate: 10m > > "description" and "comment" fields are restricted to 255 char. However after some research I found that all the supported databases support longer then 255 char > I would expect users to want to write more then 255 char in a comment (I know I personally can). > I have included diff of my proposed solution as a attachment (I am unfamiliar with the procedures for submitting patches here) > A discussion has been started on dev ML: https://markmail.org/message/7utrgejc2c44i37u > -- This message was sent by Atlassian Jira (v8.3.4#803005) |
«
Return to OFBiz - Notifications
|
1 view|%1 views
| Free forum by Nabble | Edit this page |