[jira] [Updated] (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

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-5111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dhiraj Gupta updated OFBIZ-5111:
--------------------------------

    Summary: 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   (was: 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 )
   

> 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
>
> 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