[nhusers] Problem when insert geometry using NHibernate Spatial and Postgis

Discussion:

Đạt Ý Đặng Huỳnh

2018-10-01 08:08:33 UTC

I am using NHibernate v 5.13, NHibernate.Spatial.Postgis v5.0, Npgsql
v4.0.3 when i try insert a record into my __layer table the application
thrown an exception below.

NHibernate.Exceptions.GenericADOException
HResult=0x80131500
Message=could not insert: [Layer][SQL: INSERT INTO __Layer (ServiceId,
Name, XmlMapping, TableName, FilterExpression, State, SpatialReference,
Type, Drawing, VisibleRange, IsEditable, IsVersioned,
SignalRIsAddEventEnabled, SignalRIsUpdateEventEnabled,
SignalRIsDeleteEventEnabled, PubNubIsAddEventEnabled,
PubNubIsUpdateEventEnabled, PubNubIsDeleteEventEnabled,
AzureIsAddEventEnabled, AzuresUpdateEventEnabled,
AzureIsDeleteEventEnabled, IsODataEnabled, HasAttachments, IsSupportTime,
TimeFieldId, MinDate, MaxDate, Extent, PopupType, PopupContent, MinScale,
MaxScale, RelationshipsJson) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select
lastval()]
Source=BlueSpatial.Core
StackTrace:
at BlueSpatial.ProgressHub.AddLayerFromFile(String filePath, String
tableName, Int32 serviceId, String connectionHubId, Boolean isODataEnabled)
in
D:\Source\WorkSpace\CloudSpatial\BlueSpatial_Dev\BlueSpatial.Core\ProgressHub.cs:line
50
at
Microsoft.AspNet.SignalR.Hubs.HubMethodDispatcher.<>c__DisplayClass10_0.<WrapVoidAction>b__0(IHub
hub, Object[] parameters)
at
Microsoft.AspNet.SignalR.Hubs.HubDispatcher.Incoming(IHubIncomingInvokerContext
context)

Inner Exception 1:
NpgsqlException: The NpgsqlDbType 'Geometry' isn't present in your
database. You may need to install an extension or upgrade to a newer
version.

My mapping for extend collumn using gemetry like this.

<property name="Extent" type="NHibernate.Spatial.Type.GeometryType,
NHibernate.Spatial">
<column name="Extent" sql-type="geometry" not-null="true" />

Here is actual sql query

