Hibernate Spatial › Hibernate Spatial - Users

Supporting 3D MultiLineStrings

4 messages Options
Embed this post
Permalink
Jo

Supporting 3D MultiLineStrings

Reply Threaded More More options
Print post
Permalink
Hi,

is there a support of 3D MultiLineStrings?

I want to upgrade a database with 2D MultiLineStrings by
adding the z-value but hibernate abords with an error (log):

WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null
ERROR JDBCExceptionReporter:101 - Unknown type:

Exception:
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2231)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
...
Caused by: java.sql.SQLException: Unknown type: ...
at org.postgis.PGgeometry.setValue(PGgeometry.java:38)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:423)

Any idea?

Thanks,

Jo


_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Karel Maesen

Re: Supporting 3D MultiLineStrings

Reply Threaded More More options
Print post
Permalink
Hi Jo,

3D multilinestrings are supported.

Could you post the complete stacktrace together with a 3D  
multilinestring that triggers the exception? On the basis of that I  
can check what is going on.

Regards,

Karel Maesen


On 28 Apr 2009, at 11:47, [hidden email] wrote:

> Hi,
>
> is there a support of 3D MultiLineStrings?
>
> I want to upgrade a database with 2D MultiLineStrings by
> adding the z-value but hibernate abords with an error (log):
>
> WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null
> ERROR JDBCExceptionReporter:101 - Unknown type:
>
> Exception:
> org.hibernate.exception.GenericJDBCException: could not execute query
> at  
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
> SQLStateConverter.java:126)
> at org.hibernate.exception.SQLStateConverter.convert
> (SQLStateConverter.java:114)
> at org.hibernate.exception.JDBCExceptionHelper.convert
> (JDBCExceptionHelper.java:66)
> at org.hibernate.loader.Loader.doList(Loader.java:2231)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
> ...
> Caused by: java.sql.SQLException: Unknown type: ...
> at org.postgis.PGgeometry.setValue(PGgeometry.java:38)
> at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject
> (AbstractJdbc2Connection.java:423)
>
> Any idea?
>
> Thanks,
>
> Jo
>
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Jo

Re: Supporting 3D MultiLineStrings

Reply Threaded More More options
Print post
Permalink
Hi,

there's the Exception:
***
13:16:58,890  WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null
13:16:58,906 ERROR JDBCExceptionReporter:101 - Unknown type: 01050000A0EB7A00000100000001020000800200000022D63CA65FED4941C183645D542254410080CA54897A7640E20F521967ED49419556EE3F5422544100C0E9DE899A7640
org.hibernate.exception.GenericJDBCException: could not execute query
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2231)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
        at org.hibernate.loader.Loader.list(Loader.java:2120)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at SlopeCalculator.slopeCalc(SlopeCalculator.java:184)
        at SlopeCalculator.main(SlopeCalculator.java:71)
Caused by: java.sql.SQLException: Unknown type: 01050000A0EB7A00000100000001020000800200000022D63CA65FED4941C183645D542254410080CA54897A7640E20F521967ED49419556EE3F5422544100C0E9DE899A7640
        at org.postgis.PGgeometry.setValue(PGgeometry.java:38)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:423)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:2486)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:2491)
        at org.hibernatespatial.AbstractDBGeometryType.nullSafeGet(AbstractDBGeometryType.java:126)
        at org.hibernatespatial.GeometryUserType.nullSafeGet(GeometryUserType.java:170)
        at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:128)
        at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
        at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2124)
        at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)
        at org.hibernate.loader.Loader.getRow(Loader.java:1230)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
        at org.hibernate.loader.Loader.doQuery(Loader.java:724)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.doList(Loader.java:2228)
        ... 9 more
***

Kind regards,

Jo

Karel Maesen wrote:
Hi Jo,

3D multilinestrings are supported.

Could you post the complete stacktrace together with a 3D  
multilinestring that triggers the exception? On the basis of that I  
can check what is going on.

Regards,

Karel Maesen


On 28 Apr 2009, at 11:47, news_acc@public-files.de wrote:

> Hi,
>
> is there a support of 3D MultiLineStrings?
>
> I want to upgrade a database with 2D MultiLineStrings by
> adding the z-value but hibernate abords with an error (log):
>
> WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null
> ERROR JDBCExceptionReporter:101 - Unknown type:
>
> Exception:
> org.hibernate.exception.GenericJDBCException: could not execute query
> at  
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
> SQLStateConverter.java:126)
> at org.hibernate.exception.SQLStateConverter.convert
> (SQLStateConverter.java:114)
> at org.hibernate.exception.JDBCExceptionHelper.convert
> (JDBCExceptionHelper.java:66)
> at org.hibernate.loader.Loader.doList(Loader.java:2231)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
> ...
> Caused by: java.sql.SQLException: Unknown type: ...
> at org.postgis.PGgeometry.setValue(PGgeometry.java:38)
> at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject
> (AbstractJdbc2Connection.java:423)
>
> Any idea?
>
> Thanks,
>
> Jo
>
>
> _______________________________________________
> hibernatespatial-users mailing list
> hibernatespatial-users@lists.hibernatespatial.org
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
hibernatespatial-users@lists.hibernatespatial.org
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Karel Maesen

