The XML data type is used for Extensible Markup Language (XML) documents.
Derbyã?§ã?¯JDBCã?«ã?¦ã€?SQL/XMLを扱ã?†æ©Ÿèƒ½ã?Œå®Ÿè£…ã?•れã?¦ã?„ã?ªã?„ã?®ã?§ã€?XMLã?®å€¤ã‚’直接ãƒ?インドã?—ã?Ÿã‚Šã€?JDBCã?®çµ?果セットã?‹ã‚‰ç›´æŽ¥XMLã?®å€¤ã‚’å?–å¾—ã?™ã‚‹ã?“ã?¨ã?¯ä¸?å?¯èƒ½ã?§ã?™ã€‚ ã??ã?®ä»£ã‚?りã?«ã€?XMLPARSEã‚„XMLSERIALIZEç‰ã?®é?©åˆ‡ã?ªXMLã?®æ¼”ç®—å?を明示的ã?«SQLã?«æ›¸ã?„ã?¦ã€?XMLã?®æƒ…å ±ã‚’Javaã?®æ–‡å—列や文å—ã?®ã‚¹ãƒˆãƒªãƒ¼ãƒ ã?¨ã?—ã?¦ã€?ãƒ?インドã?—ã?Ÿã‚Šå?–å¾—ã?™ã‚‹å¿…è¦?ã?Œã?‚りã?¾ã?™ã€‚
XML
ç„¡ã?—
XMLã?®å€¤ã?«å¯¾å¿œã?™ã‚‹Javaã?®åž‹ã?®java.sql.SQLXMLã?¯å˜åœ¨ã?—ã?¾ã?™ã€‚ã?—ã?‹ã?—ã€?java.sql.SQLXMLåž‹ã?¯Derbyã?«ã?¦ã‚µãƒ?ートã?•れã?¦ã?„ã?¾ã?›ã‚“。
ç„¡ã?—
XMLã?®å€¤ã?«å¯¾å¿œã?™ã‚‹ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿åž‹ã?®SQLXMLã?¯å˜åœ¨ã?—ã?¾ã?™ã€‚ã?—ã?‹ã?—ã€?SQLXMLã?¯Derbyã?«ã?¦ã‚µãƒ?ートã?•れã?¦ã?„ã?¾ã?›ã‚“。
SELECT XMLSERIALIZE (xcol as CLOB) FROM myXmlTableã?“ã?†ã?™ã‚‹ã?“ã?¨ã?§ã€?直列化ã?—ã?Ÿåž‹ã?«å¯¾å¿œã?™ã‚‹getXXXメソッドを使ã?£ã?¦ã€?XMLã?®å€¤ã‚’ã€?å?–å¾—ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ã?“ã?®ä¾‹ã?§ã?¯CLOBåž‹ã?¨ã?ªã‚Šã?¾ã?™ã€‚
INSERT INTO myXmlTable(xcol) VALUES XMLPARSE( DOCUMENT CAST (? AS CLOB) PRESERVE WHITESPACE)ã??ã?—ã?¦ã€?æ–‡å—列ã?®åž‹ã?¨äº’æ?›æ€§ã?®ã?‚ã‚‹setXXXメソッドを使ã?£ã?¦ã??ã? ã?•ã?„。 ã?“ã?®ä¾‹ã?§ã?¯PreparedStatement.setStringã?¾ã?Ÿã?¯PreparedStatement.setCharacterStreamメソッドを使ã?£ã?¦ã€?演算å?ã?«å€¤ã‚’与ã?ˆã?¾ã?™ã€‚