Java + PostgreSQL 㧠BLOB を扱ㆠãã® 2 - MOYO Laboratory出ãŸ! (；´ー｀)y─┛~~ å‰å›žã€InputStream を使ã£ã¦å·¨å¤§ãƒ‡ãƒ¼ã‚¿ã‚’ BYTEA 型カラムã«æ ¼ç´å‡ºæ¥ãŸã‚ã‘ã ãŒã€ä»Šåº¦ã¯ä¿å˜ã—ãŸå†…容をå–り出ã™ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§å†ã³ OutOfMemoryError ãŒå§¿ã‚’ç¾ã—ãŸã€‚ ãªã‚“ã ã‹ã™ã”ーãå«Œãªäºˆæ„ŸãŒã™ã‚‹ã®ã ãŒâ€¦ã€€ã¨ã‚Šã‚ãˆãš 8.1 ドライãƒã®ã‚½ãƒ¼ã‚¹ã§ã‚‚見ã¦ã¿ã‚‹ã‹ã€‚ public InputStream getBinaryStream(int columnIndex) throws SQLException { // ... if (connection.haveMinimumCompatibleVersion("7.2")){ // Version 7.2 supports BinaryStream for // all PG bytea type As the spec/javadoc for // this method indicat
ç”»åƒã‚‚DBã«æ ¼ç´ã—ã¦ç®¡ç†ã™ã‚‹ ï¼æ‰±ã„ãŒã‚ã‚“ã©ã†ãªLOB(ラージオブジェクト)ã¯ä½¿ã‚ãªã„方法もå«ã‚
{{#tags}}- {{label}}
{{/tags}}