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:[EMAIL PROTECTED] Sent: Sunday, October 21, 2007 2:45 AM To: [email protected] 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>
