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> |
Why don't you try it with derby OOTB first and see if that works - THEN try and change your db?
Cheers, Tim -- Tim Ruppert HotWax Media o:801.649.6594 f:801.649.6595 On Oct 20, 2007, at 6:24 PM, Brendan Vogt wrote:
smime.p7s (3K) Download Attachment |
In reply to this post by Brendan Vogt
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> > > |
In reply to this post by Tim Ruppert
I don't have derby. I don't want to install to many databases. I currently
have SQL Server 2005, Access and Postgres. _____ From: Tim Ruppert [mailto:[hidden email]] Sent: Sunday, October 21, 2007 2:45 AM To: [hidden email] Subject: Re: build.xml Still Not Working Importance: High Why don't you try it with derby OOTB first and see if that works - THEN try and change your db? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Oct 20, 2007, at 6:24 PM, Brendan Vogt wrote: 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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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> |
It's built in when you download the first version - try that first and see if you can get that working - then go ahead and change it. Â No installation necessary.
Cheers, Tim -- Tim Ruppert HotWax Media o:801.649.6594 f:801.649.6595 On Oct 20, 2007, at 6:51 PM, Brendan Vogt wrote:
smime.p7s (3K) Download Attachment |
In reply to this post by BJ Freeman
The only database that I had after installation of Postgres was the postgres
database. No other databases. " 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." Yes I can see my database and user in pgAdmin III. How must I check then? -----Original Message----- From: BJ Freeman [mailto:[hidden email]] Sent: Sunday, October 21, 2007 2:48 AM To: [hidden email] Subject: Re: build.xml Still Not Working 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 > 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" > > <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" > --> <!-- 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 > 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 > > > 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 > 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> > > |
In reply to this post by Tim Ruppert
Is the derby built in?? So this means that I must not download the Derby
database like I did with Postgres? _____ From: Tim Ruppert [mailto:[hidden email]] Sent: Sunday, October 21, 2007 2:55 AM To: [hidden email] Subject: Re: build.xml Still Not Working It's built in when you download the first version - try that first and see if you can get that working - then go ahead and change it. No installation necessary. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Oct 20, 2007, at 6:51 PM, Brendan Vogt wrote: I don't have derby. I don't want to install to many databases. I currently have SQL Server 2005, Access and Postgres. _____ From: Tim Ruppert [mailto:[hidden email]] Sent: Sunday, October 21, 2007 2:45 AM To: [hidden email] Subject: Re: build.xml Still Not Working Importance: High Why don't you try it with derby OOTB first and see if that works - THEN try and change your db? Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On Oct 20, 2007, at 6:24 PM, Brendan Vogt wrote: 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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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> |
In reply to this post by Brendan Vogt
i suggest you take Tim's advise and rename your current entityengine.xml
to something else and put the orinal in it's place. As Tim said Derby is part of the installation for OFBIZ. Brendan Vogt sent the following on 10/20/2007 5:55 PM: > The only database that I had after installation of Postgres was the postgres > database. No other databases. > > " 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." Yes I can see my database and user in pgAdmin III. How must I > check then? > > > -----Original Message----- > From: BJ Freeman [mailto:[hidden email]] > Sent: Sunday, October 21, 2007 2:48 AM > To: [hidden email] > Subject: Re: build.xml Still Not Working > > 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> >> >> > > > > |
In reply to this post by Brendan Vogt
Ofbiz is OOTB means it has it own DB built in ready to go
just compile initialize and run. Brendan Vogt sent the following on 10/20/2007 5:58 PM: > Is the derby built in?? So this means that I must not download the Derby > database like I did with Postgres? > > > > _____ > > From: Tim Ruppert [mailto:[hidden email]] > Sent: Sunday, October 21, 2007 2:55 AM > To: [hidden email] > Subject: Re: build.xml Still Not Working > > > > It's built in when you download the first version - try that first and see > if you can get that working - then go ahead and change it. No installation > necessary. > > > > > > Cheers, > > Tim > > -- > > Tim Ruppert > > HotWax Media > > http://www.hotwaxmedia.com > > > > o:801.649.6594 > > f:801.649.6595 > > > > > > > > On Oct 20, 2007, at 6:51 PM, Brendan Vogt wrote: > > > > > > I don't have derby. I don't want to install to many databases. I currently > > have SQL Server 2005, Access and Postgres. > > > > > > > > _____ > > > > From: Tim Ruppert [mailto:[hidden email]] > > Sent: Sunday, October 21, 2007 2:45 AM > > To: [hidden email] > > Subject: Re: build.xml Still Not Working > > Importance: High > > > > > > > > Why don't you try it with derby OOTB first and see if that works - THEN try > > and change your db? > > > > > > > > > > > > Cheers, > > > > Tim > > > > -- > > > > Tim Ruppert > > > > HotWax Media > > > > http://www.hotwaxmedia.com > > > > > > > > o:801.649.6594 > > > > f:801.649.6595 > > > > > > > > > > > > > > > > On Oct 20, 2007, at 6:24 PM, Brendan Vogt wrote: > > > > > > > > > > > > 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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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 <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> > > > > > > > > > > > > > > |
In reply to this post by Brendan Vogt
Brendan Vogt wrote:
> Is the derby built in?? So this means that I must not download the Derby > database like I did with Postgres? > This is right: the only one real prerequisite to run OFBiz out of the box is a Java 1.5 jdk: all the other default stuff (database, ant, configuration files etc...) are already setup for you. So checkout a clean copy from svn and then read the README file (that will just tell you to run the "ant run-install" command. Jacopo |
In reply to this post by Brendan Vogt
Brendan
Did you do the part where you're supposed to connect to it with pgAdmin? If you did, and you can, you most likely did not name the database correctly or the entry in entity.xml does not match what you set up in postgres. Here is a step by step. Open the My Computer - Manage - Services (or do it from the control panel) and verify that postgres is running. If not start it. Select pgAdmin III from Start-Programs-PostgreSQLxxx Right click on the database and select "Connect". Then expand the databases you see. If you have an opentaps or obfiz database, select it (them) and then right click and select "Delete/Drop" Then expand "Login Roles". If you have an ofbis user, right click on it and enter "ofbiz" in the password field. If you don't have an ofbiz user, create one with ofbiz as the password. Make sure you check the can create databases and can create roles. Then, right click on "DataBases" and select "New Database" Enter the following in order in the resulting dialog: ofbiz <disabled field> ofbiz UTF-8 <leave it blank> pg_default Click the Ok button. Close up pgAdmin Open ...framework\entity\config\entityengine.xml with wordpad.exe Go to line 52 and make sure the tag looks like this: <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="localderby"/> </delegator> Go to line 319 and make sure the tag there looks like this: <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" result-fetch-size="50" use-binary-type-for-blob="true"> <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/ofbiz" jdbc-username="ofbiz" jdbc-password="ofbiz" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> </datasource> Save, and exit get a command prompt in the ofbiz directory and type ant-run-install -----Original Message----- From: Brendan Vogt [mailto:[hidden email]] Sent: Saturday, October 20, 2007 5:25 PM To: [hidden email] Subject: build.xml Still Not Working Importance: High 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> |
Brendan
I missed all the other derby advice you were given. I agree completely. Start with the built in derby. No fuss no muss. Just delete or rename the entityengine.xml and do an svn update. Then, without touching anything, do ant run-install Skip -----Original Message----- From: skip@theDevers [mailto:[hidden email]] Sent: Sunday, October 21, 2007 12:08 AM To: [hidden email] Subject: RE: build.xml Still Not Working Brendan Did you do the part where you're supposed to connect to it with pgAdmin? If you did, and you can, you most likely did not name the database correctly or the entry in entity.xml does not match what you set up in postgres. Here is a step by step. Open the My Computer - Manage - Services (or do it from the control panel) and verify that postgres is running. If not start it. Select pgAdmin III from Start-Programs-PostgreSQLxxx Right click on the database and select "Connect". Then expand the databases you see. If you have an opentaps or obfiz database, select it (them) and then right click and select "Delete/Drop" Then expand "Login Roles". If you have an ofbis user, right click on it and enter "ofbiz" in the password field. If you don't have an ofbiz user, create one with ofbiz as the password. Make sure you check the can create databases and can create roles. Then, right click on "DataBases" and select "New Database" Enter the following in order in the resulting dialog: ofbiz <disabled field> ofbiz UTF-8 <leave it blank> pg_default Click the Ok button. Close up pgAdmin Open ...framework\entity\config\entityengine.xml with wordpad.exe Go to line 52 and make sure the tag looks like this: <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="localderby"/> </delegator> Go to line 319 and make sure the tag there looks like this: <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" result-fetch-size="50" use-binary-type-for-blob="true"> <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/ofbiz" jdbc-username="ofbiz" jdbc-password="ofbiz" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> </datasource> Save, and exit get a command prompt in the ofbiz directory and type ant-run-install -----Original Message----- From: Brendan Vogt [mailto:[hidden email]] Sent: Saturday, October 20, 2007 5:25 PM To: [hidden email] Subject: build.xml Still Not Working Importance: High 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> |
In reply to this post by SkipDever
Thanks Skip. What's next? About 750 tables were generated.
Is there a log file that I can go and check to see for errors? My command prompt does not show everything. -----Original Message----- From: skip@theDevers [mailto:[hidden email]] Sent: Sunday, October 21, 2007 9:08 AM To: [hidden email] Subject: RE: build.xml Still Not Working Brendan Did you do the part where you're supposed to connect to it with pgAdmin? If you did, and you can, you most likely did not name the database correctly or the entry in entity.xml does not match what you set up in postgres. Here is a step by step. Open the My Computer - Manage - Services (or do it from the control panel) and verify that postgres is running. If not start it. Select pgAdmin III from Start-Programs-PostgreSQLxxx Right click on the database and select "Connect". Then expand the databases you see. If you have an opentaps or obfiz database, select it (them) and then right click and select "Delete/Drop" Then expand "Login Roles". If you have an ofbis user, right click on it and enter "ofbiz" in the password field. If you don't have an ofbiz user, create one with ofbiz as the password. Make sure you check the can create databases and can create roles. Then, right click on "DataBases" and select "New Database" Enter the following in order in the resulting dialog: ofbiz <disabled field> ofbiz UTF-8 <leave it blank> pg_default Click the Ok button. Close up pgAdmin Open ...framework\entity\config\entityengine.xml with wordpad.exe Go to line 52 and make sure the tag looks like this: <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="localderby"/> </delegator> Go to line 319 and make sure the tag there looks like this: <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" result-fetch-size="50" use-binary-type-for-blob="true"> <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/ofbiz" jdbc-username="ofbiz" jdbc-password="ofbiz" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> </datasource> Save, and exit get a command prompt in the ofbiz directory and type ant-run-install -----Original Message----- From: Brendan Vogt [mailto:[hidden email]] Sent: Saturday, October 20, 2007 5:25 PM To: [hidden email] Subject: build.xml Still Not Working Importance: High 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> |
Yep, go have a look at runtime\logs. console.log and ofbiz.log are your
friend. Note that what I usually do is: ant run-install > install.txt In this way, I can look at the output carefully. That way, you can carefully look at the results. Some compile errors will still result in "BUILD SUCCESSFUL". Skip -----Original Message----- From: Brendan Vogt [mailto:[hidden email]] Sent: Tuesday, October 23, 2007 10:22 AM To: [hidden email] Subject: RE: build.xml Still Not Working Thanks Skip. What's next? About 750 tables were generated. Is there a log file that I can go and check to see for errors? My command prompt does not show everything. -----Original Message----- From: skip@theDevers [mailto:[hidden email]] Sent: Sunday, October 21, 2007 9:08 AM To: [hidden email] Subject: RE: build.xml Still Not Working Brendan Did you do the part where you're supposed to connect to it with pgAdmin? If you did, and you can, you most likely did not name the database correctly or the entry in entity.xml does not match what you set up in postgres. Here is a step by step. Open the My Computer - Manage - Services (or do it from the control panel) and verify that postgres is running. If not start it. Select pgAdmin III from Start-Programs-PostgreSQLxxx Right click on the database and select "Connect". Then expand the databases you see. If you have an opentaps or obfiz database, select it (them) and then right click and select "Delete/Drop" Then expand "Login Roles". If you have an ofbis user, right click on it and enter "ofbiz" in the password field. If you don't have an ofbiz user, create one with ofbiz as the password. Make sure you check the can create databases and can create roles. Then, right click on "DataBases" and select "New Database" Enter the following in order in the resulting dialog: ofbiz <disabled field> ofbiz UTF-8 <leave it blank> pg_default Click the Ok button. Close up pgAdmin Open ...framework\entity\config\entityengine.xml with wordpad.exe Go to line 52 and make sure the tag looks like this: <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="localderby"/> </delegator> Go to line 319 and make sure the tag there looks like this: <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" result-fetch-size="50" use-binary-type-for-blob="true"> <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/ofbiz" jdbc-username="ofbiz" jdbc-password="ofbiz" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250"/> </datasource> Save, and exit get a command prompt in the ofbiz directory and type ant-run-install -----Original Message----- From: Brendan Vogt [mailto:[hidden email]] Sent: Saturday, October 20, 2007 5:25 PM To: [hidden email] Subject: build.xml Still Not Working Importance: High 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> |
Free forum by Nabble | Edit this page |