僕ãŒOracleを使ã‚ãªã„ç†ç”±ã“ã“ã¯ã€åƒ•ãŒOracleを使ã„ãŸããªã„ç†ç”±ã‚’ã©ã‚“ã©ã‚“挙ã’ã¦ã„ã“ã†ã¨ã„ã†ã‚³ãƒ¼ãƒŠãƒ¼ã§ã™(笑)。 ã¨ã¯ã„ã£ã¦ã‚‚僕ã¯å®Ÿéš›ç¾å ´ã§ã¯Oracleを使ã†ç¾½ç›®ã«ãªã£ã¦ã„ã‚‹ã®ã§ 実際ã«ä½¿ã£ã¦ã¿ã¦é§„ç›®ã ã¨æ„Ÿã˜ãŸç‚¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ æ–°ã—ã書ã„ãŸã‚‚ã®ãŒã€Œä¸Šã€ã«ãªã‚‹ã‚ˆã†ã«ä¸¦ã¹ã¦ã„ãã¾ã™ã€‚ PreparedStatement 㧠CHAR 型を使ã†ã¨ã Oracle ã® JDBC ã§ã‚‚当然 PreparedStatement ã¯ä½¿ãˆã¾ã™ã€‚ SELECT * FROM XXX WHERE NAME=? ã®ã‚ˆã†ã«ã€? を使ã£ãŸãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã«ã‚ˆã‚‹SQL文発行ãŒã§ãã¾ã™ã€‚ ã¨ã“ã‚ãŒã€ã“ã®æ©Ÿèƒ½ã«ã¨ã‚“ã§ã‚‚ãªã„ãƒã‚°ãŒã‚ã‚Šã¾ã™ã€‚ NAMEカラム㌠CHAR(10) ã ã£ãŸã¨ã—ã¾ã—ょã†ã€‚ PreparedStatement stmt = conn.preparedStatement("SELECT * FROM XXX WH
Oracle Open Source
EC2ã§Oracleã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—サイトを構築ã—マルãƒã‚µã‚¤ãƒˆé‹ç”¨ã‚’実ç¾ã™ã‚‹ at nkjmkzk.net
Tuning RHEL for Oracle V1 10-01-2007
{{#tags}}- {{label}}
{{/tags}}