Java Doc for SQLError.java in  » Database-JDBC-Connection-Pool » mysql-connector-java-5.1.3 » com » mysql » jdbc » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Database JDBC Connection Pool » mysql connector java 5.1.3 » com.mysql.jdbc 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   com.mysql.jdbc.SQLError

SQLError
public class SQLError (Code)
SQLError is a utility class that maps MySQL error codes to X/Open error codes as is required by the JDBC spec.
author:
   Mark Matthews
version:
   $Id: SQLError.java 5122 2006-04-03 15:37:11 +0000 (Mon, 03 Apr 2006)
version:
   mmatthews $


Field Summary
final static  intER_WARNING_NOT_COMPLETE_ROLLBACK
    
final public static  StringSQL_STATE_BASE_TABLE_NOT_FOUND
    
final public static  StringSQL_STATE_BASE_TABLE_OR_VIEW_ALREADY_EXISTS
    
final public static  StringSQL_STATE_BASE_TABLE_OR_VIEW_NOT_FOUND
    
final public static  StringSQL_STATE_COLUMN_ALREADY_EXISTS
    
final public static  StringSQL_STATE_COLUMN_NOT_FOUND
    
final public static  StringSQL_STATE_COMMUNICATION_LINK_FAILURE
    
final public static  StringSQL_STATE_CONNECTION_FAIL_DURING_TX
    
final public static  StringSQL_STATE_CONNECTION_IN_USE
    
final public static  StringSQL_STATE_CONNECTION_NOT_OPEN
    
final public static  StringSQL_STATE_CONNECTION_REJECTED
    
final public static  StringSQL_STATE_DATETIME_FIELD_OVERFLOW
    
final public static  StringSQL_STATE_DATE_TRUNCATED
    
final public static  StringSQL_STATE_DEADLOCK
    
final public static  StringSQL_STATE_DISCONNECT_ERROR
    
final public static  StringSQL_STATE_DIVISION_BY_ZERO
    
final public static  StringSQL_STATE_DRIVER_NOT_CAPABLE
    
final public static  StringSQL_STATE_ERROR_IN_ROW
    
final public static  StringSQL_STATE_GENERAL_ERROR
    
final public static  StringSQL_STATE_ILLEGAL_ARGUMENT
    
final public static  StringSQL_STATE_INDEX_ALREADY_EXISTS
    
final public static  StringSQL_STATE_INDEX_NOT_FOUND
    
final public static  StringSQL_STATE_INSERT_VALUE_LIST_NO_MATCH_COL_LIST
    
final public static  StringSQL_STATE_INVALID_AUTH_SPEC
    
final public static  StringSQL_STATE_INVALID_CHARACTER_VALUE_FOR_CAST
    
final public static  StringSQL_STATE_INVALID_COLUMN_NUMBER
    
final public static  StringSQL_STATE_INVALID_CONNECTION_ATTRIBUTE
    
final public static  StringSQL_STATE_INVALID_TRANSACTION_TERMINATION
    
final public static  StringSQL_STATE_MEMORY_ALLOCATION_FAILURE
    
final public static  StringSQL_STATE_MORE_THAN_ONE_ROW_UPDATED_OR_DELETED
    
final public static  StringSQL_STATE_NO_DEFAULT_FOR_COLUMN
    
final public static  StringSQL_STATE_NO_ROWS_UPDATED_OR_DELETED
    
final public static  StringSQL_STATE_NUMERIC_VALUE_OUT_OF_RANGE
    
final public static  StringSQL_STATE_PRIVILEGE_NOT_REVOKED
    
final public static  StringSQL_STATE_SYNTAX_ERROR
    
final public static  StringSQL_STATE_TIMEOUT_EXPIRED
    
final public static  StringSQL_STATE_TRANSACTION_RESOLUTION_UNKNOWN
    
final public static  StringSQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE
    
final public static  StringSQL_STATE_WRONG_NO_OF_PARAMETERS
    


Method Summary
static  SQLWarningconvertShowWarningsToSQLWarnings(Connection connection)
     Turns output of 'SHOW WARNINGS' into JDBC SQLWarning instances. If 'forTruncationOnly' is true, only looks for truncation warnings, and actually throws DataTruncation as an exception.
Parameters:
  connection - the connection to use for getting warnings.
static  SQLWarningconvertShowWarningsToSQLWarnings(Connection connection, int warningCountIfKnown, boolean forTruncationOnly)
     Turns output of 'SHOW WARNINGS' into JDBC SQLWarning instances.
public static  SQLExceptioncreateCommunicationsException(ConnectionImpl conn, long lastPacketSentTimeMs, Exception underlyingException)
    
