Hi guys,
I have been struggling for 3 days now to get OfBiz up and running. It's
been a huge mission!!! And I am really irritated.
I read that article from opentaps, did what they said. I created my
database as well. Then I ran ant run-install and still got 400 million
errors. Please can someone help me? I am thinking of ditching this whole
Java thing because if it was .NET I would've been up and running in no time.
I can't struggle like this forever.
Here are a part of my exceptions. It seems to be database issues.
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localpostgres"/>
</delegator>
<datasource name="localpostgres"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="public"
field-type-name="postgres"
check-on-start="true"
add-missing-on-start="true"
use-fk-initially-deferred="false"
alias-view-columns="false"
join-style="ansi"
use-binary-type-for-blob="true">
<!-- use this attribute to make the EntityListIterator more
effective for pgjdbc 7.5devel and later:
result-fetch-size="50"
-->
<read-data reader-name="seed"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://127.0.0.1/TestOfBiz"
jdbc-username="brendan"
jdbc-password="brendan"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"/>
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="java:comp/env/jdbc/localpostgres"
isolation-level="ReadCommitted"/>-->
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localpostgres" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->
<!-- <jndi-jdbc jndi-server-name="localweblogic"
jndi-name="PostgresDataSource"/> --> <!-- Weblogic Style JNDI name -->
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="jdbc/localpostgres" isolation-level="ReadCommitted"/> --> <!--
JRun4 Style JNDI name -->
<!-- <tyrex-dataSource dataSource-name="localpostgres"
isolation-level="ReadCommitted"/> -->
</datasource>
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: database
"TestO
fBiz" does not exist
[java]
org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(Con
nectionFactoryImpl.java:443)
[java]
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conn
ectionFactoryImpl.java:98)
[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-21 02:13:00,609 (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-21 02:13:00,609 (main) [
TransactionUtil.java:272:INFO ]
[TransactionUtil.rollback] transaction rolled back
[java] 2007-10-21 02:13:00,609 (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-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:279:INF
O ] =-=-=-=-=-=-= Here is a summary of the data load:
[java] 2007-10-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (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-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr
amework/webtools/data/WebtoolsSecurityData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr
amework/example/data/ExampleTypeData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/fr
amework/example/data/ExampleSecurityData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/party/data/PartyTypeData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/party/data/PartySecurityData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/securityext/data/SecurityExtData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/securityext/data/PasswordSecurityData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/ContentTypeData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/ContentOperationData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/MimeTypeData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/MimeTypeTemplate.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/DataCategoryData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/TemplateData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/ContentSecurityData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/content/data/MiscData.xml
[java] 2007-10-21 02:13:00,609 (main)
[EntityDataLoadContainer.java:282:INF
O ] 00000 of 00000 from
file:/C:/Development/Java/Eclipse/workspace/TestOfBiz/ap
plications/workeffort/data/WorkEffortTypeData.xml
BUILD SUCCESSFUL
Total time: 1 minute 22 seconds
C:\Development\Java\Eclipse\workspace\TestOfBiz>