INSERT
INTO
__Layer
(ServiceId, Name, XmlMapping, TableName, FilterExpression, State,
SpatialReference, Type, Drawing, VisibleRange, IsEditable, IsVersioned,
SignalRIsAddEventEnabled, SignalRIsUpdateEventEnabled,
SignalRIsDeleteEventEnabled, PubNubIsAddEventEnabled,
PubNubIsUpdateEventEnabled, PubNubIsDeleteEventEnabled,
AzureIsAddEventEnabled, AzuresUpdateEventEnabled,
AzureIsDeleteEventEnabled, IsODataEnabled, HasAttachments, IsSupportTime,
TimeFieldId, MinDate, MaxDate, Extent, PopupType, PopupContent, MinScale,
MaxScale, RelationshipsJson)
VALUES
(:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11,
:p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21, :p22, :p23,
:p24, :p25, :p26, :p27, :p28, :p29, :p30, :p31, :p32);
select
lastval();
:p0 = 2 [Type: Int32 (0:0:0)],
:p1 = '1' [Type: String (0:0:0)],
:p2 = '<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping assembly="" namespace=""
xmlns="urn:nhibernate-mapping-2.2">
<class entity-name="1" table="`1_181001145753`" lazy="true" >
<id name="FID" column="`FID`" type="Int32">
<generator class="hilo" />
</id>
<property name="OBJECTID" type="Int32">
<column name="`OBJECTID`" sql-type="Int" not-null="false" />
</property>
<property name="AIRPORT_CO" type="String">
<column name="`AIRPORT_CO`" sql-type="text" not-null="false" />
</property>
<property name="Shape_Leng" type="Single">
<column name="`Shape_Leng`" sql-type="Real" not-null="false" />
</property>
<property name="Shape_Area" type="Single">
<column name="`Shape_Area`" sql-type="Real" not-null="false" />
</property>
<property name="AIRPORT_NA" type="String">
<column name="`AIRPORT_NA`" sql-type="text" not-null="false" />
</property>
<property name="Geom" type="NHibernate.Spa...' [Type: String (0:0:0)],
:p3 = NULL [Type: String (0:0:0)],
:p4 = NULL [Type: String (0:0:0)],
:p5 = 0 [Type: Int32 (0:0:0)],
:p6 = NULL [Type: Int32 (0:0:0)],
:p7 = NULL [Type: Int32 (0:0:0)],
:p8 = NULL [Type: String (0:0:0)],
:p9 = 0 [Type: Int32 (0:0:0)],
:p10 = True [Type: Boolean (0:0:0)],
:p11 = False [Type: Boolean (0:0:0)],
:p12 = False [Type: Boolean (0:0:0)],
:p13 = False [Type: Boolean (0:0:0)],
:p14 = False [Type: Boolean (0:0:0)],
:p15 = NULL [Type: Boolean (0:0:0)],
:p16 = NULL [Type: Boolean (0:0:0)],
:p17 = NULL [Type: Boolean (0:0:0)],
:p18 = NULL [Type: Boolean (0:0:0)],
:p19 = NULL [Type: Boolean (0:0:0)],
:p20 = NULL [Type: Boolean (0:0:0)],
:p21 = False [Type: Boolean (0:0:0)],
:p22 = False [Type: Boolean (0:0:0)],
:p23 = False [Type: Boolean (0:0:0)],
:p24 = NULL [Type: Int32 (0:0:0)],
:p25 = NULL [Type: Single (0:0:0)],
:p26 = NULL [Type: Single (0:0:0)],
:p27 =
0x010400002000000000020000000101000020000000000000000000000000000000000000000001010000200000000000000000000000000000000000000000
[Type: Object (0:0:0)],
:p28 = NULL [Type: Int32 (0:0:0)],
:p29 = NULL [Type: String (0:0:0)],
:p30 = NULL [Type: Int32 (0:0:0)],
:p31 = NULL [Type: Int32 (0:0:0)],
:p32 = NULL [Type: String (0:0:0)]

Please help me. Thanks you

--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhusers+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

Apatira Lookman

2018-10-01 13:15:44 UTC

Permalink

the inner exception says it all

Inner Exception 1:
NpgsqlException: The NpgsqlDbType 'Geometry' isn't present in your
database. You may need to install an extension or upgrade to a newer
version.

Install the Postgres extension for the database.

On Mon, Oct 1, 2018 at 12:31 PM Äáº¡t Ã Äáº·ng Huá»³nh <

