[postgis-users] 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!"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161209/89fee8dc/attachment.html>