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+unsubscr...@googlegroups.com.
To post to this group, send email to nhusers@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
