{"id":117,"date":"2020-10-14T17:17:47","date_gmt":"2020-10-14T08:17:47","guid":{"rendered":"https:\/\/java.ihavenomoney.co.kr\/?p=117"},"modified":"2021-12-01T17:26:04","modified_gmt":"2021-12-01T08:26:04","slug":"uncategorizedsqlexception-%eb%94%94%eb%b9%84-%ec%97%b0%ea%b2%b0-%ec%97%90%eb%9f%ac","status":"publish","type":"post","link":"https:\/\/java.ihavenomoney.co.kr\/?p=117","title":{"rendered":"UncategorizedSQLException \ub514\ube44 \uc5f0\uacb0 \uc5d0\ub7ec"},"content":{"rendered":"<h4><span style=\"color: #ff6600;\">\ub514\ube44 Select \uc18c\uc2a4\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\uc2dc <\/span><\/h4>\n<pre class=\"lang:java decode:true\" title=\"UncategorizedSQLException\">10\uc6d4 14, 2020 2:20:44 \uc624\ud6c4 com.test.TEST.action.TESTScAction handleRequest\n\uc2ec\uac01:  Error : org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];   \n--- The error occurred in com\/test\/common\/sqlMap\/TESTSearch.xml.  \n--- The error occurred while executing query.  \n--- Check the    SELECT ...... FROM................  \n--- Check the SQL Statement (preparation failed).  \n--- Cause: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   \n--- The error occurred in com\/test\/common\/sqlMap\/TESTSearch.xml.  \n--- The error occurred while executing query.  \n--- Check the    SELECT........ FROM.................\n--- Check the SQL Statement (preparation failed).  \n--- Cause: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-118\" src=\"https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/Server_XML.jpg\" alt=\"\" width=\"796\" height=\"474\" srcset=\"https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/Server_XML.jpg 796w, https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/Server_XML-300x179.jpg 300w, https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/Server_XML-768x457.jpg 768w, https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/Server_XML-660x393.jpg 660w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/p>\n<h4><span style=\"color: #ff6600;\">Server.xml \ub0b4\uc6a9\uc911 HOST \ub0b4\uc6a9\uc5d0 \uc544\ub798 \ub514\ube44\uc5f0\uacb0 Resource \ud14c\uadf8 \ub0b4\uc6a9 \ucd94\uac00 <\/span><\/h4>\n<pre class=\"lang:java decode:true \">&lt;Host appBase=\"webapps\" autoDeploy=\"true\" name=\"localhost\" unpackWARs=\"true\"&gt;\n        \n      &lt;Valve className=\"org.apache.catalina.valves.AccessLogValve\" directory=\"logs\" pattern=\"%h %l %u %t &amp;quot;%r&amp;quot; %s %b\" prefix=\"localhost_access_log\" suffix=\".txt\"\/&gt;\n\n      &lt;Context docBase=\"test\" path=\"\/\" reloadable=\"true\" source=\"org.eclipse.jst.jee.server:test\"&gt;\n\t      &lt;Resource auth=\"Container\"\n\t                driverClassName=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\"\n\t                maxActive=\"50\"\n\t                maxIdle=\"20\"\n\t                maxWait=\"10000\"\n\t                name=\"jdbc\/TESTDB\"\n\t                password=\"**********\"\n\t                testOnBorrow=\"true\"\n\t                type=\"javax.sql.DataSource\"\n\t                url=\"jdbc:sqlserver:\/\/***.***.***.****;databaseName=TEST;\"\n\t                username=\"TESTUSER\"\/&gt;\n      &lt;\/Context&gt;\n      \n&lt;\/Host&gt;<\/pre>\n\n\n<p>\ucc38\uace0  : source=&#8221;org.eclipse.jst.jee.server:test&#8221;  \uc815\ubcf4 \ubc18\ub4dc\uc2dc \ud544\uc694<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub514\ube44 Select \uc18c\uc2a4\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\uc2dc 10\uc6d4 14, 2020 2:20:44 \uc624\ud6c4 com.test.TEST.action.TESTScAction handleRequest \uc2ec\uac01: Error : org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; &#8212; The error occurred in com\/test\/common\/sqlMap\/TESTSearch.xml. &#8212; The error occurred while executing query. &#8212; Check the SELECT &#8230;&#8230; FROM&#8230;&#8230;&#8230;&#8230;&#8230;. &#8212; Check the SQL Statement (preparation &hellip;<br \/><a href=\"https:\/\/java.ihavenomoney.co.kr\/?p=117\" class=\"more-link pen_button pen_element_default pen_icon_arrow_double\"><span class=\"screen-reader-text\">UncategorizedSQLException \ub514\ube44 \uc5f0\uacb0 \uc5d0\ub7ec<\/span> \ub354\ubcf4\uae30<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-117","post","type-post","status-publish","format-standard","hentry","category-eclipse--"],"_links":{"self":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=117"}],"version-history":[{"count":5,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":476,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions\/476"}],"wp:attachment":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}