日期:2014-05-17  浏览次数:21214 次

请问如何得到Oracle SQLException的errorCode, 用SQLException.getErrorcode() 总是返回0
请问如何得到Oracle SQLException的errorCode, 用SQLException.getErrorcode() 总是返回0

例如有如下Oracle Exception:
org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
pacwas1:1521:testdb
); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
xxx:1521:xxx
))

当Catch到这个SQLException并且使用getErrorcode() 总是返回0,但我期待的是ORA-12505,请问有好的方法吗?


------解决方案--------------------
try{...}
catch(SQLException e) {System.out.println(e.getMessage);}