You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Dhiraj Gupta (JIRA)" <ji...@apache.org> on 2012/12/27 09:22:13 UTC
[jira] [Commented] (OFBIZ-5111) when I configire Postgresql instead
of derby database and after it run the command "ant run-install" then it
gives the error and when i create the database ofbiz in postgresql then it
create the pubic schema not ofbiz
[ https://issues.apache.org/jira/browse/OFBIZ-5111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539862#comment-13539862 ]
Dhiraj Gupta commented on OFBIZ-5111:
-------------------------------------
Hi Jacques,
Thanks
> when I configire Postgresql instead of derby database and after it run the command "ant run-install" then it gives the error and when i create the database ofbiz in postgresql then it create the pubic schema not ofbiz
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5111
> URL: https://issues.apache.org/jira/browse/OFBIZ-5111
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: Release 10.04
> Reporter: Dhiraj Gupta
> Assignee: Jacques Le Roux
>
> Hi,
> When we configure ofbiz to postgresql then it gives the error.
> 2012-12-26 17:51:57,067 (main) [ GenericDelegator.java:1466:ERROR]
> ---- exception report ----------------------------------------------------------
> Failure in storeAll operation: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PRODUCT_DIMENSION WHERE DIMENSION_ID=? (ERROR: schema "ofbiz" does not exist). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PRODUCT_DIMENSION WHERE DIMENSION_ID=? (ERROR: schema "ofbiz" does not exist)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: ERROR: schema "ofbiz" does not exist
> ---- stack trace ---------------------------------------------------------------
> java.sql.SQLException: ERROR: schema "ofbiz" does not exist
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
> org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:519)
> org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
> org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:79)
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1423)
> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221)
> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213)
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:383)
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100)
> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
> org.ofbiz.base.start.Start.startServer(Start.java:322)
> org.ofbiz.base.start.Start.start(Start.java:326)
> org.ofbiz.base.start.Start.main(Start.java:411)
> --------------------------------------------------------------------------------
> 2012-12-26 17:51:57,068 (main) [ TransactionUtil.java:370:WARN ]
> ---- exception report ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in storeAll operation: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PRODUCT_DIMENSION WHERE DIMENSION_ID=? (ERROR: schema "ofbiz" does not exist). Rolling back transaction.
> ---- stack trace ---------------------------------------------------------------
> java.lang.Exception: Failure in storeAll operation: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PRODUCT_DIMENSION WHERE DIMENSION_ID=? (ERROR: schema "ofbiz" does not exist). Rolling back transaction.
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1469)
> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221)
> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213)
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:383)
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100)
> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
> org.ofbiz.base.start.Start.startServer(Start.java:322)
> org.ofbiz.base.start.Start.start(Start.java:326)
> org.ofbiz.base.start.Start.main(Start.java:411)
> --------------------------------------------------------------------------------
> 2012-12-26 17:51:57,068 (main) [ EntitySaxReader.java:270:ERROR]
> ---- exception report ----------------------------------------------------------
> An error occurred saving the data, rolling back transaction (true)
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PRODUCT_DIMENSION WHERE DIMENSION_ID=? (ERROR: schema "ofbiz" does not exist)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: ERROR: schema "ofbiz" does not exist
> ---- stack trace ---------------------------------------------------------------
> java.sql.SQLException: ERROR: schema "ofbiz" does not exist
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
> org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:519)
> org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
> org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:79)
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1423)
> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221)
> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213)
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:383)
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100)
> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
> org.ofbiz.base.start.Start.startServer(Start.java:322)
> org.ofbiz.base.start.Start.start(Start.java:326)
> org.ofbiz.base.start.Start.main(Start.java:411)
> --------------------------------------------------------------------------------
> 2012-12-26 17:51:57,068 (main) [ TransactionUtil.java:344:INFO ] [TransactionUtil.rollback] transaction rolled back
> 2012-12-26 17:51:57,069 (main) [ EntityDataLoader.java:217:ERROR]
> ---- exception report ----------------------------------------------------------
> [install.loadData]: Error loading XML Resource "file:/D:/Workspace_Tallyint/ofbiz/applications/product/data/DimensionTypeData.xml"; Error was: A transaction error occurred reading data
> Exception: org.xml.sax.SAXException
> Message: A transaction error occurred reading data
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:SELECT PRODUCT_ID, PRODUCT_TYPE, BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PRODUCT_DIMENSION WHERE DIMENSION_ID=? (ERROR: schema "ofbiz" does not exist)
> ---- cause ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: ERROR: schema "ofbiz" does not exist
> ---- stack trace ---------------------------------------------------------------
> java.sql.SQLException: ERROR: schema "ofbiz" does not exist
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387)
> org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:519)
> org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
> org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:79)
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1423)
> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:285)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:264)
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:221)
> org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:213)
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:383)
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100)
> org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
> org.ofbiz.base.start.Start.startServer(Start.java:322)
> org.ofbiz.base.start.Start.start(Start.java:326)
> org.ofbiz.base.start.Start.main(Start.java:411)
> --------------------------------------------------------------------------------
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira