I don't understand why the compiler does not warn me about not catching or throwing an SQLException. Here's the situation: I have defined this interface: public interface GenericDatabaseManager {...

I used java to query some records from Mysql. But in some querys of one duration, i meet a problem which make query failed, but in others , it query successful. The error message is next: com.mys...

Changing one full-text index column Language (LCID) to Neutral when the others are English results in the following error: System.Data.SqlClient.SqlException (0x80131904): Full-text table or index...

Sql Server is accessible. I want to migrate database using Entity Framework migrations. There i have "Images" table with 130k records having images. In migration there "INDEX" added to these table ...

Using Dapper, the following throws Incorrect syntax near ','. const string sql = "select * from ZipToZipDistance z where z.NoRouteFound = 0" + " and z.OriginZip in (@zips) or z.DestZip in (@zip...

I want to fetch data from SQLITE database and display it in a LIST. My database name is AppDB.db and table name is Scrip which contains 3 columns _id(primary key) and symbol&company_name which ...

I am currently getting the error, java.sql.SQLException: Method 'executeQuery(String)' not allowed on prepared statement. because I am using PreparedStatement stmt = conn.prepareStatement(sql);...

java.sql.SQLException offers an int getErrorCode() function so the program can know what in particular has happened to cause the exception. Any chance to get a list of these codes for MySQL?

I have some 3-4 stored procedures ― which I can modify if needed ― that use RAISERROR to inform my application of some fatal errors on the database side. Some of these stored procedures are execute...

I want to have @messages return @folder.messages where the value of column "deleted" is NOT equal to true. I'm not sure why this keeps throwing a SQLException. I guess I'm not formatting the delete...

Possible Duplicate: Obtain the Query/CommandText that caused a SQLException I am working on some error handling code (using elmah) and the default setup only sends the error message. ...

I want to handle different problems, while doing database operations, differently. e.g. The operation may fail because of wrong database credentials or due to network problem. Or it may fail becau...

My code is throwing the above exception on the following line (line 2 of this) : final ArrayDescriptor tParamArrayDescriptor = ArrayDescriptor.createDescriptor("MY_SYSTEM.T_PARAM_ARRAY", database...

Am getting the below error intermittently. ERROR Exception occured while fetching the available subscriptions from the database - Could not roll back Hibernate transaction; nested exception is or...

I've got a strange problem. I have a .NET program and my process logic needs a long-running transaction (~20min) on a SQL Server 2005 database. That's ok, since nobody accesses the database in para...

I am getting an SqlException in the logs of .NET 3.5 app, I am looking for the corresponding number (value of the property SqlException.Number). System.Data.SqlClient.SqlException: A transport-lev...

I'm getting this error: Exception java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). java.sql.SQLException: Parameter index out of range (1 > nu...

My application keeps running into Timeout Expired SqlExceptions. The thing is that this query is one that will simply have to run for a decent amount of time. I'm having trouble figuring out where ...

When executing the following (complete) SQL query on Microsoft SQL Server 2000: SELECT B.ARTIFACTTNS, B.ARTIFACTNAME, B.ARTIFACTTYPE, B.INITIALBYTES, B.TIMESTAMP1, B.FILENAME, B.BACKINGCLASS, B....