if you read http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide you will see that db setup is before intitialzation. this means all the dB setup visiting the http://www.postgresql.org/docs/ will help understand how to deal with that db.
Brendan Vogt sent the following on 10/20/2007 1:04 PM: > Do I have to go and create a database before I run the build.xml file?? I > got millions of errors while running the build.xml file with ant > run-install. > > Here is what I could see, please help me: > > [java] ---- exception report > ---------------------------------------------- > ------------ > [java] [TransactionUtil.setRollbackOnly] Calling transaction > setRollbackOnl > y; this stack trace shows where this is happening: > [java] Exception: java.lang.Exception > [java] Message: Failure in storeAll operation: > org.ofbiz.entity.GenericData > SourceException: Unable to esablish a connection with the database. (Unable > to a > cquire a new connection from the pool). Rolling back transaction. > [java] ---- stack trace > --------------------------------------------------- > ------------ > [java] java.lang.Exception: Failure in storeAll operation: > org.ofbiz.entity > .GenericDataSourceException: Unable to esablish a connection with the > database. > (Unable to acquire a new connection from the pool). Rolling back > transaction. > [java] > org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(Transac > tionUtil.java:298) > [java] > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUti > l.java:245) > [java] > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:129 > 2) > [java] > org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.ja > va:282) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261 > ) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218 > ) > [java] > org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.jav > a:211) > [java] > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa > dContainer.java:267) > [java] > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: > 79) > [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261) > [java] org.ofbiz.base.start.Start.startServer(Start.java:310) > [java] org.ofbiz.base.start.Start.start(Start.java:314) > [java] org.ofbiz.base.start.Start.main(Start.java:397) > [java] > -------------------------------------------------------------------- > ------------ > [java] > [java] 2007-10-20 21:59:14,468 (main) [ > EntitySaxReader.java:267:ERROR] > > [java] ---- exception report > ---------------------------------------------- > ------------ > [java] An error occurred saving the data, rolling back transaction > (true) > [java] Exception: org.ofbiz.entity.GenericDataSourceException > [java] Message: Unable to esablish a connection with the database. > (Unable > to acquire a new connection from the pool) > [java] ---- stack trace > --------------------------------------------------- > ------------ > [java] org.ofbiz.entity.GenericDataSourceException: Unable to esablish > a co > nnection with the database. (Unable to acquire a new connection from the > pool) > [java] > org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:2 > 62) > [java] > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.jav > a:365) > [java] > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.jav > a:349) > [java] > org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:514) > [java] > org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:485) > [java] > org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(Generi > cHelperDAO.java:80) > [java] > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:124 > 5) > [java] > org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.ja > va:282) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261 > ) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218 > ) > [java] > org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.jav > a:211) > [java] > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa > dContainer.java:267) > [java] > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: > 79) > [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261) > [java] org.ofbiz.base.start.Start.startServer(Start.java:310) > [java] org.ofbiz.base.start.Start.start(Start.java:314) > [java] org.ofbiz.base.start.Start.main(Start.java:397) > [java] java.sql.SQLException: Unable to acquire a new connection from > the p > ool > [java] > org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionS > tatus(ManagedConnection.java:120) > [java] > org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConn > ection.java:55) > [java] > org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(Mana > gedDataSource.java:77) > [java] > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCP > ConnectionFactory.java:35) > [java] > org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(Connect > ionFactory.java:128) > [java] > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(Geronimo > TransactionFactory.java:92) > [java] > org.ofbiz.entity.transaction.TransactionFactory.getConnection(Transa > ctionFactory.java:95) > [java] > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFact > ory.java:73) > [java] > org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:2 > 59) > [java] > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.jav > a:365) > [java] > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.jav > a:349) > [java] > org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:514) > [java] > org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:485) > [java] > org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(Generi > cHelperDAO.java:80) > [java] > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:124 > 5) > [java] > org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.ja > va:282) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261 > ) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218 > ) > [java] > org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.jav > a:211) > [java] > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa > dContainer.java:267) > [java] > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: > 79) > [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261) > [java] org.ofbiz.base.start.Start.startServer(Start.java:310) > [java] org.ofbiz.base.start.Start.start(Start.java:314) > [java] org.ofbiz.base.start.Start.main(Start.java:397) > [java] Caused by: org.postgresql.util.PSQLException: FATAL: password > authen > tication failed for user "ofbiz" > [java] > org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Connec > tionFactoryImpl.java:275) > [java] > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conn > ectionFactoryImpl.java:94) > [java] > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFacto > ry.java:66) > [java] > org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Con > nection.java:125) > [java] > org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Con > nection.java:30) > [java] > org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Con > nection.java:18) > [java] > org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) > > [java] org.postgresql.Driver.makeConnection(Driver.java:382) > [java] org.postgresql.Driver.connect(Driver.java:260) > [java] > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Dri > verConnectionFactory.java:38) > [java] > org.apache.commons.dbcp.managed.LocalXAConnectionFactory.createConne > ction(LocalXAConnectionFactory.java:62) > [java] > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolabl > eConnectionFactory.java:294) > [java] > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericO > bjectPool.java:840) > [java] > org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionS > tatus(ManagedConnection.java:117) > [java] ... 24 more > [java] > -------------------------------------------------------------------- > ------------ > [java] > [java] 2007-10-20 21:59:14,468 (main) [ > TransactionUtil.java:262:ERROR] > > [java] ---- exception report > ---------------------------------------------- > ------------ > [java] [TransactionUtil.rollback] > [java] Exception: java.lang.Exception > [java] Message: Stack Trace > [java] ---- stack trace > --------------------------------------------------- > ------------ > [java] java.lang.Exception: Stack Trace > [java] > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUti > l.java:261) > [java] > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUti > l.java:243) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:268 > ) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218 > ) > [java] > org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.jav > a:211) > [java] > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa > dContainer.java:267) > [java] > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: > 79) > [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261) > [java] org.ofbiz.base.start.Start.startServer(Start.java:310) > [java] org.ofbiz.base.start.Start.start(Start.java:314) > [java] org.ofbiz.base.start.Start.main(Start.java:397) > [java] > -------------------------------------------------------------------- > ------------ > [java] > [java] 2007-10-20 21:59:14,468 (main) [ > TransactionUtil.java:272:INFO ] > [TransactionUtil.rollback] transaction rolled back > [java] 2007-10-20 21:59:14,468 (main) [ > EntityDataLoader.java:215:ERROR] > > [java] ---- exception report > ---------------------------------------------- > ------------ > [java] [install.loadData]: Error loading XML Resource > "file:/C:/Development > /Java/Eclipse/workspace/TestOfBiz/specialpurpose/cmssite/data/CmsSiteDemoDat > a.xm > l"; Error was: A transaction error occurred reading data > [java] Exception: org.xml.sax.SAXException > [java] Message: A transaction error occurred reading data > [java] ---- stack trace > --------------------------------------------------- > ------------ > [java] org.ofbiz.entity.GenericDataSourceException: Unable to esablish > a co > nnection with the database. (Unable to acquire a new connection from the > pool) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:269 > ) > [java] > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218 > ) > [java] > org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.jav > a:211) > [java] > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa > dContainer.java:267) > [java] > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: > 79) > [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261) > [java] org.ofbiz.base.start.Start.startServer(Start.java:310) > [java] org.ofbiz.base.start.Start.start(Start.java:314) > [java] org.ofbiz.base.start.Start.main(Start.java:397) > [java] > -------------------------------------------------------------------- > ------------ > [java] > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:279:INF > O ] =-=-=-=-=-=-= Here is a summary of the data load: > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/security/data/SecurityData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/CommonSecurityData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/CommonTypeData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/CountryCodeData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/CurrencyData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_AU.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_BR.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_ES.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_IT.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_NL.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_US.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_UK.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/GeoData_IRL.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/LanguageData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/UnitData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/common/data/PeriodData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/service/data/ScheduledServiceData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/service/data/ScheduledServices.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/service/data/ServiceSecurityData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/entityext/data/EntityExtTypeData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/entityext/data/EntityScheduledServices.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/entityext/data/EntityExtSecurityData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/workflow/data/WorkFlowSecurityData.xml > [java] 2007-10-20 21:59:14,468 (main) > [EntityDataLoadContainer.java:282:INF > O ] 00000 of 00000 from > file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr > amework/webtools/data/WebtoolsSecurityData.xml > > BUILD SUCCESSFUL > Total time: 3 minutes 58 seconds > C:\Development\Java\Eclipse\workspace\TestOfBiz> > > > >
