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 [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
