XMLPARSEã?¯ã€?æ–‡å—列å¼?を構文解æž?ã?—ã?¦DerbyXML値ã?«ã?™ã‚‹SQL/XML演算å?ã?§ã?™ã€‚
ã?“ã?®æ¼”ç®—å?ã?®çµ?果を一時的ã?ªå€¤ã?¨ã?—ã?¦ä½¿ã?†ã?“ã?¨ã‚‚ã?§ã??ã?¾ã?™ã?—ã€?Derbyã?®XML列ã?«å€¤ã‚’æ ¼ç´?ã?™ã‚‹ã?“ã?¨ã‚‚ã?§ã??ã?¾ã?™ã€‚ 一時的ã?‹æ°¸ç¶šçš„ã?‹ã?«ã?‹ã?‹ã‚?らã?šã€?XMLã?®å€¤ã‚’XMLEXISTSã‚„XMLQUERYã?®ã‚ˆã?†ã?ªã€?ä»–ã?®DerbyXML演算å?ã?®å…¥åŠ›ã?¨ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚
XMLPARSE (DOCUMENT æ–‡å—列値å¼? PRESERVE WHITESPACE)
ã?“ã?®çœ?ç•¥ã?§ã??ã?ªã?„ã‚ーワードã?«ã‚ˆã‚Šã€?Derbyã?Œæ§‹æ–‡è§£æž?ã?§ã??ã‚‹XMLã?®å…¥åŠ›ã?®ã‚¿ã‚¤ãƒ—ã?Œè¨˜è¿°ã?•れã?¾ã?™ã€‚ Derbyã?Œæ§‹æ–‡è§£æž?å?¯èƒ½ã?ªæ–‡å—列å¼?ã?¯ã€?æ•´å½¢å¼?ã?®XML文書を構æˆ?ã?™ã‚‹ã‚‚ã?®ã?«é™?られã?¾ã?™ã€‚ ã?“れã?¯ã€?Derbyã?ŒJAXP構文解æž?器を使ã?£ã?¦æ–‡å—列を構文解æž?ã?—ã?¦ã?„ã‚‹ã?‹ã‚‰ã?§ã?™ã€‚ JAXP構文解æž?器ã?¯ã€?æ–‡å—列値å¼?ã?Œæ•´å½¢å¼?ã?®XML文書を構æˆ?ã?™ã‚‹ã?“ã?¨ã‚’期待ã?—ã?¾ã?™ã€‚ ã‚‚ã?—æ–‡å—列ã?Œæ•´å½¢å¼?ã?®XML文書を構æˆ?ã?—ã?ªã?„å ´å?ˆã€?JAXPã?¯ã‚¨ãƒ©ãƒ¼ã‚’挙ã?’ã?¾ã?™ã€‚ Derbyã?¯ã??ã?®ã‚¨ãƒ©ãƒ¼ã‚’補足ã?—ã?¦ã€?SQLExceptionã?¨ã?—ã?¦ã‚¨ãƒ©ãƒ¼ã‚’挙ã?’ã?ªã?Šã?—ã?¾ã?™ã€‚
æ•´å½¢å¼?ã?®XML文書ã?«ã?¤ã?„ã?¦ã?¯ã€?次ã?®ä»•様をå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。http://www.w3.org/TR/REC-xml/#sec-well-formed .
INSERT INTO x_table VALUES (1, XMLPARSE(DOCUMENT ' <roster> <student age="18">AB</student> <student age="23">BC</student> <student>NOAGE</student> </roster>' PRESERVE WHITESPACE) )
INSERT INTO x_table VALUES (2, XMLPARSE (DOCUMENT CAST (? AS CLOB) PRESERVE WHITESPACE) )��文���setCharacterStream()メソッドや�型変���対照型��能�JDBC�他�setXXXメソッドを使���値を与�る必���り��。
Derbyã?®XML機能ã?Œå‹•作ã?™ã‚‹ã?Ÿã‚?ã?«ã?¯ã€?Apache Xercesã?®ã‚ˆã?†ã?ªJAXP構文解æž?器ã?Šã‚ˆã?³Apache Xalanã?ŒJavaã?®ã‚¯ãƒ©ã‚¹ãƒ‘スã?«è¨˜è¿°ã?•れã?¦ã?„ã‚‹å¿…è¦?ã?Œã?‚りã?¾ã?™ã€‚ã‚‚ã?—ã?©ã?¡ã‚‰ã?‹ã?Œæ¬ ã?‘ã?¦ã?„ã‚‹ã?¨ã€?XMLPARSE演算å?を使ã?Šã?†ã?¨ã?—ã?Ÿã?¨ã??エラーã?Œç™ºç”Ÿã?—ã?¾ã?™ã€‚