PostGIS with OfBiz

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

PostGIS with OfBiz

Deepak Panwar
Hi, 

Did anybody tried the postGIS extension with OfBiz? 

I have created a Geometry type column prod_location in Product Entity, and manually altered the Postgres DB with new Column and extensions. 

Ofbiz Version: apache-ofbiz-13.07.03 

I followed the steps from https://cwiki.apache.org/confluence/display/OFBIZ/Connecting+OFBiz+to+PostGIS+spatially-enabled+database but when SQL Query is run on Product entity, I am getting following exception : 


  [java] 2016-12-08 11:43:23,524 |-0.0.0.0-8080-exec-1 |SqlJdbcUtil                   |W| JdbcValueHandler not found for java-type geometry, falling back on switch statement. Entity = Product, field = prodLocation.
     [java] 2016-12-08 11:43:23,525 |-0.0.0.0-8080-exec-1 |EntityListIterator            |W| Warning: auto-closed EntityListIterator because of exception: org.ofbiz.entity.GenericNotImplementedException: Java type geometry not currently supported. Sorry. 
     [java] 2016-12-08 11:43:23,525 |-0.0.0.0-8080-exec-1 |EntityListIterator            |W| Product] has already been closed, not closing again. 
     [java] 2016-12-08 11:43:23,525 |-0.0.0.0-8080-exec-1 |GenericDelegator              |E| Failure in findByCondition operation for entity [Product]: org.ofbiz.entity.GenericEntityException: Error creating GenericValue (Java type geometry not currently supported. Sorry.). Rolling back transaction. 
     [java] org.ofbiz.entity.GenericEntityException: Error creating GenericValue (Java type geometry not currently supported. Sorry.) 
     [java] at org.ofbiz.entity.util.EntityListIterator.getCompleteList(EntityListIterator.java:454) ~[ofbiz-entity-test.jar:?] 
     [java] at org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1724) [ofbiz-entity-test.jar:?] 
     [java] at restcomponent.PingResource.sayHello(PingResource.java:88) [restcomponent.jar:?] 
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_111] 
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_111] 
     [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_111] 
     [java] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_111] 


With best regards,

Deepak Panwar
----------------------
"Effort is important, but knowing where to make an effort makes all the difference!"


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users