public static  StringcreateLinkFailureMessageBasedOnHeuristics(ConnectionImpl conn, long lastPacketSentTimeMs, Exception underlyingException, boolean streamingResultSetInPlay)
     Creates a communications link failure message to be used in CommunicationsException that (hopefully) has some better information and suggestions based on heuristics.
public static  SQLExceptioncreateSQLException(String message, String sqlState)
    
public static  SQLExceptioncreateSQLException(String message)
    
public static  SQLExceptioncreateSQLException(String message, String sqlState, Throwable cause)
    
public static  SQLExceptioncreateSQLException(String message, String sqlState, int vendorErrorCode)
    
public static  SQLExceptioncreateSQLException(String message, String sqlState, int vendorErrorCode, boolean isTransient)
    
public static  voiddumpSqlStatesMappingsAsXml()
    
static  Stringget(String stateCode)
    
static  StringmysqlToSqlState(int errno, boolean useSql92States)
    

Field Detail
ER_WARNING_NOT_COMPLETE_ROLLBACK
final static int ER_WARNING_NOT_COMPLETE_ROLLBACK(Code)



SQL_STATE_BASE_TABLE_NOT_FOUND
final public static String SQL_STATE_BASE_TABLE_NOT_FOUND(Code)



SQL_STATE_BASE_TABLE_OR_VIEW_ALREADY_EXISTS
final public static String SQL_STATE_BASE_TABLE_OR_VIEW_ALREADY_EXISTS(Code)



SQL_STATE_BASE_TABLE_OR_VIEW_NOT_FOUND
final public static String SQL_STATE_BASE_TABLE_OR_VIEW_NOT_FOUND(Code)



SQL_STATE_COLUMN_ALREADY_EXISTS
final public static String SQL_STATE_COLUMN_ALREADY_EXISTS(Code)



SQL_STATE_COLUMN_NOT_FOUND
final public static String SQL_STATE_COLUMN_NOT_FOUND(Code)



SQL_STATE_COMMUNICATION_LINK_FAILURE
final public static String SQL_STATE_COMMUNICATION_LINK_FAILURE(Code)



SQL_STATE_CONNECTION_FAIL_DURING_TX
final public static String SQL_STATE_CONNECTION_FAIL_DURING_TX(Code)



SQL_STATE_CONNECTION_IN_USE
final public static String SQL_STATE_CONNECTION_IN_USE(Code)



SQL_STATE_CONNECTION_NOT_OPEN
final public static String SQL_STATE_CONNECTION_NOT_OPEN(Code)



SQL_STATE_CONNECTION_REJECTED
final public static String SQL_STATE_CONNECTION_REJECTED(Code)



SQL_STATE_DATETIME_FIELD_OVERFLOW
final public static String SQL_STATE_DATETIME_FIELD_OVERFLOW(Code)



SQL_STATE_DATE_TRUNCATED
final public static String SQL_STATE_DATE_TRUNCATED(Code)



SQL_STATE_DEADLOCK
final public static String SQL_STATE_DEADLOCK(Code)



SQL_STATE_DISCONNECT_ERROR
final public static String SQL_STATE_DISCONNECT_ERROR(Code)



SQL_STATE_DIVISION_BY_ZERO
final public static String SQL_STATE_DIVISION_BY_ZERO(Code)



SQL_STATE_DRIVER_NOT_CAPABLE
final public static String SQL_STATE_DRIVER_NOT_CAPABLE(Code)



SQL_STATE_ERROR_IN_ROW
final public static String SQL_STATE_ERROR_IN_ROW(Code)



SQL_STATE_GENERAL_ERROR
final public static String SQL_STATE_GENERAL_ERROR(Code)



SQL_STATE_ILLEGAL_ARGUMENT
final public static String SQL_STATE_ILLEGAL_ARGUMENT(Code)



SQL_STATE_INDEX_ALREADY_EXISTS
final public static String SQL_STATE_INDEX_ALREADY_EXISTS(Code)



SQL_STATE_INDEX_NOT_FOUND
final public static String SQL_STATE_INDEX_NOT_FOUND(Code)



SQL_STATE_INSERT_VALUE_LIST_NO_MATCH_COL_LIST
final public static String SQL_STATE_INSERT_VALUE_LIST_NO_MATCH_COL_LIST(Code)



SQL_STATE_INVALID_AUTH_SPEC
final public static String SQL_STATE_INVALID_AUTH_SPEC(Code)



SQL_STATE_INVALID_CHARACTER_VALUE_FOR_CAST
final public static String SQL_STATE_INVALID_CHARACTER_VALUE_FOR_CAST(Code)



SQL_STATE_INVALID_COLUMN_NUMBER
final public static String SQL_STATE_INVALID_COLUMN_NUMBER(Code)



SQL_STATE_INVALID_CONNECTION_ATTRIBUTE
final public static String SQL_STATE_INVALID_CONNECTION_ATTRIBUTE(Code)



