Are there SqlExceptions which throw but commit their data anyway?

Posted by Jonn on Stack Overflow See other posts from Stack Overflow or by Jonn
Published on 2010-04-29T05:59:35Z Indexed on 2010/04/29 21:27 UTC
Read the original article Hit count: 196

Filed under:

sqlexception

|

error-handling

|

.NET

I've recently encountered the error:

System.Data.SqlClient.SqlException: The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

on one of my windows services. It's supposed to retry after catching an Sql Exception, what I didn't expect was that it seemed like the data was still going through (I'm using an SqlBulkCopy btw) regardless of it throwing an exception. I've never encountered this scenario before.

I'd like to know if there are other scenarios where such a thing like this might happen, and if this thing is entirely possible at all in the first place?

PS. If anyone knows the error code to the above exception, that would help a great deal as well.

© Stack Overflow or respective owner

Related posts about sqlexception

How to throw a SqlException(need for mocking)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to test some exceptions in my project and one of the Exceptions I catch is SQlException. Now It seems that you can't go new SqlException() so I am not sure how I can throw a exception especially without somehow calling the database(and since it is unit tests it is usually advised… >>> More
'Invalid column name [ColumnName]' on a nested linq query.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got the following query: ATable .GroupBy(x=> new {FieldA = x.FieldAID, FieldB = x.FieldBID, FieldC = x.FieldCID}) .Select(x=>new {FieldA = x.Key.FieldA, ..., last_seen = x.OrderByDescending(y=>y.Timestamp).FirstOrDefault().Timestamp}) results in: SqlException: Invalid column name… >>> More
Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Cl

as seen on Stack Overflow - Search for 'Stack Overflow'
Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Closed Connection I am using weblogic 10 JNDI datasource to create JDBC connections, below is my config http://www.bea.com/ns/weblogic/920.xsd" XL-Reference-DS jdbc:oracle:oci:@abc.XL.COM … >>> More
java.sql.SQLException: SQL logic error or missing database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I ahve created database connection with SQLite using JDBC in java. My sql statements execute properly. But sometimes I get the following error while i use conn.commit() java.sql.SQLException: SQL logic error or missing database Can anyone please help me how to avoid this type of… >>> More
java.sql.SQLException: SQL logic error or missing database, SQLite, JDBC

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I ahve created database connection with SQLite using JDBC in java. My sql statements execute properly. But sometimes I get the following error while i use conn.commit() java.sql.SQLException: SQL logic error or missing database Can anyone please help me how to avoid this type of… >>> More

Related posts about error-handling

Good SQL error handling in Strored Procedure

as seen on Developer IT - Search for 'Developer IT'
When writing SQL procedures, it is really important to handle errors cautiously. Having that in mind will probably save your efforts, time and money. I have been working with MS-SQL 2000 and MS-SQL 2005 (I have not got the opportunity to work with MS-SQL 2008 yet) for many years now and I want to… >>> More
Error Handling Examples(C#)

as seen on DotNetBlocks - Search for 'DotNetBlocks'
“The purpose of reviewing the Error Handling code is to assure that the application fails safely under all possible error conditions, expected and unexpected. No sensitive information is presented to the user when an error occurs.” (OWASP, 2011) No Error Handling The absence of error… >>> More
Building an Error-Handling Mechanism

as seen on Internet.com - Search for 'Internet.com'
Are errors chasing away your visitors? Let Marc Plotz show you how to handle them effectively. ... >>> More
Building an Error-Handling Mechanism

as seen on Internet.com - Search for 'Internet.com'
Are errors chasing away your visitors? Let Marc Plotz show you how to handle them effectively. ... >>> More
Improving ANTLR DSL parse-error messages

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on a domain-specific language (DSL) for non-programmers. Non-programmers make a lot of grammar mistakes: they misspell keywords, they don't close parentheses, they don't terminate blocks, etc. I'm using ANTLR to generate my parser; it provides a nifty mechanism for handling RecognitionExceptions… >>> More