PostGIS Functions not working using hibernate in java?

Question

I need to execute select ST_AsText(column_name) from table using hibernate createSQlQuery().

When i executed that query, it fires an exception.

But when i execute the same query using simple JDBC or in my PGAdmin browser, the query works.

Below is my query:

select st_astext(linkPoints) from linkRoute

Exception:

SEVERE: ERROR: relation "linkroute" does not exist

Mapping File

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="com.lnt.utility.pojo.linkRoute" table="link_route">
    <id name="Id" column="id">
    <generator class="assigned" />
  </id>
    <property name="linkName" column="link_name"/>
    <property name="distance" column="distance"/>
    <property name="idNo" column="idno"/>
    <property name="speed" column="speed"/>
    <property name="linkPoints" column="link_points"/>

</class>
</hibernate-mapping>

Pls help

Gerald Baretto · Accepted Answer · 2014-01-02 13:50:50Z

1

Hibernate provide a createSQLQuery method to let you call your native SQL statement directly.

I hope you should be able to work with your query using nativequery else you should go for Hibernate Spatial.

Please find the link for more information on hibernate native query tutorial. Hope this helps.

answered Jan 2, 2014 at 13:50

Gerald Baretto

3992 gold badges5 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostGIS Functions not working using hibernate in java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related