id  = FINDJPDetailBasic
class  = jp.co.sra.tohoku.uedb.find.action.jp.FINDJPDetailAction
forward  = FINDJPDETAILBASIC

Exception

java.sql.SQLException: ERROR: invalid input syntax for integer: ""
 Query:  SELECT 	MS_SHOZOKU_TBL.USER_ID, 	GY_K_PSNINFO.PSN_NAME_GNG, 	GY_K_PSNINFO.PSN_NAME_KNA, 	GY_K_PSNINFO.PSN_NAME_RMN, 	(SELECT          NULLIF((CASE WHEN KEIRK_KBN='99' THEN SNTA_NAME_KNJ ELSE GET_JOSU_NAME_KNJ('0004', KEIRK_KBN) END),'')     FROM         GY_K_GKNAI_SHOKM_KEIRK SHOKM_KEIRK ,GY_K_KOKAI_STS KOKAI_STS     WHERE         SHOKM_KEIRK.USER_ID=MS_SHOZOKU_TBL.USER_ID     AND SHOKM_KEIRK.USER_ID=KOKAI_STS.USER_ID AND SHOKM_KEIRK.KOKAI_STS='3' AND SHOKM_KEIRK.SHOKM_KBN='1' AND 	SHOKM_KEIRK.SHOKM_FRM_YMD  <= '20190320' AND	SHOKM_KEIRK.SHOKM_TO_YMD  >= '20190320' 	) AS KEIRK_KBN_NAME,  (SELECT PSNINFO.BIRTHDAY_YMD          FROM GY_K_PSNINFO PSNINFO, GY_K_KOKAI_STS KOKAI_STS          WHERE PSNINFO.USER_ID = GY_K_PSNINFO.USER_ID          AND PSNINFO.USER_ID=KOKAI_STS.USER_ID          AND KOKAI_STS.GKGAI_BIRTHDAY_KOKAI='3'   ) AS BIRTHDAY,   (SELECT PSNINFO.E_MAIL          FROM GY_K_PSNINFO PSNINFO, GY_K_KOKAI_STS KOKAI_STS          WHERE PSNINFO.user_id = GY_K_PSNINFO.user_id          AND PSNINFO.USER_ID=KOKAI_STS.USER_ID          AND KOKAI_STS.GKGAI_EMAIL_KOKAI='3'   ) AS E_MAIL,   GY_K_PSNINFO.LABO_URL1,   GY_K_PSNINFO.LABO_URL2,   GY_K_PSNINFO.LABO_URL3, 	GET_ORG_NAME_KNJ(MS_SOSIKI_TBL.LVL2_ORG_CD) AS LVL2_ORG_NAME_KNJ, 	GET_ORG_NAME_KNJ(MS_SOSIKI_TBL.LVL3_ORG_CD) AS LVL3_ORG_NAME_KNJ, 	(CASE WHEN (JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL1_KYIK_TANTO_CD_GKSHI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_GKSHI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_GKSHI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_GKSHI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_GKSHI)) 		  THEN (GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_GKSHI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_GKSHI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_GKSHI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_GKSHI)) 		  ELSE '' END ) AS KYIK_TANTO_GKSHI ,	(CASE WHEN (JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL1_KYIK_TANTO_CD_ZENKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_ZENKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_ZENKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_ZENKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_ZENKI)) 		  THEN (GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_ZENKI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_ZENKI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_ZENKI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_ZENKI)) 		  ELSE '' END ) AS KYIK_TANTO_ZENKI ,	(CASE WHEN (JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL1_KYIK_TANTO_CD_KOKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_KOKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_KOKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_KOKI) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_KOKI)) 		  THEN (GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_KOKI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_KOKI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_KOKI) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_KOKI)) 		  ELSE '' END ) AS KYIK_TANTO_KOKI ,	(CASE WHEN (JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL1_KYIK_TANTO_CD_SENMN) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_SENMN) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_SENMN) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_SENMN) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_SENMN)) 		  THEN (GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_SENMN) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_SENMN) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_SENMN) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_SENMN)) 		  ELSE '' END ) AS KYIK_TANTO_SENMN ,	(CASE WHEN (JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL1_KYIK_TANTO_CD_SENKO) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_SENKO) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_SENKO) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_SENKO) AND			    JUDGE_YUKO_KYIK_TANTO(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_SENKO)) 		  THEN (GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL2_KYIK_TANTO_CD_SENKO) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL3_KYIK_TANTO_CD_SENKO) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL4_KYIK_TANTO_CD_SENKO) || ' ' || 				GET_KYIK_TANTO_NAME_KNJ(GY_K_PSNINFO.LVL5_KYIK_TANTO_CD_SENKO)) 		  ELSE '' END ) AS KYIK_TANTO_SENKO  FROM 	GY_K_PSNINFO AS GY_K_PSNINFO 	JOIN MS_USER_INFO_TBL AS MS_USER_INFO_TBL 	USING (USER_ID) 	JOIN MS_SHOZOKU_TBL AS MS_SHOZOKU_TBL	USING (USER_ID)	JOIN GY_K_KOKAI_STS AS GY_K_KOKAI_STS 	USING (USER_ID) 	JOIN MS_SOSIKI_TBL AS MS_SOSIKI_TBL 	USING (ORG_CD)  WHERE 	GY_K_PSNINFO.USER_ID = MS_USER_INFO_TBL.USER_ID 	AND MS_SHOZOKU_TBL.USER_ID = MS_USER_INFO_TBL.USER_ID 	AND MS_USER_INFO_TBL.USER_KBN = '1' 	AND MS_USER_INFO_TBL.GYSEKI_PRINT_FLG = '1' 	AND MS_SHOZOKU_TBL.SHOZOKU_KBN = '1' 	AND MS_SHOZOKU_TBL.ORG_CD = MS_SOSIKI_TBL.ORG_CD 	AND JUDGE_FRM_TO(MS_SOSIKI_TBL.TKY_FRM_YMD, MS_SOSIKI_TBL.TKY_TO_YMD, '99999999') 	AND ( 		JUDGE_FRM_TO(MS_SHOZOKU_TBL.TKY_FRM_YMD, MS_SHOZOKU_TBL.TKY_TO_YMD) 		OR  ( 			MS_SHOZOKU_TBL.TKY_FRM_YMD > '20190320' 			AND MS_SHOZOKU_TBL.IDO_KBN = '01' 		) 	) 	AND (MS_SHOZOKU_TBL.TAISK_YMD IS NULL OR TRIM(MS_SHOZOKU_TBL.TAISK_YMD) = '') 	AND EXISTS ( 		SELECT 			SHOZOKU.USER_ID 		FROM 			MS_SHOZOKU_TBL AS SHOZOKU 		WHERE 			( 				JUDGE_FRM_TO(SHOZOKU.TKY_FRM_YMD, SHOZOKU.TKY_TO_YMD) 				OR  ( 					SHOZOKU.TKY_FRM_YMD > '20190320' 					AND SHOZOKU.IDO_KBN = '01' 				) 			) 			AND ( 					(	(TRIM(SHOZOKU.TAISK_YMD)='' OR SHOZOKU.TAISK_YMD IS NULL) 						AND ( TRIM(SHOZOKU.RISHOK_RIYU_KBN) = '' OR SHOZOKU.RISHOK_RIYU_KBN IS NULL)) 				OR 					(	TRIM(SHOZOKU.RISHOK_RIYU_KBN) IN ('01', '02')) 			) 			AND SHOZOKU.SHOZOKU_KBN = '1' 			AND EXISTS 				(  				SELECT DISTINCT 					ORG_CD 				FROM 					MS_SOSIKI_TBL AS SOSIKI				WHERE 					( 						JUDGE_FRM_TO(TKY_FRM_YMD, TKY_TO_YMD) 						OR  ( 							TKY_FRM_YMD > '20190320' 							AND   KAIHAI_RIYU_KBN = '01') 						) 				AND SHOZOKU.ORG_CD = SOSIKI.ORG_CD				) 			AND GY_K_PSNINFO.USER_ID = SHOZOKU.USER_ID) 			AND MS_SHOZOKU_TBL.USER_ID ='' Parameters: []
	at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:330)
	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:213)
	at jp.co.sra.tohoku.ist.fw.db.ISTDBUtil.executeQuery(ISTDBUtil.java:40)
	at jp.co.sra.tohoku.ist.fw.action.ISTAbstractAction.executeQuery(ISTAbstractAction.java:121)
	at jp.co.sra.tohoku.uedb.find.action.jp.FINDJPDetailAction.searchPsninfoSosiki(FINDJPDetailAction.java:378)
	at jp.co.sra.tohoku.uedb.find.action.jp.FINDJPDetailAction.doExecute(FINDJPDetailAction.java:166)
	at jp.co.sra.tohoku.ist.fw.action.ISTBaseAction.execute(ISTBaseAction.java:143)
	at jp.co.sra.tohoku.ist.fw.action.ISTMainServlet.process(ISTMainServlet.java:71)
	at jp.co.sra.tohoku.ist.fw.action.ISTMainServlet.doGet(ISTMainServlet.java:37)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at jp.co.sra.tohoku.ist.fw.filter.ISTCheckScheduleFilter.doFilter(ISTCheckScheduleFilter.java:82)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at jp.co.sra.tohoku.ist.fw.filter.ISTSetCharacterEncodingFilter.doFilter(ISTSetCharacterEncodingFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
	at java.lang.Thread.run(Thread.java:662)
ISTActId :FINDJPDetailBasic