Post by Äáº¡t Ã Äáº·ng Huá»³nh
I am using NHibernate v 5.13, NHibernate.Spatial.Postgis v5.0, Npgsql
v4.0.3 when i try insert a record into my __layer table the application
thrown an exception below.
NHibernate.Exceptions.GenericADOException
HResult=0x80131500
Message=could not insert: [Layer][SQL: INSERT INTO __Layer (ServiceId,
Name, XmlMapping, TableName, FilterExpression, State, SpatialReference,
Type, Drawing, VisibleRange, IsEditable, IsVersioned,
SignalRIsAddEventEnabled, SignalRIsUpdateEventEnabled,
SignalRIsDeleteEventEnabled, PubNubIsAddEventEnabled,
PubNubIsUpdateEventEnabled, PubNubIsDeleteEventEnabled,
AzureIsAddEventEnabled, AzuresUpdateEventEnabled,
AzureIsDeleteEventEnabled, IsODataEnabled, HasAttachments, IsSupportTime,
TimeFieldId, MinDate, MaxDate, Extent, PopupType, PopupContent, MinScale,
MaxScale, RelationshipsJson) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select
lastval()]
Source=BlueSpatial.Core
at BlueSpatial.ProgressHub.AddLayerFromFile(String filePath, String
tableName, Int32 serviceId, String connectionHubId, Boolean isODataEnabled)
in
D:\Source\WorkSpace\CloudSpatial\BlueSpatial_Dev\BlueSpatial.Core\ProgressHub.cs:line
50
at
Microsoft.AspNet.SignalR.Hubs.HubMethodDispatcher.<>c__DisplayClass10_0.<WrapVoidAction>b__0(IHub
hub, Object[] parameters)
at
Microsoft.AspNet.SignalR.Hubs.HubDispatcher.Incoming(IHubIncomingInvokerContext
context)
NpgsqlException: The NpgsqlDbType 'Geometry' isn't present in your
database. You may need to install an extension or upgrade to a newer
version.
My mapping for extend collumn using gemetry like this.
<property name="Extent" type="NHibernate.Spatial.Type.GeometryType,
NHibernate.Spatial">
<column name="Extent" sql-type="geometry" not-null="true" />
Here is actual sql query
INSERT
INTO
__Layer
(ServiceId, Name, XmlMapping, TableName, FilterExpression, State,
SpatialReference, Type, Drawing, VisibleRange, IsEditable, IsVersioned,
SignalRIsAddEventEnabled, SignalRIsUpdateEventEnabled,
SignalRIsDeleteEventEnabled, PubNubIsAddEventEnabled,
PubNubIsUpdateEventEnabled, PubNubIsDeleteEventEnabled,
AzureIsAddEventEnabled, AzuresUpdateEventEnabled,
AzureIsDeleteEventEnabled, IsODataEnabled, HasAttachments, IsSupportTime,
TimeFieldId, MinDate, MaxDate, Extent, PopupType, PopupContent, MinScale,
MaxScale, RelationshipsJson)
VALUES
(:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11,
:p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21, :p22, :p23,
:p24, :p25, :p26, :p27, :p28, :p29, :p30, :p31, :p32);
select
lastval();
:p0 = 2 [Type: Int32 (0:0:0)],
:p1 = '1' [Type: String (0:0:0)],
:p2 = '<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping assembly="" namespace=""
xmlns="urn:nhibernate-mapping-2.2">
<class entity-name="1" table="`1_181001145753`" lazy="true" >
<id name="FID" column="`FID`" type="Int32">
<generator class="hilo" />
</id>
<property name="OBJECTID" type="Int32">
<column name="`OBJECTID`" sql-type="Int" not-null="false" />
</property>
<property name="AIRPORT_CO" type="String">
<column name="`AIRPORT_CO`" sql-type="text" not-null="false" />
</property>
<property name="Shape_Leng" type="Single">
<column name="`Shape_Leng`" sql-type="Real" not-null="false" />
</property>
<property name="Shape_Area" type="Single">
<column name="`Shape_Area`" sql-type="Real" not-null="false" />
</property>
<property name="AIRPORT_NA" type="String">
<column name="`AIRPORT_NA`" sql-type="text" not-null="false" />
</property>
<property name="Geom" type="NHibernate.Spa...' [Type: String (0:0:0)],
:p3 = NULL [Type: String (0:0:0)],
:p4 = NULL [Type: String (0:0:0)],
:p5 = 0 [Type: Int32 (0:0:0)],
:p6 = NULL [Type: Int32 (0:0:0)],
:p7 = NULL [Type: Int32 (0:0:0)],
:p8 = NULL [Type: String (0:0:0)],
:p9 = 0 [Type: Int32 (0:0:0)],
:p10 = True [Type: Boolean (0:0:0)],
:p11 = False [Type: Boolean (0:0:0)],
:p12 = False [Type: Boolean (0:0:0)],
:p13 = False [Type: Boolean (0:0:0)],
:p14 = False [Type: Boolean (0:0:0)],
:p15 = NULL [Type: Boolean (0:0:0)],
:p16 = NULL [Type: Boolean (0:0:0)],
:p17 = NULL [Type: Boolean (0:0:0)],
:p18 = NULL [Type: Boolean (0:0:0)],
:p19 = NULL [Type: Boolean (0:0:0)],
:p20 = NULL [Type: Boolean (0:0:0)],
:p21 = False [Type: Boolean (0:0:0)],
:p22 = False [Type: Boolean (0:0:0)],
:p23 = False [Type: Boolean (0:0:0)],
:p24 = NULL [Type: Int32 (0:0:0)],
:p25 = NULL [Type: Single (0:0:0)],
:p26 = NULL [Type: Single (0:0:0)],
:p27 =
0x010400002000000000020000000101000020000000000000000000000000000000000000000001010000200000000000000000000000000000000000000000
[Type: Object (0:0:0)],
:p28 = NULL [Type: Int32 (0:0:0)],
:p29 = NULL [Type: String (0:0:0)],
:p30 = NULL [Type: Int32 (0:0:0)],
:p31 = NULL [Type: Int32 (0:0:0)],
:p32 = NULL [Type: String (0:0:0)]
Please help me. Thanks you
--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

