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