SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in /com/symphox/web/mall/showroom/ibatis/product.xml. --- The error occurred while executing query. --- Check the select D.cpdt_num from ce_prodetail D INNER JOIN CE_TREEMALLHALL_NEW H ON D.CPRO_NUM = H.CPRO_NUM where D.cpro_num = (select cpro_num from ce_prodetail where cpdt_num = ? ) and D.cpdt_owner = (select cpdt_owner from ce_prodetail where cpdt_num = ? ) and D.cpdt_num != ? and D.cpdt_searchflag = 'Y' and sysdate between D.cpdt_startday and D.cpdt_endday and D.cpdt_check = '3' and h.cpse_id != 'W0' and rownum = 1 . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.120)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.121)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = istore))) DSRA0010E: SQL 狀態 = null,錯誤碼 = 0; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in /com/symphox/web/mall/showroom/ibatis/product.xml. --- The error occurred while executing query. --- Check the select D.cpdt_num from ce_prodetail D INNER JOIN CE_TREEMALLHALL_NEW H ON D.CPRO_NUM = H.CPRO_NUM where D.cpro_num = (select cpro_num from ce_prodetail where cpdt_num = ? ) and D.cpdt_owner = (select cpdt_owner from ce_prodetail where cpdt_num = ? ) and D.cpdt_num != ? and D.cpdt_searchflag = 'Y' and sysdate between D.cpdt_startday and D.cpdt_endday and D.cpdt_check = '3' and h.cpse_id != 'W0' and rownum = 1 . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.120)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.121)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = istore))) DSRA0010E: SQL 狀態 = null,錯誤碼 = 0