<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:#073763"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">Hi, </span><br></div><div class="gmail_quote"><div dir="ltr"><div style="font-family:verdana,sans-serif;font-size:small;color:rgb(7,55,99)"><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">Did anybody tried the <span class="m_-1278609092904375398gmail-bold m_-1278609092904375398gmail-highlight m_-1278609092904375398gmail-search-highlight" style="font-weight:bold;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(255,255,153)">postGIS</span> extension with OfBiz? </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">I have created a Geometry type column prod_location in Product Entity, and manually altered the Postgres DB with new Column and extensions. </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">Ofbiz Version: apache-ofbiz-13.07.03 </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">I followed the steps from </span><a href="https://cwiki.apache.org/confluence/display/OFBIZ/Connecting+OFBiz+to+PostGIS+spatially-enabled+database" rel="nofollow" style="font-size:13.44px;color:rgb(85,26,139);font-family:verdana,geneva,helvetica,arial,sans-serif" target="_blank"><span style="color:inherit">https://cwiki.apache.org/<wbr>confluence/display/OFBIZ/<wbr>Connecting+OFBiz+to+<span class="m_-1278609092904375398gmail-bold m_-1278609092904375398gmail-highlight m_-1278609092904375398gmail-search-highlight" style="font-weight:bold;color:inherit;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(255,255,153)">PostGIS</span>+<wbr>spatially-enabled+database</span></a><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"> but when SQL Query is run on Product entity, I am getting following exception : </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">  [java] 2016-12-08 11:43:23,524 |-0.0.0.0-8080-exec-1 |SqlJdbcUtil                   |W| </span><b style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">JdbcValueHandler not found for java-type geometry, falling back on switch statement. Entity = Product, field = prodLocation.</b><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [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.<wbr>GenericNotImplementedException<wbr>: Java type geometry not currently supported. Sorry. </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [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. </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [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.<wbr>GenericEntityException: Error creating GenericValue (Java type geometry not currently supported. Sorry.). Rolling back transaction. </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] org.ofbiz.entity.<wbr>GenericEntityException: Error creating GenericValue (Java type geometry not currently supported. Sorry.) </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] at org.ofbiz.entity.util.<wbr>EntityListIterator.<wbr>getCompleteList(<wbr>EntityListIterator.java:454) ~[ofbiz-entity-test.jar:?] </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] at org.ofbiz.entity.<wbr>GenericDelegator.findList(<wbr>GenericDelegator.java:1724) [ofbiz-entity-test.jar:?] </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] at restcomponent.PingResource.<wbr>sayHello(PingResource.java:88) [restcomponent.jar:?] </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] at sun.reflect.<wbr>NativeMethodAccessorImpl.<wbr>invoke0(Native Method) ~[?:1.8.0_111] </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] at sun.reflect.<wbr>NativeMethodAccessorImpl.<wbr>invoke(Unknown Source) ~[?:1.8.0_111] </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] at sun.reflect.<wbr>DelegatingMethodAccessorImpl.<wbr>invoke(Unknown Source) ~[?:1.8.0_111] </span><br style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px"><span style="color:rgb(0,0,0);font-family:verdana,geneva,helvetica,arial,sans-serif;font-size:13.44px">     [java] at java.lang.reflect.Method.<wbr>invoke(Unknown Source) ~[?:1.8.0_111] </span><br></div><br clear="all"><div><div class="m_-1278609092904375398gmail_signature"><div dir="ltr"><font color="#663366" face="'comic sans ms', sans-serif"><b><br></b></font>With best regards,<div><br>Deepak Panwar<div>----------------------<br>"Effort is important, but knowing where to make an effort makes all the difference!"<br></div></div></div></div></div>
</div>
</div><br></div>