so you have created and can see a postgres DB by the name of TestOfBiz and you have independently verified that TestOfBiz has the userID and password. Postgresql is not considered as part of the installation. only the connection to it.
the other question I have since this is a test is why you did not leave the defualt DB in place then you would not have to worry about postgresql Brendan Vogt sent the following on 10/20/2007 5:24 PM: > 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> > >
