First things first: I have no idea where you are getting the tableName and columnName, but if they are user-supplied, then this is open to SQL injection. At the very least, use QUOTENAME() to ensure no actual code is injected. Secondly, you are not actually using the TVP. The code you have is just saying … Read more
Try something like this, this will help you in handling different conditions. use a try catch block like this: try { … … } catch (SqlException ex) { switch (ex.Number) { case 4060: // Invalid Database …. break; case 18456: // Login Failed …. break; case 547: // ForeignKey Violation …. break; case 2627: // … Read more
Because ARTIFACTTYPE can refer to either A.ARTIFACTTYPE or B.ARTIFACTTYPE and the server needs to know which one you want, just change it to A.ARTIFACTTYPE and you should be okay in this case. To clarify, you need to specify the alias prefix any time the column name is ambiguous. It isn’t bad practice to always use … Read more
Before you can add a table, you first have to select a database. you can create a new database with: CREATE DATABASE database_name you can connect to a specific database with: String url = “jdbc:mysql://localhost/databasename”; String username = “test”; String password = “test”; Connection connection = DriverManager.getConnection(url, username, password);
I have a solution to this. I’m not sure whether it’s genius or madness. The following code will create a new SqlException: public SqlException MakeSqlException() { SqlException exception = null; try { SqlConnection conn = new SqlConnection(@”Data Source=.;Database=GUARANTEED_TO_FAIL;Connection Timeout=1″); conn.Open(); } catch(SqlException ex) { exception = ex; } return(exception); } which you can then use … Read more
You should use the next statement first. ResultSet set = statement.executeQuery(); if (set.next()) { userName = set.getString(1); //your logic… } UPDATE As the Java 6 Documentation says A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes … Read more
Ambiguous date formats are interpreted according to the language of the login. This works set dateformat mdy select CAST(’03/28/2011 18:03:40′ AS DATETIME) This doesn’t set dateformat dmy select CAST(’03/28/2011 18:03:40′ AS DATETIME) If you use parameterised queries with the correct datatype you avoid these issues. You can also use the unambiguous “unseparated” format yyyyMMdd hh:mm:ss
java.sql.SQLException: No suitable driver found This exception can have 2 causes: The JDBC driver is not loaded at all. URL does not match any of the loaded JDBC drivers. Since the driver seems to be loaded (although in an incorrect manner), it look like that the URL is plain wrong. Ensure that the value of … Read more
If you have a TRY/CATCH block then the likely cause is that you are catching a transaction abort exception and continue. In the CATCH block you must always check the XACT_STATE() and handle appropriate aborted and uncommitable (doomed) transactions. If your caller starts a transaction and the calee hits, say, a deadlock (which aborted the … Read more
What you have is EXTRATERRESTRIAL ALIEN (U+1F47D) and BROKEN HEART (U+1F494) which are not in the basic multilingual plane. They cannot be even represented in java as one char, “👽💔”.length() == 4. They are definitely not null characters and one will see squares if you are not using fonts that support them. MySQL’s utf8 only … Read more