디비 Select 소스에서 다음과 같은 에러시
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
10월 14, 2020 2:20:44 오후 com.test.TEST.action.TESTScAction handleRequest 심각: Error : org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in com/test/common/sqlMap/TESTSearch.xml. --- The error occurred while executing query. --- Check the SELECT ...... FROM................ --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/test/common/sqlMap/TESTSearch.xml. --- The error occurred while executing query. --- Check the SELECT........ FROM................. --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null' |
Server.xml 내용중 HOST 내용에 아래 디비연결 Resource 테그 내용 추가
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
<Host appBase="webapps" autoDeploy="true" name="localhost" unpackWARs="true"> <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" pattern="%h %l %u %t "%r" %s %b" prefix="localhost_access_log" suffix=".txt"/> <Context docBase="test" path="/" reloadable="true" source="org.eclipse.jst.jee.server:test"> <Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="50" maxIdle="20" maxWait="10000" name="jdbc/TESTDB" password="**********" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:sqlserver://***.***.***.****;databaseName=TEST;" username="TESTUSER"/> </Context> </Host> |
참고 : source=”org.eclipse.jst.jee.server:test” 정보 반드시 필요
댓글