SQL_STATE_INVALID_TRANSACTION_TERMINATION
final public static String SQL_STATE_INVALID_TRANSACTION_TERMINATION(Code)



SQL_STATE_MEMORY_ALLOCATION_FAILURE
final public static String SQL_STATE_MEMORY_ALLOCATION_FAILURE(Code)



SQL_STATE_MORE_THAN_ONE_ROW_UPDATED_OR_DELETED
final public static String SQL_STATE_MORE_THAN_ONE_ROW_UPDATED_OR_DELETED(Code)



SQL_STATE_NO_DEFAULT_FOR_COLUMN
final public static String SQL_STATE_NO_DEFAULT_FOR_COLUMN(Code)



SQL_STATE_NO_ROWS_UPDATED_OR_DELETED
final public static String SQL_STATE_NO_ROWS_UPDATED_OR_DELETED(Code)



SQL_STATE_NUMERIC_VALUE_OUT_OF_RANGE
final public static String SQL_STATE_NUMERIC_VALUE_OUT_OF_RANGE(Code)



SQL_STATE_PRIVILEGE_NOT_REVOKED
final public static String SQL_STATE_PRIVILEGE_NOT_REVOKED(Code)



SQL_STATE_SYNTAX_ERROR
final public static String SQL_STATE_SYNTAX_ERROR(Code)



SQL_STATE_TIMEOUT_EXPIRED
final public static String SQL_STATE_TIMEOUT_EXPIRED(Code)



SQL_STATE_TRANSACTION_RESOLUTION_UNKNOWN
final public static String SQL_STATE_TRANSACTION_RESOLUTION_UNKNOWN(Code)



SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE
final public static String SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE(Code)



SQL_STATE_WRONG_NO_OF_PARAMETERS
final public static String SQL_STATE_WRONG_NO_OF_PARAMETERS(Code)





Method Detail
convertShowWarningsToSQLWarnings
static SQLWarning convertShowWarningsToSQLWarnings(Connection connection) throws SQLException(Code)
Turns output of 'SHOW WARNINGS' into JDBC SQLWarning instances. If 'forTruncationOnly' is true, only looks for truncation warnings, and actually throws DataTruncation as an exception.
Parameters:
  connection - the connection to use for getting warnings. the SQLWarning chain (or null if no warnings)
throws:
  SQLException - if the warnings could not be retrieved



convertShowWarningsToSQLWarnings
static SQLWarning convertShowWarningsToSQLWarnings(Connection connection, int warningCountIfKnown, boolean forTruncationOnly) throws SQLException(Code)
Turns output of 'SHOW WARNINGS' into JDBC SQLWarning instances. If 'forTruncationOnly' is true, only looks for truncation warnings, and actually throws DataTruncation as an exception.
Parameters:
  connection - the connection to use for getting warnings.
Parameters:
  warningCountIfKnown - the warning count (if known), otherwise set it to 0.
Parameters:
  forTruncationOnly - if this method should only scan for data truncation warnings the SQLWarning chain (or null if no warnings)
throws:
  SQLException - if the warnings could not be retrieved, or if data truncationis being scanned for and truncations were found.



createCommunicationsException
public static SQLException createCommunicationsException(ConnectionImpl conn, long lastPacketSentTimeMs, Exception underlyingException)(Code)



createLinkFailureMessageBasedOnHeuristics
public static String createLinkFailureMessageBasedOnHeuristics(ConnectionImpl conn, long lastPacketSentTimeMs, Exception underlyingException, boolean streamingResultSetInPlay)(Code)
Creates a communications link failure message to be used in CommunicationsException that (hopefully) has some better information and suggestions based on heuristics.
Parameters:
  conn -
Parameters:
  lastPacketSentTimeMs -
Parameters:
  underlyingException -
Parameters:
  streamingResultSetInPlay -



createSQLException
public static SQLException createSQLException(String message, String sqlState)(Code)



createSQLException
public static SQLException createSQLException(String message)(Code)



createSQLException
public static SQLException createSQLException(String message, String sqlState, Throwable cause)(Code)



createSQLException
public static SQLException createSQLException(String message, String sqlState, int vendorErrorCode)(Code)



createSQLException
public static SQLException createSQLException(String message, String sqlState, int vendorErrorCode, boolean isTransient)(Code)



dumpSqlStatesMappingsAsXml
public static void dumpSqlStatesMappingsAsXml() throws Exception(Code)



get
static String get(String stateCode)(Code)



mysqlToSqlState
static String mysqlToSqlState(int errno, boolean useSql92States)(Code)
Map MySQL error codes to X/Open or SQL-92 error codes
Parameters:
  errno - the MySQL error code the corresponding X/Open or SQL-92 error code



Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.