[ https://issues.apache.org/jira/browse/OFBIZ-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798604#action_12798604 ] Erwan de FERRIERES commented on OFBIZ-3245: ------------------------------------------- Hi Adrian, I tested your patch with postgreSQL, and I found some errors in the log when data is loaded. Here is a part of the log file, if needed, I can attach it to this issue. [java] 2010-01-11 08:38:34,281 (main) [ EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/home/erwan/workspace/ofbizTrunk/applications/content/data/ContentTypeData.xml [java] 2010-01-11 08:38:34,281 (main) [ EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] 2010-01-11 08:38:34,861 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:34,862 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:34,883 (main) [ EntitySaxReader.java:277:INFO ] Finished 185 values from file:/home/erwan/workspace/ofbizTrunk/applications/content/data/ContentTypeData.xml [java] 2010-01-11 08:38:34,883 (main) [ EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/home/erwan/workspace/ofbizTrunk/applications/content/data/ContentOperationData.xml [java] 2010-01-11 08:38:34,883 (main) [ EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] 2010-01-11 08:38:35,106 (main) [ EntitySaxReader.java:277:INFO ] Finished 97 values from file:/home/erwan/workspace/ofbizTrunk/applications/content/data/ContentOperationData.xml [java] 2010-01-11 08:38:35,106 (main) [ EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/home/erwan/workspace/ofbizTrunk/applications/content/data/MimeTypeData.xml [java] 2010-01-11 08:38:35,107 (main) [ EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] Jan 11, 2010 8:38:35 AM java.util.logging.LogManager$RootLogger log [java] INFO: XMLStreamReaderImpl: Data buffer increased to 16384 [java] Jan 11, 2010 8:38:35 AM java.util.logging.LogManager$RootLogger log [java] INFO: XMLStreamReaderImpl: Data buffer increased to 32768 [java] Jan 11, 2010 8:38:35 AM java.util.logging.LogManager$RootLogger log [java] INFO: XMLStreamReaderImpl: Data buffer increased to 65536 [java] 2010-01-11 08:38:35,367 (main) [ EntitySaxReader.java:277:INFO ] Finished 109 values from file:/home/erwan/workspace/ofbizTrunk/applications/content/data/MimeTypeData.xml [java] 2010-01-11 08:38:35,368 (main) [ EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/home/erwan/workspace/ofbizTrunk/applications/content/data/MimeTypeTemplate.xml [java] 2010-01-11 08:38:35,368 (main) [ EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] 2010-01-11 08:38:35,391 (main) [ EntitySaxReader.java:277:INFO ] Finished 9 values from file:/home/erwan/workspace/ofbizTrunk/applications/content/data/MimeTypeTemplate.xml [java] 2010-01-11 08:38:35,392 (main) [ EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/home/erwan/workspace/ofbizTrunk/applications/content/data/DataCategoryData.xml [java] 2010-01-11 08:38:35,393 (main) [ EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] 2010-01-11 08:38:35,427 (main) [ EntitySaxReader.java:277:INFO ] Finished 17 values from file:/home/erwan/workspace/ofbizTrunk/applications/content/data/DataCategoryData.xml [java] 2010-01-11 08:38:35,427 (main) [ EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/home/erwan/workspace/ofbizTrunk/applications/content/data/SeedBlogData.xml [java] 2010-01-11 08:38:35,428 (main) [ EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] 2010-01-11 08:38:35,502 (main) [ EntitySaxReader.java:277:INFO ] Finished 1 values from file:/home/erwan/workspace/ofbizTrunk/applications/content/data/SeedBlogData.xml [java] 2010-01-11 08:38:35,502 (main) [ EntitySaxReader.java:220:INFO ] Beginning import from URL: file:/home/erwan/workspace/ofbizTrunk/applications/content/data/TemplateData.xml [java] 2010-01-11 08:38:35,502 (main) [ EntitySaxReader.java:258:INFO ] Transaction Timeout set to 2 hours (7200 seconds) [java] 2010-01-11 08:38:35,607 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,608 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,621 (main) [ SqlJdbcUtil.java:506:ERROR] [java] ---- exception report ---------------------------------------------------------- [java] Exception: org.postgresql.util.PSQLException [java] Message: Bad value for type long : <#assign mapKey=wrapMapKey?if_exists/> [java] <#assign subDataResourceId=wrapDataResourceId?if_exists/> [java] <#assign subDataResourceTypeId=wrapDataResourceTypeId?if_exists/> [java] <#assign contentIdTo=wrapContentIdTo?if_exists/> [java] <#assign mimeTypeId=wrapMimeTypeId?if_exists/> [java] <#assign subContentId=wrapSubContentId?if_exists/> [java] <div id="divTwo" class="wrapOuter"> [java] <div class="tabletext"> [java] ${mapKey?if_exists} [java] <a class="buttontext" href="javascript:lookupSubContent('<@ofbizUrl>/LookupSubContent</@ofbizUrl>', '${contentIdTo?if_exists}','${mapKey?if_exists}', '${subDataResourceTypeId?if_exists}', '${mimeTypeId?if_exists}')">[Find]</a> [java] <#assign ofbizRequest=""/> [java] <#assign httpParams="contentIdTo=" + contentIdTo?if_exists + "&mapKey=" + mapKey?if_exists /> [java] <#if subDataResourceTypeId == "IMAGE_OBJECT"> [java] <#assign ofbizRequest="EditLayoutImage"/> [java] <#else> [java] <#if subDataResourceTypeId == "URL_RESOURCE"> [java] <#assign ofbizRequest="EditLayoutUrl"/> [java] <#else> [java] <#assign ofbizRequest="EditLayoutSubContent"/> [java] </#if> [java] </#if> [java] <a class="buttontext" href="<@ofbizUrl>/${ofbizRequest}?${httpParams}&mode=add</@ofbizUrl>">[New]</a> [java] <#if subContentId?exists && (0 < subContentId?length)> [java] <a class="buttontext" href="<@ofbizUrl>/${ofbizRequest}?${httpParams}&contentId=${subContentId}&drDataResourceId=${subDataResourceId?if_exists}</@ofbizUrl>">[Edit]</a> [java] </#if> [java] </div> [java] <div id="divOne" class="wrapInner"> [java] <@renderWrappedText/> [java] </div> [java] </div> [java] ---- stack trace --------------------------------------------------------------- [java] org.postgresql.util.PSQLException: Bad value for type long : <#assign mapKey=wrapMapKey?if_exists/> [java] <#assign subDataResourceId=wrapDataResourceId?if_exists/> [java] <#assign subDataResourceTypeId=wrapDataResourceTypeId?if_exists/> [java] <#assign contentIdTo=wrapContentIdTo?if_exists/> [java] <#assign mimeTypeId=wrapMimeTypeId?if_exists/> [java] <#assign subContentId=wrapSubContentId?if_exists/> [java] <div id="divTwo" class="wrapOuter"> [java] <div class="tabletext"> [java] ${mapKey?if_exists} [java] <a class="buttontext" href="javascript:lookupSubContent('<@ofbizUrl>/LookupSubContent</@ofbizUrl>', '${contentIdTo?if_exists}','${mapKey?if_exists}', '${subDataResourceTypeId?if_exists}', '${mimeTypeId?if_exists}')">[Find]</a> [java] <#assign ofbizRequest=""/> [java] <#assign httpParams="contentIdTo=" + contentIdTo?if_exists + "&mapKey=" + mapKey?if_exists /> [java] <#if subDataResourceTypeId == "IMAGE_OBJECT"> [java] <#assign ofbizRequest="EditLayoutImage"/> [java] <#else> [java] <#if subDataResourceTypeId == "URL_RESOURCE"> [java] <#assign ofbizRequest="EditLayoutUrl"/> [java] <#else> [java] <#assign ofbizRequest="EditLayoutSubContent"/> [java] </#if> [java] </#if> [java] <a class="buttontext" href="<@ofbizUrl>/${ofbizRequest}?${httpParams}&mode=add</@ofbizUrl>">[New]</a> [java] <#if subContentId?exists && (0 < subContentId?length)> [java] <a class="buttontext" href="<@ofbizUrl>/${ofbizRequest}?${httpParams}&contentId=${subContentId}&drDataResourceId=${subDataResourceId?if_exists}</@ofbizUrl>">[Edit]</a> [java] </#if> [java] </div> [java] <div id="divOne" class="wrapInner"> [java] <@renderWrappedText/> [java] </div> [java] </div> [java] org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796) [java] org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2019) [java] org.postgresql.jdbc4.Jdbc4ResultSet.getClob(Jdbc4ResultSet.java:43) [java] org.apache.commons.dbcp.DelegatingResultSet.getClob(DelegatingResultSet.java:553) [java] org.apache.commons.dbcp.DelegatingResultSet.getClob(DelegatingResultSet.java:553) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.getObject(SqlTypes.java:321) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.getObject(SqlTypes.java:229) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:503) [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:531) [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:493) [java] org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:79) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1362) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,624 (main) [ SqlJdbcUtil.java:509:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,635 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:276) [java] org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:219) [java] org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:213) [java] org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:171) [java] org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1292) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1398) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,635 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,638 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,639 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,641 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,641 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,643 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,643 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,648 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,649 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,651 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,651 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,654 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,654 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,658 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,658 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,669 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,669 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,672 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,672 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,674 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,675 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,680 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,680 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,682 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,706 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,710 (main) [ SqlJdbcUtil.java:751:INFO ] [java] ---- exception report ---------------------------------------------------------- [java] Exception: javax.sql.rowset.serial.SerialException [java] Message: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] ---- stack trace --------------------------------------------------------------- [java] javax.sql.rowset.serial.SerialException: Unsupported operation. SerialClob cannot return a the CLOB value as an ascii stream, unless instantiated with a fully implemented Clob object. [java] javax.sql.rowset.serial.SerialClob.getAsciiStream(SerialClob.java:195) [java] org.postgresql.jdbc2.AbstractJdbc2Statement.setClob(AbstractJdbc2Statement.java:2980) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187) [java] org.ofbiz.entity.jdbc.SqlTypes$ClobSqlObjectHandler.castSetObject(SqlTypes.java:317) [java] org.ofbiz.entity.jdbc.SqlTypes$HandlerDecorator.setObject(SqlTypes.java:225) [java] org.ofbiz.entity.jdbc.SQLProcessor.setObject(SQLProcessor.java:540) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:748) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:727) [java] org.ofbiz.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:445) [java] org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) [java] org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) [java] org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) [java] org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1372) [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221) [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213) [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:382) [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] org.ofbiz.base.start.Start.startServer(Start.java:322) [java] org.ofbiz.base.start.Start.start(Start.java:326) [java] org.ofbiz.base.start.Start.main(Start.java:411) [java] -------------------------------------------------------------------------------- [java] [java] 2010-01-11 08:38:35,711 (main) [ SqlJdbcUtil.java:754:INFO ] Unable to convert, falling back on switch statement [java] 2010-01-11 08:38:35,718 (main) [ EntitySaxReader.java:277:INFO ] Finished 52 values from file:/home/erwan/workspace/ofbizTrunk/applications/content/data/TemplateData.xml > Sandbox: Integrating The New Conversion Framework Into The Entity Engine > ------------------------------------------------------------------------ > > Key: OFBIZ-3245 > URL: https://issues.apache.org/jira/browse/OFBIZ-3245 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Reporter: Adrian Crum > Assignee: Adrian Crum > Priority: Minor > Attachments: conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch > > > This issue contains a patch intended for evaluation before it is committed. See comments for details. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adrian Crum updated OFBIZ-3245: ------------------------------- Attachment: conversion.patch Updated patch. This should solve the Clob error messages. > Sandbox: Integrating The New Conversion Framework Into The Entity Engine > ------------------------------------------------------------------------ > > Key: OFBIZ-3245 > URL: https://issues.apache.org/jira/browse/OFBIZ-3245 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Reporter: Adrian Crum > Assignee: Adrian Crum > Priority: Minor > Attachments: conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch > > > This issue contains a patch intended for evaluation before it is committed. See comments for details. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12858481#action_12858481 ] Jacopo Cappellato commented on OFBIZ-3245: ------------------------------------------ Adrian, unfortunately I didn't find time to test your patch. However, I don't know if it helps or not, it seems that the Oracle error has been resolved by my customer with the following patch: + public static class OracleTIMESTAMPToTimestamp extends AbstractConverter<oracle.sql.TIMESTAMP, java.sql.Timestamp> { + public OracleTIMESTAMPToTimestamp() { + super(oracle.sql.TIMESTAMP.class, java.sql.Timestamp.class); + } + + public java.sql.Timestamp convert(oracle.sql.TIMESTAMP obj) throws ConversionException { + try { + return obj.timestampValue(); + } catch (Exception e) { + throw new ConversionException(e); + } + } + } + > Sandbox: Integrating The New Conversion Framework Into The Entity Engine > ------------------------------------------------------------------------ > > Key: OFBIZ-3245 > URL: https://issues.apache.org/jira/browse/OFBIZ-3245 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Reporter: Adrian Crum > Assignee: Adrian Crum > Priority: Minor > Attachments: conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch > > > This issue contains a patch intended for evaluation before it is committed. See comments for details. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12858541#action_12858541 ] Adrian Crum commented on OFBIZ-3245: ------------------------------------ Thanks Jacopo. I would prefer to keep OFBiz database-agnostic, so the code you suggested won't help. > Sandbox: Integrating The New Conversion Framework Into The Entity Engine > ------------------------------------------------------------------------ > > Key: OFBIZ-3245 > URL: https://issues.apache.org/jira/browse/OFBIZ-3245 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Reporter: Adrian Crum > Assignee: Adrian Crum > Priority: Minor > Attachments: conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch > > > This issue contains a patch intended for evaluation before it is committed. See comments for details. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adrian Crum closed OFBIZ-3245. ------------------------------ Resolution: Won't Fix I'm closing this because the approach I tried to take caused issues with some JDBC drivers. Many thanks to everyone who helped out. > Sandbox: Integrating The New Conversion Framework Into The Entity Engine > ------------------------------------------------------------------------ > > Key: OFBIZ-3245 > URL: https://issues.apache.org/jira/browse/OFBIZ-3245 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Reporter: Adrian Crum > Assignee: Adrian Crum > Priority: Minor > Attachments: conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch, conversion.patch > > > This issue contains a patch intended for evaluation before it is committed. See comments for details. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
Free forum by Nabble | Edit this page |