id  = FINDENDetail
class  = jp.co.sra.tohoku.uedb.find.FINDENDetailAction
forward  = FINDENDETAIL

Exception

java.sql.SQLException: ERROR: invalid input syntax for integer: "" Query:  SELECT 	MS_SHOZOKU_TBL.USER_ID, 	GY_K_PSNINFO.PSN_NAME_RMN, 	(CASE WHEN GY_K_PSNINFO.GKNAI_SHOKM_KBN='99' THEN GY_K_PSNINFO.GKNAI_SHOKM_SNTA_NAME_ENG 		ELSE GET_JOSU_NAME_ENG('0004', GY_K_PSNINFO.GKNAI_SHOKM_KBN) END) 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.SORAN_BIRTHDAY_KOKAI='2'   ) AS BIRTHDAY,   (SELECT PSNINFO.LABO_TEL_ENG          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.SORAN_LABO_TEL_KOKAI='2'   ) AS LABO_TEL,   (SELECT PSNINFO.LABO_FAX_ENG          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.SORAN_LABO_FAX_KOKAI='2'   ) AS LABO_FAX,   (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.SORAN_EMAIL_KOKAI='2'   ) AS E_MAIL,   (SELECT PSNINFO.LABO_URL          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.SORAN_LABO_URL_KOKAI='2'   ) AS LABO_URL,   (SELECT PSNINFO.PSN_PHOTO          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.SORAN_PSN_PHOTO_KOKAI='2'   ) AS PSN_PHOTO, 	GET_ORG_NAME_ENG(MS_SOSIKI_TBL.LVL2_ORG_CD) AS LVL2_ORG_NAME_ENG, 	GET_ORG_NAME_ENG(MS_SOSIKI_TBL.LVL3_ORG_CD) AS LVL3_ORG_NAME_ENG  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 > '20190425' 			AND MS_SHOZOKU_TBL.IDO_KBN = '01' 		) 	) 	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 > '20190425' 					AND SHOZOKU.IDO_KBN = '01' 				) 			) 			AND ( 					(	TRIM(SHOZOKU.TAISK_YMD)='' 						AND TRIM(SHOZOKU.RISHOK_RIYU_KBN) = '') 				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 > '20190425' 							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.FINDENDetailAction.searchPsninfoSosiki(FINDENDetailAction.java:292)
	at jp.co.sra.tohoku.uedb.find.FINDENDetailAction.doExecute(FINDENDetailAction.java:111)
	at jp.co.sra.tohoku.ist.fw.action.ISTBaseAction.execute(ISTBaseAction.java:140)
	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:624)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at jp.co.sra.tohoku.ist.fw.filter.ISTCheckScheduleFilter.doFilter(ISTCheckScheduleFilter.java:82)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at jp.co.sra.tohoku.ist.fw.filter.ISTSetCharacterEncodingFilter.doFilter(ISTSetCharacterEncodingFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
ISTActId :FINDENDetail