Re: Supporting 3D MultiLineStrings

Reply Threaded More More options
Print post
Permalink
Jo,

Could you also post the code of the method that throws this  
exception? And the version of the Postgis library (postgis.jar). I  
suspect that it is not a bug in Hibernate Spatial, but either a  
misconfiguration or a problem in the way Hibernate is used in your code.

Regards,

Karel


On 29 Apr 2009, at 13:26, Jo wrote:

>
> Hi,
>
> there's the Exception:
> ***
> 13:16:58,890  WARN JDBCExceptionReporter:100 - SQL Error: 0,  
> SQLState: null
> 13:16:58,906 ERROR JDBCExceptionReporter:101 - Unknown type:
> 01050000A0EB7A00000100000001020000800200000022D63CA65FED4941C183645D54
> 2254410080CA54897A7640E20F521967ED49419556EE3F5422544100C0E9DE899A7640
> org.hibernate.exception.GenericJDBCException: could not execute query
> at
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
> SQLStateConverter.java:126)
> at
> org.hibernate.exception.SQLStateConverter.convert
> (SQLStateConverter.java:114)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert
> (JDBCExceptionHelper.java:66)
> at org.hibernate.loader.Loader.doList(Loader.java:2231)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
> at org.hibernate.loader.Loader.list(Loader.java:2120)
> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.list
> (QueryTranslatorImpl.java:361)
> at
> org.hibernate.engine.query.HQLQueryPlan.performList
> (HQLQueryPlan.java:196)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
> at SlopeCalculator.slopeCalc(SlopeCalculator.java:184)
> at SlopeCalculator.main(SlopeCalculator.java:71)
> Caused by: java.sql.SQLException: Unknown type:
> 01050000A0EB7A00000100000001020000800200000022D63CA65FED4941C183645D54
> 2254410080CA54897A7640E20F521967ED49419556EE3F5422544100C0E9DE899A7640
> at org.postgis.PGgeometry.setValue(PGgeometry.java:38)
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getObject
> (AbstractJdbc2Connection.java:423)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject
> (AbstractJdbc2ResultSet.java:2486)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject
> (AbstractJdbc2ResultSet.java:2491)
> at
> org.hibernatespatial.AbstractDBGeometryType.nullSafeGet
> (AbstractDBGeometryType.java:126)
> at
> org.hibernatespatial.GeometryUserType.nullSafeGet
> (GeometryUserType.java:170)
> at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:128)
> at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.hydrate
> (AbstractEntityPersister.java:2124)
> at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)
> at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)
> at org.hibernate.loader.Loader.getRow(Loader.java:1230)
> at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
> at org.hibernate.loader.Loader.doQuery(Loader.java:724)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
> (Loader.java:259)
> at org.hibernate.loader.Loader.doList(Loader.java:2228)
> ... 9 more
> ***
>
> Kind regards,
>
> Jo
>
>
> Karel Maesen wrote:
>>
>> Hi Jo,
>>
>> 3D multilinestrings are supported.
>>
>> Could you post the complete stacktrace together with a 3D
>> multilinestring that triggers the exception? On the basis of that I
>> can check what is going on.
>>
>> Regards,
>>
>> Karel Maesen
>>
>>
>> On 28 Apr 2009, at 11:47, [hidden email] wrote:
>>
>>> Hi,
>>>
>>> is there a support of 3D MultiLineStrings?
>>>
>>> I want to upgrade a database with 2D MultiLineStrings by
>>> adding the z-value but hibernate abords with an error (log):
>>>
>>> WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: null
>>> ERROR JDBCExceptionReporter:101 - Unknown type:
>>>
>>> Exception:
>>> org.hibernate.exception.GenericJDBCException: could not execute  
>>> query
>>> at
>>> org.hibernate.exception.SQLStateConverter.handledNonSpecificExceptio
>>> n(
>>> SQLStateConverter.java:126)
>>> at org.hibernate.exception.SQLStateConverter.convert
>>> (SQLStateConverter.java:114)
>>> at org.hibernate.exception.JDBCExceptionHelper.convert
>>> (JDBCExceptionHelper.java:66)
>>> at org.hibernate.loader.Loader.doList(Loader.java:2231)
>>> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:
>>> 2125)
>>> ...
>>> Caused by: java.sql.SQLException: Unknown type: ...
>>> at org.postgis.PGgeometry.setValue(PGgeometry.java:38)
>>> at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject
>>> (AbstractJdbc2Connection.java:423)
>>>
>>> Any idea?
>>>
>>> Thanks,
>>>
>>> Jo
>>>
>>>
>>> _______________________________________________
>>> hibernatespatial-users mailing list
>>> [hidden email]
>>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
>>> hibernatespatial-users
>>
>> _______________________________________________
>> hibernatespatial-users mailing list
>> [hidden email]
>> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
>> hibernatespatial-users
>>
>>
>
> --
> View this message in context: http://n2.nabble.com/Supporting-3D- 
> MultiLineStrings-tp2732407p2740024.html
> Sent from the Hibernate Spatial - Users mailing list archive at  
> Nabble.com.
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Free Embeddable Forum Powered by Nabble Help