Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After installing pgAdmin success, open pgAdmin, setup connection:

Image Modified

Create 3 database schemas: ofbiz, ofbizolap, ofbiztenant

...

Code Block
languagexml
firstline1
linenumberstrue
<datasource name="localpostgres"
		helper-class="org.apache.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-order-by-nulls="true"
		result-fetch-size="50">	
	<read-data reader-name="tenant"/>
	<read-data reader-name="seed"/>
	<read-data reader-name="seed-initial"/>
	<read-data reader-name="demo"/>
	<read-data reader-name="ext"/>
	<read-data reader-name="ext-test"/>
	<read-data reader-name="ext-demo"/>
	<inline-jdbc
			jdbc-driver="org.postgresql.Driver"
			jdbc-uri="jdbc:postgresql://127.0.0.1:5433/ofbiz"
			jdbc-username="postgres"
			jdbc-password="postgres"
			isolation-level="ReadCommitted"
			pool-minsize="2"
			pool-maxsize="250"
			time-between-eviction-runs-millis="600000"/>
</datasource>
<datasource name="localpostolap"
		helper-class="org.apache.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"
		use-order-by-nulls="true">
	<read-data reader-name="tenant"/>
	<read-data reader-name="seed"/>
	<read-data reader-name="seed-initial"/>
	<read-data reader-name="demo"/>
	<read-data reader-name="ext"/>
	<read-data reader-name="ext-test"/>
	<read-data reader-name="ext-demo"/>
	<inline-jdbc
			jdbc-driver="org.postgresql.Driver"
			jdbc-uri="jdbc:postgresql://127.0.0.1:5433/ofbizolap"
			jdbc-username="postgres"
			jdbc-password="postgres"
			isolation-level="ReadCommitted"
			pool-minsize="2"
			pool-maxsize="250"
			time-between-eviction-runs-millis="600000"/>
</datasource>
<datasource name="localposttenant"
		helper-class="org.apache.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"
		use-order-by-nulls="true">
	<read-data reader-name="tenant"/>
	<read-data reader-name="seed"/>
	<read-data reader-name="seed-initial"/>
	<read-data reader-name="demo"/>
	<read-data reader-name="ext"/>
	<read-data reader-name="ext-test"/>
	<read-data reader-name="ext-demo"/>
	<inline-jdbc
			jdbc-driver="org.postgresql.Driver"
			jdbc-uri="jdbc:postgresql://127.0.0.1:5433/ofbiztenant"
			jdbc-username="postgres"
			jdbc-password="postgres"
			isolation-level="ReadCommitted"
			pool-minsize="2"
			pool-maxsize="250"
			time-between-eviction-runs-millis="600000"/>
</datasource>

 

Inside file \apache-ofbiz-16.11.02\build.gradle , add this line:

Code Block
firstline1
collapsetrue
compile 'org.postgresql:postgresql:42.1.1'

Image Added

 

 

Do I need download Gralde 4.0?

...