--
Best Regards
Apatira Lookman
+2348028400104

Đạt Ý Đặng Huỳnh

2018-10-02 02:09:08 UTC

Permalink

[image: Capture.PNG]
yes i do. i ran "Create extension postgis" to install postgis to my
database. But the exception still there

Post by Apatira Lookman
the inner exception says it all
NpgsqlException: The NpgsqlDbType 'Geometry' isn't present in your
database. You may need to install an extension or upgrade to a newer
version.
Install the Postgres extension for the database.

Post by Äáº¡t Ã Äáº·ng Huá»³nh
I am using NHibernate v 5.13, NHibernate.Spatial.Postgis v5.0, Npgsql
v4.0.3 when i try insert a record into my __layer table the application
thrown an exception below.
NHibernate.Exceptions.GenericADOException
HResult=0x80131500
Message=could not insert: [Layer][SQL: INSERT INTO __Layer (ServiceId,
Name, XmlMapping, TableName, FilterExpression, State, SpatialReference,
Type, Drawing, VisibleRange, IsEditable, IsVersioned,
SignalRIsAddEventEnabled, SignalRIsUpdateEventEnabled,
SignalRIsDeleteEventEnabled, PubNubIsAddEventEnabled,
PubNubIsUpdateEventEnabled, PubNubIsDeleteEventEnabled,
AzureIsAddEventEnabled, AzuresUpdateEventEnabled,
AzureIsDeleteEventEnabled, IsODataEnabled, HasAttachments, IsSupportTime,
TimeFieldId, MinDate, MaxDate, Extent, PopupType, PopupContent, MinScale,
MaxScale, RelationshipsJson) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select
lastval()]
Source=BlueSpatial.Core
at BlueSpatial.ProgressHub.AddLayerFromFile(String filePath, String
tableName, Int32 serviceId, String connectionHubId, Boolean isODataEnabled)
in
D:\Source\WorkSpace\CloudSpatial\BlueSpatial_Dev\BlueSpatial.Core\ProgressHub.cs:line
50
at
Microsoft.AspNet.SignalR.Hubs.HubMethodDispatcher.<>c__DisplayClass10_0.<WrapVoidAction>b__0(IHub
hub, Object[] parameters)
at
Microsoft.AspNet.SignalR.Hubs.HubDispatcher.Incoming(IHubIncomingInvokerContext
context)
NpgsqlException: The NpgsqlDbType 'Geometry' isn't present in your
database. You may need to install an extension or upgrade to a newer
version.
My mapping for extend collumn using gemetry like this.
<property name="Extent" type="NHibernate.Spatial.Type.GeometryType,
NHibernate.Spatial">
<column name="Extent" sql-type="geometry" not-null="true" />
Here is actual sql query
INSERT
INTO
__Layer
(ServiceId, Name, XmlMapping, TableName, FilterExpression, State,
SpatialReference, Type, Drawing, VisibleRange, IsEditable, IsVersioned,
SignalRIsAddEventEnabled, SignalRIsUpdateEventEnabled,
SignalRIsDeleteEventEnabled, PubNubIsAddEventEnabled,
PubNubIsUpdateEventEnabled, PubNubIsDeleteEventEnabled,
AzureIsAddEventEnabled, AzuresUpdateEventEnabled,
AzureIsDeleteEventEnabled, IsODataEnabled, HasAttachments, IsSupportTime,
TimeFieldId, MinDate, MaxDate, Extent, PopupType, PopupContent, MinScale,
MaxScale, RelationshipsJson)
VALUES
(:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11,
:p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21, :p22, :p23,
:p24, :p25, :p26, :p27, :p28, :p29, :p30, :p31, :p32);
select
lastval();
:p0 = 2 [Type: Int32 (0:0:0)],
:p1 = '1' [Type: String (0:0:0)],
:p2 = '<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping assembly="" namespace=""
xmlns="urn:nhibernate-mapping-2.2">
<class entity-name="1" table="`1_181001145753`" lazy="true" >
<id name="FID" column="`FID`" type="Int32">
<generator class="hilo" />
</id>
<property name="OBJECTID" type="Int32">
<column name="`OBJECTID`" sql-type="Int" not-null="false" />
</property>
<property name="AIRPORT_CO" type="String">
<column name="`AIRPORT_CO`" sql-type="text" not-null="false" />
</property>
<property name="Shape_Leng" type="Single">
<column name="`Shape_Leng`" sql-type="Real" not-null="false" />
</property>
<property name="Shape_Area" type="Single">
<column name="`Shape_Area`" sql-type="Real" not-null="false" />
</property>
<property name="AIRPORT_NA" type="String">
<column name="`AIRPORT_NA`" sql-type="text" not-null="false" />
</property>
<property name="Geom" type="NHibernate.Spa...' [Type: String (0:0:0)],
:p3 = NULL [Type: String (0:0:0)],
:p4 = NULL [Type: String (0:0:0)],
:p5 = 0 [Type: Int32 (0:0:0)],
:p6 = NULL [Type: Int32 (0:0:0)],
:p7 = NULL [Type: Int32 (0:0:0)],
:p8 = NULL [Type: String (0:0:0)],
:p9 = 0 [Type: Int32 (0:0:0)],
:p10 = True [Type: Boolean (0:0:0)],
:p11 = False [Type: Boolean (0:0:0)],
:p12 = False [Type: Boolean (0:0:0)],
:p13 = False [Type: Boolean (0:0:0)],
:p14 = False [Type: Boolean (0:0:0)],
:p15 = NULL [Type: Boolean (0:0:0)],
:p16 = NULL [Type: Boolean (0:0:0)],
:p17 = NULL [Type: Boolean (0:0:0)],
:p18 = NULL [Type: Boolean (0:0:0)],
:p19 = NULL [Type: Boolean (0:0:0)],
:p20 = NULL [Type: Boolean (0:0:0)],
:p21 = False [Type: Boolean (0:0:0)],
:p22 = False [Type: Boolean (0:0:0)],
:p23 = False [Type: Boolean (0:0:0)],
:p24 = NULL [Type: Int32 (0:0:0)],
:p25 = NULL [Type: Single (0:0:0)],
:p26 = NULL [Type: Single (0:0:0)],
:p27 =
0x010400002000000000020000000101000020000000000000000000000000000000000000000001010000200000000000000000000000000000000000000000
[Type: Object (0:0:0)],
:p28 = NULL [Type: Int32 (0:0:0)],
:p29 = NULL [Type: String (0:0:0)],
:p30 = NULL [Type: Int32 (0:0:0)],
:p31 = NULL [Type: Int32 (0:0:0)],
:p32 = NULL [Type: String (0:0:0)]
Please help me. Thanks you
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an
<javascript:>.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

--
Best Regards
Apatira Lookman
+2348028400104

Đạt Ý Đặng Huỳnh

2018-10-31 03:22:16 UTC

Permalink

I have fixed by downgrade npgsql connector to 3.2.7