Posted by
Vinay Agarwal on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Newbie-Installation-Website-URL-tp136564p136565.html
Hello,
I am trying to get OFBiz working with PostgreSQL but have been unsuccessful
so far. I would appreciate any help. Here are the details.
SYSTEM: Win XP/SP2, OFBiz 6140, Ant 1.6.5, Java SDK 1.4.2_10
DOCUMENTS: Basic OFBiz Production Setup by: David E. Jones and Wiki Online
Administration Manual Database Setup Notes.
STEPS:
1. Installed PostgreSQL version 8.0.4, as Service,
Acct/Pass postgres/postgres
Port 5432
Superuser admin
Pass ofbiz
Installs ok, can access through pgAdmin.
2. Checked driver in ${ofbiz install dir}/framework/entity/lib/jdbc to be
postgresql-8.0-311.jdbc3.jar. Left is unchanged.
3. In ${ofbiz install dir}/framework/entity/config/entityengine.xml file,
changed
a. In <datasource name="localpostgres"
changed ------------
jdbc-username="ofbiz"
jdbc-password="ofbiz"
to -----------------------
jdbc-username="admin"
jdbc-password="ofbiz"
b. Changed------------------------------------------------------------
<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="localderby"/>
<group-map group-name="org.ofbiz.odbc"
datasource-name="localderbyodbc"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
<group-map group-name="org.ofbiz.odbc"
datasource-name="localderbyodbc"/>
</delegator>
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
</delegator>
<delegator name="other" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
to-----------------------------------------------------------------
<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"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
<delegator name="other" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
---------------------------------------------------------------------
4. To seed the data, set JAVA_HOME and ANT_HOME, changed command prompt
directory to ${ofbiz install dir} and ran
ant run-install
The output is very long and includes the following errors:
[java] 8250 (main) [UtilXml.java:634:ERROR] XmlFileLoader: File
C:/Server/ofbiz_6140/applications/accounting/entitydef/entitymodel.xml
process error. Line: 2398. Error message: cvc-complex-type.2.3: Element
'entity' cannot have character [children], because the type's content type
is element-only.
[java] 8250 (main) [UtilXml.java:634:ERROR] XmlFileLoader: File
C:/Server/ofbiz_6140/applications/accounting/entitydef/entitymodel.xml
process error. Line: 2398. Error message: cvc-complex-type.2.3: Element
'entity' cannot have character [children], because the type's content type
is element-only.
[java] 85829 (main) [XAConnectionFactory.java:371:ERROR] Can't get an
XAConnection
[java] org.postgresql.util.PSQLException: The connection attempt failed.
[java]at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa
ctoryImpl.java:136)
In the end, no database is added.
What am I doing wrong? I would appreciate any guidance.
Regards,
Vinay Agarwal
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users