|
Problem(Abstract) |
What are the current SQLCodes that are mapped to the
WebSphere Application Server specific exceptions for the supported
databases? |
|
|
|
Resolving the
problem |
All Databases:
"57011", ResourceAllocationException
"57030", ResourceAllocationException
"55032", StaleConnectionException
"08001", StaleConnectionException
"08003", StaleConnectionException
"40003", StaleConnectionException
"S1000", StaleConnectionException
"08S01", StaleConnectionException
"23505", DuplicateKeyException
"08006", StaleConnectionException
DB2® Portability Layer:
-803, DuplicateKeyException
-601, TableAlreadyExistsException
-954, ResourceAllocationException
-1040, ResourceAllocationException
-624, PrimarykeyAlreadyDefinedException
-204, TableDoesNotExistException
// This list was obtained from DB2 and Net.Commerce contacts; these
// are the codes which they trap to tolerate HACMP failover
-1015, StaleConnectionException
-1034, StaleConnectionException
-1035, StaleConnectionException
-6036, StaleConnectionException
-30081,StaleConnectionException
-1224, StaleConnectionException
-1229, StaleConnectionException
"58004", StaleConnectionException
"08S01", StaleConnectionException
DataDirect (MERANT) Portability Layer:
2251, StaleConnectionException
2306, StaleConnectionException
2310, StaleConnectionException
2311, StaleConnectionException
Microsoft® SQL Server Portability Layer:
2714, TableAlreadyExistsException
2627, DuplicateKeyException
4, ResourceAllocationException
"08S01", StaleConnectionException
230, StaleConnectionException
1779, PrimarykeyAlreadyDefinedException
3701, TableDoesNotExistException
208, TableDoesNotExistException
4902, TableDoesNotExistException
Oracle® Portability Layer:
1, DuplicateKeyException
955, TableAlreadyExistsException
2260, PrimarykeyAlreadyDefinedException
942, TableDoesNotExistException
1000, ResourceAllocationException
20, ResourceAllocationException
28, StaleConnectionException
1012, StaleConnectionException
1014, StaleConnectionException
1033, StaleConnectionException
1034, StaleConnectionException
1035, StaleConnectionException
1089, StaleConnectionException
1090, StaleConnectionException
1092, StaleConnectionException
2068, StaleConnectionException
3113, StaleConnectionException
3114, StaleConnectionException
12541, StaleConnectionException
12560, StaleConnectionException
12571, StaleConnectionException
17002, StaleConnectionException
17008, StaleConnectionException
17009, StaleConnectionException
17410, StaleConnectionException
17401, StaleConnectionException
"Connection reset by peer", StaleConnectionException
Sybase® Portability Layer:
2601, DuplicateKeyException
2714, TableAlreadyExistsException
"JZ006", StaleConnectionException
"JZ006", "MaybeStale"
"JZ0C1", StaleConnectionException
"JZ0B1", StaleConnectionException
"JZ0C0", StaleConnectionException
1923, PrimarykeyAlreadyDefinedException
3701, TableDoesNotExistException
208, TableDoesNotExistException
Informix® Portability Layer:
43012, StaleConnectionException
-908, StaleConnectionException
-25580, StaleConnectionException
-27002, StaleConnectionException
-43207, StaleConnectionException
-79716, StaleConnectionException
-79735, StaleConnectionException
-268, DuplicateKeyException
-310, TableAlreadyExistsException
-704, PrimarykeyAlreadyDefinedException
-206, TableDoesNotExistException |
|
|
|
|
Cross Reference information |
Segment |
Product |
Component |
Platform |
Version |
Edition |
Application Servers |
Runtimes for Java Technology |
Java SDK |
|
|
|
|
|
|