Steps of configaretion of postgresql with Ofbiz

[dhiraj.g]

Hi all,
Please provide the steps of configaretion of postgresql with Ofbiz



Thanks
Dhiraj
9990220686

[S.Hage]

have a look at this
http://blogs.oracle.com/robertlor/entry/ofbiz_and_postgresql 

[Paul Foxworthy]

Hello Dhiraj,

In future, *please* don't use the Ofbiz bug tracking system, Jira, for this sort of problem.

Your problem is that the line

field-type-name="postnew"

shouldn't have a name of your choice, but rather a name that identifies a DBMS known to Ofbiz, in order to find the range of data types supported by that system particular database. See

https://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/entity/config/entityengine.xml?hb=true#to115

for a list of values understood by out-of-the-box Ofbiz.

So in your case, you want the word "postgres" at this point.

It was the method getEntityFieldType that threw the null pointer exception, so that was a clue to the problem.

Regards

Paul Foxworthy

[Paul Foxworthy]

Hello Dhiraj,

I've looked a bit more closely, and there is the option of postnew, sorry for misleading you in my previous message. But you should use only one of postgres or postnew, there's no reason to mix them.

Regards

Paul Foxworthy

Paul Foxworthy wrote

Hello Dhiraj,

In future, *please* don't use the Ofbiz bug tracking system, Jira, for this sort of problem.

Your problem is that the line

field-type-name="postnew"

shouldn't have a name of your choice, but rather a name that identifies a DBMS known to Ofbiz, in order to find the range of data types supported by that system particular database. See

https://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/entity/config/entityengine.xml?hb=true#to115

for a list of values understood by out-of-the-box Ofbiz.

So in your case, you want the word "postgres" at this point.

It was the method getEntityFieldType that threw the null pointer exception, so that was a clue to the problem.

Regards

Paul Foxworthy