JAKARTAPROJECT
JAKARTA TIPJSP TIPJSP Áú¹®&´äº¯DATABASE TIPJAVASCRIPT TIPWEBHACKING TIP±âŸ TIP
JSP ÆÁ
JSP ÆÁ
JSP ÆÁ °Ô½ÃÆÇ ÀÔ´Ï´Ù
SQLException logging..
GoodBug
À̹ÌÁö ½½¶óÀÌ´õ º¸±â

SQLException ó¸®

 

try {

        ...

       // SQL ÀÛ¾÷

 

} catch (SQLException ex) {

        System.out.println ("\n*** SQLException caught ***\n");
 
        while (ex != null) {
           System.out.println ("SQLState: " + ex.getSQLState ());  //Retrieves the SQLState for this SQLException object
           System.out.println ("Message:  " + ex.getMessage ());
           System.out.println ("Vendor:   " + ex.getErrorCode ());
           ex.printStackTrace(); 
           ex = ex.getNextException ();  //Adds an SQLException object to the end of the chain.
           System.out.println ("");
        }  

} catch (Exception e) {

        ...

} finally {

        // connection release..

}

 

°á°ú

*** SQLException caught ***

SQLState: 23000
Message:  ORA-01401: ¿­¿¡ ÀÔ·ÂÇÑ °ªÀÌ ³Ê¹« Å®´Ï´Ù

Vendor:   1401
java.sql.SQLException: ORA-01401: ¿­¿¡ ÀÔ·ÂÇÑ °ªÀÌ ³Ê¹« Å®´Ï´Ù

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)

        ...

2005-12-02 14:22:00
211.189.124.***

 

ÁÁÀº»ý°¢ ^^

8Á¡ (1¸í)
SQLException logging.. GoodBug 2005-12-02
gallery 1.10 GoodBug 2005-08-26
µ¡±Û 0°³ | ÅÂ±× 0°³ | °ü·Ã±Ûº¸±â
ű×ÀÔ·Â
½±Ç¥(,)±¸ºÐÀ¸·Î Çѹø¿¡ ¿©·¯ ű׸¦ ÀÔ·ÂÇÒ¼ö ÀÖ½À´Ï´Ù
À̸§ ºñ¹Ð¹øÈ£
JSP ÆÁ
JSP ÆÁ °Ô½ÃÆÇ ÀÔ´Ï´Ù
! ¹øÈ£ Á¦¸ñ ±Û¾´ÀÌ ÀÏÀÚ Á¶È¸
114 STS Spring MVC on STS 2.8, 2.9 ¹öÀü¿¡¼­ ÇÁ·ÎÁ§Æ® »ý¼º½Ã ¿¡·¯¹ß»ý ÇÒ °æ¿ì 1 GoodBug 2012-03-08 8,112
113 dbcp DBCP »ç¿ë½Ã DBÁ¤º¸ ¾Ïȣȭ 1 GoodBug 2012-02-08 5,617
112 ½ºÆ®·µÃ÷ action alert ¸Þ½ÃÁö Ãâ·Â ÈÄ ÆäÀÌÁö À̵¿ & µÚ·Î°¡±â ¿¹¹æ ÇູÇѱ¤´ë 2009-01-14 11,643
111 spring spring ÀÚµ¿¹­±â 1 kaiser 2007-03-12 11,853
110 spring Spring ºó¹­±â- »ý¼ºÀÚ¸¦ ÅëÇÑ ÀÇÁ¸¼º ÁÖÀÔ 2 1 kaiser 2007-02-21 21,611
109 spring Spring ºó¹­±â-¼¼Å͸޼ҵ带 ÅëÇÑ ÀÇÁ¸¼º ÁÖÀÔ 1 kaiser 2007-02-21 11,909
108 spring Spring - xml·Î ¹­±â 1 kaiser 2007-02-07 12,406
107 spring Spring ºó¹­±â-±âº»¹­±â 1 kaiser 2007-02-05 8,817
106 spring spring ºó¹­±â-2 1 kaiser 2007-01-29 9,683
105 spring Spring ºó¹­±â-1 1 kaiser 2007-01-29 9,748
104 spring Spring 1Â÷ ¿ä¾à 1 kaiser 2007-01-23 10,869
103 spring spring ½ÃÀÛÇϱâ-2 1 1 kaiser 2007-01-22 9,970
102 spring Spring ½ÃÀÛÇϱâ-1 4 1 kaiser 2007-01-22 11,687
101 spring Spring ¼­·Ð - spring ¼³Ä¡ 1 1 kaiser 2007-01-19 13,361
100 clob »ç¿ëÇϱâ kaiser 2008-08-21 7,679
99 span ±Û¾²±â ÈÄ »ç¿ëÇÒ protoload 1 1 °í°í½Ì 2008-05-09 7,185
98 log4sql log4sql 1 1 Aki 2008-04-30 8,403
97 ¼ýÀÚ ¼¼ÀÚ¸®¸¶´Ù ÄÞ¸¶ Âï±â 1 °ö½½´ë¸¶¿Õ 2008-03-21 8,527
96 iBatis iBatis ¿¡¼­ SQL ·Î±ë½Ã ÀÌ»Ñ°Ô º¸À̱â 6 1 GoodBug 2007-10-26 22,610
95 log4sql¿äÁò ¸¹ÀÌ ¾²´Â°Í °°´øµ¥.... ¿µÀ̳²Ç¦ 2008-10-17 8,132
copyright 2005-2024 by Unicorn