SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTYシステム手続ã??を使ã?£ã?¦ã€?ç?¾åœ¨ã?®æŽ¥ç¶šã?—ã?¦ã?„るデータベースã?®å±žæ€§å€¤ã‚’è¨å®š/削除ã?—ã?¾ã?™ã€‚
"VALUE"ã?Œnullã?§ã?¯ã?ªã?„ã?¨ã??ã?¯ã€?"KEY"ã?§ã‚ー値を与ã?ˆã‚‰ã‚Œã?Ÿå±žæ€§å€¤ã?Œã€?"VALUE"ã?«è¨å®šã?•れã?¾ã?™ã€‚"VALUE"ã?Œnullã?®æ™‚ã?¯ã€?"KEY"ã?§ã‚ー値を与ã?ˆã‚‰ã‚Œã?Ÿå±žæ€§å€¤ã?¯ã€?データベースã?®å±žæ€§å€¤é›†å?ˆã?‹ã‚‰å‰Šé™¤ã?•れã?¾ã?™ã€‚
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN KEY VARCHAR(128), IN VALUE VARCHAR(32672))
ã?“ã?®æ‰‹ç¶šã??ã?¯çµ?果を返ã?—ã?¾ã?›ã‚“。
derby.locks.deadlockTimeout属性を10ã?¨ã?„ã?†å€¤ã?«è¨å®šã?—ã?¾ã?™ã€‚
CallableStatement cs = conn.prepareCall ("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?, ?)"); cs.setString(1, "derby.locks.deadlockTimeout"); cs.setString(2, "10"); cs.execute(); cs.close();
derby.locks.deadlockTimeout属性を10ã?¨ã?„ã?†å€¤ã?«è¨å®šã?—ã?¾ã?™ã€‚
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY ('derby.locks.deadlockTimeout', '10');