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>
