JDBCレイヤã§DBã®ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œã†sharding-jdbcを試ã—ã¦ã¿ãŸ - ãŸã‘ãžã†ç€•æ»ãƒ–ãƒã‚°DBã®ãƒ‡ãƒ¼ã‚¿é‡ãŒå¢—ãˆã¦ããŸå ´åˆã®å¯¾ç–ã®1ã¤ã¨ã—ã¦ãƒ¦ãƒ¼ã‚¶IDãªã©ã‚’ã‚ーã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’分割ã™ã‚‹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¨å‘¼ã°ã‚Œã‚‹æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ã“れをJDBCã®ãƒ¬ã‚¤ãƒ¤ã§å®Ÿç¾ã—ã¦ã—ã¾ã†sharding-jdbcã¨ã„ã†ãƒ©ã‚¤ãƒ–ラリを見ã¤ã‘ã¾ã—ãŸã€‚ github.com sharding-jdbcã¯ä¸å›½ã®dangdang（当当）ã¨ã„ã†EC大手ä¼æ¥ãŒé–‹ç™ºã—ãŸOSSã§ã€SQLをパースã—ã€SQLã«å«ã¾ã‚Œã‚‹ã‚·ãƒ£ãƒ¼ãƒ‰ã‚ーを抽出ã—ã¦æŽ¥ç¶šå…ˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ã€å‚ç…§ã™ã‚‹ãƒ†ãƒ¼ãƒ–ルを切り替ãˆã¦ãれるã¨ã„ã†ã‚‚ã®ã§ã™ã€‚ 使ã£ã¦ã¿ã‚‹ ã¾ãšã¯pom.xmlã«ä»¥ä¸‹ã®ä¾å˜é–¢ä¿‚ã‚’è¿½åŠ ã—ã¾ã™ã€‚ <dependency> <groupId>com.dangdang</groupId> <artifactId>sharding-jdbc-core</artifactId> <version>1.4.1</version> </dependency>
https://blogs.oracle.com/developers/post/entry/how_to_get_oracle_jdbc
{{#tags}}- {{label}}
{{/tags}}