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 06:12:12 UTC
[jira] [Created] (OFBIZ-5111) when I configire Postgresql instead o
derby database and after it run the command "ant run-install" then it gives
the eorror and when i create the database ofbiz.in postgresql then it
create the pubic schema not ofbiz
Dhiraj Gupta created OFBIZ-5111:
-----------------------------------
Summary: when I configire Postgresql instead o derby database and after it run the command "ant run-install" then it gives the eorror 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
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