Check if Database raises a particular exception

Posted by mcabral on Stack Overflow See other posts from Stack Overflow or by mcabral
Published on 2010-04-06T18:21:54Z Indexed on 2010/04/06 18:33 UTC
Read the original article Hit count: 233

Filed under:

nhibernate

|

exception

|

unique-index

|

catch

using Nhibernate;

I'm trying to insert several values a on table which has an unique index on some columns.

I'd like to know if a particular insert raises an exception for having violated the unique constraint.

So, which particular exception type should i catch? I only want to catch this particular one and let all others go up.

Thanks a lot!

© Stack Overflow or respective owner

Related posts about nhibernate

How can I eager-load a child collection mapped to a non-primary key in NHibernate 2.1.2?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have two objects with a many-to-many relationship between them, as follows: public class LeftHandSide { public LeftHandSide() { Name = String.Empty; Rights = new HashSet<RightHandSide>(); } public int Id { get; set; } public string Name { get; set;… >>> More
Nhibernate 2.1 and mysql 5 - InvalidCastException on Setup

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello there, I am trying to use NHibernate with Spring.Net und mySQL 5. However, when setting up the connection and creating the SessionFactoryObject, I get this InvalidCastException: NHibernate seems to cast MySql.Data.MySqlClient.MySqlConnection to System.Data.Common.DbConnection which causes… >>> More
Nhibernate transactions:Avoiding Nhibernate dependency in the service layer

as seen on Stack Overflow - Search for 'Stack Overflow'
One of practices advocated by Nhibernate experts is to do all actions in inside a transaction. In a typical 3 tier web architecture, Nhibernate depedency is limited the data layer. In such a case is it fine to use using (var tr = NHibernateSession.Current.BeginTransaction()) { at the controller… >>> More
Series of abstract classes and NHibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, and first off thanks for your time to look at this. For a research project I'm working on, I have a somewhat complex design (which I've been given) to persist to a database via NHibernate. Here's an example of the class hierarchy: TransitStrategy, TransportationCompany and TransportationLocation… >>> More
Using Time columns with NHibernate, Fluent NHibernate and SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a table with a time column in my SQL Server 2008 database. The property of the object I'm trying to map to is a TimeSpan. How can i tell FluentNHibernate to use the TimeAsTimeSpan NHibernate type, so that I don't have cast problems? >>> More

Related posts about exception

Multiple Exception Handlers for one exception type

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using Enterprose Library 4.1. I have created a custom exception handler called CustomHandler. This is how the configuration section would look like: <exceptionHandling> <exceptionPolicies> <add name="Exception Policy"> <exceptionTypes> <add… >>> More
Delphi Exception handling problem with multiple Exception handling blocks

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Delphi Pro 6 on Windows XP with FastMM 4.92 and the JEDI JVCL 3.0. Given the code below, I'm having the following problem: only the first exception handling block gets a valid instance of E. The other blocks match properly with the class of the Exception being raised, but E is unassigned… >>> More
Delph Exception handling problem with multiple Exception handling blocks

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Delphi Pro 6 on Windows XP with FastMM 4.92 and the JEDI JVCL 3.0. Given the code below, I'm having the following problem: only the first exception handling block gets a valid instance of E. The other blocks match properly with the class of the Exception being raised, but E is unassigned… >>> More
ClickOnce manifest problem

as seen on Stack Overflow - Search for 'Stack Overflow'
We are currently deploying a WPF 4 app via click once and there is a scenario when the installation fails. If the user does not have .Net 4.0 Full install and attempts to install our app the framework installs fine but the app fails to install. If we re-run the installation again the app installs… >>> More
.NET remoting exception: Exception in the Socket#33711845::DoBind - Only one usage of each socket ad

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I'm attempting to setup a simple remoting windows service and getting the following error when starting the service: "System.Net.Sockets Error: 0 : [4180] Exception in the Socket#33711845::DoBind - Only one usage of each socket address (protocol/network address/port) is normally permitted System… >>> More