sqlexception Questions
2
I've 2 maven projects in my Eclipse (v4.7.0) workspace.
The first project contains some utility stuffs and holds the connection to my MySQL database through JDBC driver.
<project xmlns="http:...
Flocculus asked 19/8, 2017 at 13:11
3
Solved
From a .NET 3.5 / C# app, I would like to catch SqlException but only if it is caused by deadlocks on a SQL Server 2008 instance.
Typical error message is Transaction (Process ID 58) was deadlock...
Grampus asked 13/2, 2010 at 8:26
3
Solved
(This code is using Dapper Dot Net in C#)
This code works:
var command = "UPDATE account SET priority_id = @Priority WHERE name = @Name";
connection_.Execute(command, new { Name = "myname", Prior...
Obligee asked 22/11, 2011 at 16:45
9
Solved
I work on a database application written in C# with sql server as backend. And for data integrity, I try to enforce as much as possible on database level - relations, check constraints, triggers.
...
Adenosine asked 12/9, 2009 at 13:11
2
Solved
I have a stored procedure where I'd like to rollback in case anything goes wrong. In order to do that I'm using a EXIT HANDLER like this:
DECLARE EXIT HANDLER FOR sqlexception
begin
ROLLBACK;
...
Utoaztecan asked 6/2, 2016 at 13:28
1
Solved
I have connected the oracle to my Java program, and it is working fine but it gives a problem on a primary key field, when I try to access it it throws an java.sql.SQLException:
select user_id
fr...
Banjermasin asked 12/8, 2015 at 5:11
1
Solved
I have the following problem trying to create a Connection object to handle the connection from a command line Java application and an Oracle database.
So I have a Main class that contains the mai...
Formerly asked 11/2, 2015 at 10:53
2
Solved
I'm writing generic logger for SQLException and I'd like to get parameters that were passed into PreparedStatement, how to do it ? I was able to get the count of them.
ParameterMetaData metaData =...
Twyla asked 14/1, 2011 at 13:28
3
I want to fetch parameter name and parameter type of given prepared statement. I am using MySQL Database. But when I run my program it is throwing an error:
Exception in thread "main" java.sql.SQL...
Wadley asked 28/1, 2013 at 8:43
5
Solved
I have a Java class that accesses a MySQL database through JDBC that I use in a JSP running on Tomcat, and I am getting No Driver Found Exception.
I have a method:
private static Statement ...
Luciusluck asked 12/5, 2011 at 18:32
2
Solved
I have here my code for login
and I am encountering this error,
"java.sql.SQLException: No value specified for parameter 2"
sometimes,
"java.sql.SQLException:Parameter index out of range (1> num...
Miracle asked 18/11, 2014 at 11:45
5
Solved
Have you encountered this exception for a stored procedure which does indeed have a balanced transaction block?
I double-checked the stored procedure and it has exactly one TRANSACTION BEGIN and c...
Sylas asked 16/9, 2010 at 16:50
3
Solved
I'm getting this BatchUpdateException from a stmt.executeBatch() statement:
BatchUpdateException: A resultset was created for update
The internet does not have any information on this exception ...
Christo asked 15/3, 2011 at 8:5
4
I'm getting a weird SQLException on a function I run against a database using JDBC.
SQLException: Column 'Message' not found.
I have this in my function:
st = con.prepareStatement("SELECT Notif...
Kaufman asked 30/10, 2013 at 1:46
3
Solved
I am getting the following error:
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: apartments)
In reality, the table does exist. The following is my code:
try...
Padauk asked 21/2, 2013 at 9:30
2
Solved
I was running an application for a few hours and then suddenly:
SqlException was unhandled by user code:
Time-out occurred while waiting for buffer latch type 2 for page
(1:37660679), database...
Jallier asked 24/2, 2013 at 19:43
15
Solved
I have created my tables in my SQLiteOpenHelper onCreate() but receive
SQLiteException: no such table
or
SQLiteException: no such column
errors. Why?
NOTE:
(This is the amalgamated summ...
Idiomatic asked 19/2, 2014 at 13:31
2
Solved
SqlException has the property Number.
Then there is this: http://msdn.microsoft.com/en-us/library/cc645603.aspx
and this: http://msdn.microsoft.com/en-us/library/windows/desktop/ms681382(v=vs.85)...
Raymundorayna asked 19/9, 2013 at 12:13
2
Solved
I am trying to execute simple query using below DbQuery.java class which uses DbConnector to get a Connection from DriverManager.
note:
I have already included "mysql-connector-java-5.1.25-bin...
Oder asked 6/7, 2013 at 21:47
4
Solved
I am trying to connect to SQL Server 2008 via Java.
I've added sqljdbc4.jar to my project's library.
No username and password is set for database accessing the database (Windows Authentication).
...
Gunilla asked 18/2, 2013 at 20:52
2
Solved
I've been having a hard time trying to figure this out. First I have an insertProduct(Product p) method that is supposed to check if a product with the specified code exists in the database. If so,...
Tessellation asked 15/5, 2013 at 22:55
1
I'm lovin MiniProfiler for our .NET project. However, I'm running into an issue. The profiler is actually causing queries to be slightly different which is causing errors. For example, when the pro...
Thylacine asked 26/2, 2013 at 22:28
3
string con = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(con);
string insert_jobseeker = "INSERT INTO JobSeeker_Registration...
Beebe asked 22/3, 2013 at 8:53
2
Solved
My code throws
java.sql.sqlRecoverableException: Sentencia cerrada: next
which, in English, I guess it would be:
java.sql.sqlRecoverableException: Closed statement: next
This is my code:
pub...
Lumbago asked 19/2, 2013 at 13:0
3
Solved
my code below query the database for a set of rows based on user input. I have tried and tested the query inside of SQL Developer and it works perfectly fine returning the correct rows. And example...
Cosmetician asked 23/1, 2013 at 11:21
© 2022 - 2024 — McMap. All rights reserved.