[B! java][JDBC] clavierã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

clavier id:clavier

javaã¨JDBCã«é–¢ã™ã‚‹clavierã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Java ã„ã¾ãµãŸãŸã³ã®JDBC
ã“ã®è¨˜äº‹ã¯ Java Advent Calendar 2018 ã® 9 æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã™ã€‚ æµè¡Œã‚’ã¨ã‚‰ãˆãŸè©±é¡ŒãŒå¤šã„ãªã‹ã€10~15å¹´å‰æ„Ÿã®ã‚ã‚‹ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã§ã™ã€‚åŒ–çŸ³ã§ã™ã€‚ ã—ã‹ã—åŒ–çŸ³ã¨ã¯ã„ãˆã€ã‚ˆãä½¿ã†æŠ€è¡“ã§ã¯ã‚ã‚Šã¾ã™ã€‚ ã¨ã„ã†ã“ã¨ã§ã€ä½•æ°—ãªãä½¿ã£ã¦ãŸã‘ã©æ”¹ã‚ã¦å‹‰å¼·ã—ç›´ã—ã¾ã—ãŸã€‚ æ¤œè¨¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³java 1.8.0_181JDBCãƒ‰ãƒ©ã‚¤ãƒ postgresql 42.2.5PostgreSQL 10.5 è‡ªå‰ãƒ“ãƒ«ãƒ‰æ¤œè¨¼ç’°å¢ƒJavaå‹•ä½œç’°å¢ƒ Windows 10 Pro ver.1803CPU 4ã‚³ã‚¢(Hyper-Vã¨å…±ç”¨)RAM 16GB(ã†ã¡ã€Hyper-Vã¸8GBå‰²ã‚Šå½“ã¦)Intel Core i5-4690 CPU 3.50GHzSSDPostgreSQLå‹•ä½œç’°å¢ƒ Hyper-V ä»®æƒ³ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹CentOS Linux release 7.1.1503 (Core)CPU 4ã‚³ã‚¢
clavier 2019/12/08
postgresql

java

jdbc

ã‚ã¨ã§èªã‚€

*ã‚ã¨ã§
ãƒªãƒ³ã‚¯
S2DBCPã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®å®Ÿè£…ã‚’èªã‚“ã§ã¿ãŸ - wyukawa's diary
Slim3ã¨ã¯ç•°ãªã‚ŠS2DBCP ã§ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã•ã‚Œã‚‹ã®ã¯ç‰©ç†ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ (XAConnection) ã§ã¯ãªãã¦è«–ç†ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ (Connection) ãã€‚ã‚ã¨ConnectionEventListenerã®ä»•æŽ›ã‘ã¯ä½¿ã£ã¦ãªã„ã€‚JDBCã®ä»•æ§˜æ›¸ã‚’ã±ã‚‰ã£ã¨è¦‹ã‚‹é™ã‚ŠSlim3ã®ã»ã†ãŒç´ ç›´ã«å®Ÿè£…ã—ã¦ã„ã‚‹æ„Ÿã˜ã€‚ DataSourceï¼ˆå®Ÿæ…‹ã¯DataSourceImplã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ConnectionPoolImplã®è–„ã„ãƒ©ãƒƒãƒ‘ãƒ¼ï¼‰#getConnectionãŒå‘¼ã°ã‚Œã‚‹ã¨ã‚ã¨ã¯ConnectionPoolImpl#checkOutã«ãŠã¾ã‹ã›ã€‚ public Connection getConnection() throws SQLException { Connection con = connectionPool.checkOut(); return con; }
clavier 2016/02/09
Seasar

jdbc

database

java
ãƒªãƒ³ã‚¯
Tomcat JDBC Connection Poolã§é€šå¸¸ã®Javaãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰PostgreSQL 9.3ã«æŽ¥ç¶šã™ã‚‹
Tomcat JDBC Connection Poolã§é€šå¸¸ã®Javaãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰PostgreSQL 9.3ã«æŽ¥ç¶šã™ã‚‹ ä¹…ã—ã¶ã‚Šã«Tomcatã‚’è§¦ã£ã¦çŸ¥ã£ãŸã®ã§ã™ãŒã€Tomcat 7.0.19ä»¥é™ã¯ç‹¬è‡ªã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ åŒæ¢±ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã‚“ã§ã™ãã€‚ Commons DBCPã‚’è¶…ãˆã‚‹Tomcat JDBC Poolã¨ã¯ å‹‰å¼·ãŒã¦ã‚‰ã€ç´ ã®Javaã‹ã‚‰ä½¿ã£ã¦ã¿ã¾ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ãƒ—ãƒã‚°ãƒ©ãƒ ãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã€ã“ã¡ã‚‰ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚è€ƒã«ã—ã¾ã—ãŸã€‚ã¨ã„ã†ã‹ãã®ã¾ã¾ã§ã™ã€‚ The Tomcat JDBC Connection Pool ä»Šå›žã¯ã€PostgreSQL 9.3ã¸ã®æŽ¥ç¶šã‚’ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ å®Ÿè¡Œã«å¿…è¦ãªjarãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€PostgreSQL JDBCãƒ‰ãƒ©ã‚¤ãƒ FreeBSD + PostgreSQL 9.3.2 ã«Javaã§æŽ¥ç¶šã™ã‚‹ ã“ã¡ã‚‰ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã€Œpost
clavier 2016/02/09
JDBC

Tomcat

Java

database
ãƒªãƒ³ã‚¯
mysql Connector/J ã®è¨å®šã§åŠ¹ããã†ãªã‚„ã¤ - ãã®æ‰‹ã®å¹³ã¯å°»ã‚‚ã¤ã‹ã‚ã‚‹ã•
mysql Connector/J ã‚’ä½¿ã†æ™‚ã«è‰²ã€…åŠ¹ããã† (ã‚ã‚‹ã„ã¯åŠ¹ã‹ãªãã†) ãªè¨å®šé …ç›®ã‚’èª¿ã¹ãŸã®ã§ã¾ã¨ã‚ã¦ãŠãã“ã¨ã¨ã—ã¾ã™ï¼ŽãªãŠï¼Œå¯¾è±¡ã¨ã—ã¦ã„ã‚‹ mysql ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯5.6 (ä»¥é™)ï¼ŒConnector/J ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯5.1.34 (ä»¥é™) ã§ã™ï¼Ž Connector/J ã¯è¨å®šã§ãã‚‹é …ç›®ãŒå¤šãã¦è¿·ã£ã¦ã—ã¾ã†ã‚“ã§ã™ãŒï¼Œé“æ¨™ã¨ãªã‚‹è³‡æ–™ã‚‚å¹¾ã¤ã‹ã‚ã‚‹ã®ã§ãã‚Œã«ã¤ã„ã¦ã‚‚ã¾ã¨ã‚ã¦ãŠãã¾ã™ï¼Ž ä½•ã‹è¿½è¨˜ã™ã¹ãäº‹é …ãŒã‚ã£ãŸã‚‰é©å®œè¿½åŠ ã—ã¦ã‚†ããŸã„ã¨æ€ã£ã¦ã„ã¾ã™ï¼Žã€Œã“ã‚Œã‚‚å…¥ã‚ŒãŸã»ã†ãŒè‰¯ã„ã®ã§ã¯ç„¡ã„ã‹ã€ã¨ã„ã†ã‚ˆã†ãªã”æŒ‡æ‘˜ã‚ã‚Šã¾ã—ãŸã‚‰ã”ä¸€å ±ãã ã•ã„ï¼Ž è¨å®šé …ç›® characterEncoding ãŠãªã˜ã¿ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ï¼Žè¦è¨å®šï¼Ž ã¡ãªã¿ã«ä»¥ä¸‹ã®æ§˜ãªãƒ†ã‚¯ãŒã‚ã‚‹ï¼Ž Driver doesn't support utf8mb4 for servers 5.5.2 and newer. The drive
clavier 2015/12/26
MySQL

JDBC

java
ãƒªãƒ³ã‚¯
Javaã§kamipo traditionalã‚’æœ‰åŠ¹ã«ã™ã‚‹ - ãã®æ‰‹ã®å¹³ã¯å°»ã‚‚ã¤ã‹ã‚ã‚‹ã•
kamipo traditional ã«ã¤ã„ã¦ã¯ä»¥ä¸‹ã®è¨˜äº‹ãŒè©³ã—ã„ï¼Ž ãƒ«ãƒ¼ã‚¯ï¼MySQLã§ã¯kamipo TRADITIONALã‚’ä½¿ãˆï¼ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€… ã¨ã“ã‚ã§ã“ã‚Œã‚’Javaï¼Œã¨ã„ã†ã‹JDBCã§æœ‰åŠ¹ã«ã™ã‚‹ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«æ›¸ã„ã¦ã‚„ã‚‹ã¨ã‚ˆã‚ã—ã„ï¼Ž try (final PreparedStatement preparedStatement = connection.prepareStatement( "SET SESSION sql_mode = 'TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY';")) { // This is "kamipo TRADITIONAL". More strict, healthy, nice. // https://github.com/kamipo/etcfiles/blob/
clavier 2015/07/08
Javaã§kamipo traditionalã‚’æœ‰åŠ¹ã«ã™ã‚‹ - ãã®æ‰‹ã®å¹³ã¯å°»ã‚‚ã¤ã‹ã‚ã‚‹ã•

java

jdbc

MySQL
ãƒªãƒ³ã‚¯
MySQL Connector/J (JDBC ãƒ‰ãƒ©ã‚¤ãƒ)ã®ç½ ã¾ã¨ã‚ - ~saiya/hatenablog
MySQL JDBC ãƒ‰ãƒ©ã‚¤ãƒ(MySQL Connector/J)ã€Java ã§ MySQL ã¨ã„ãˆã°ã¾ãšã‚³ãƒ¬ã ãŒã€ã“ã‚Œã¾ãŸåœ°å‘³ã«ç½ ãŒå¤šã„(ãã—ã¦å¤šãã®äººãŒè¸ã‚“ã§è‹¦ã—ã‚€)ã®ã§ã¾ã¨ã‚ã¦ã¿ãŸã€‚ (2015/03/19) ã“ã¡ã‚‰ ã®ã‚³ãƒ¡ãƒ³ãƒˆæ¬„ã§ã”æŒ‡æ‘˜ãŸã ã„ãŸ wait_timeout ã®ä»¶ã«ã¤ã„ã¦è¨˜äº‹ä¿®æ£ã„ãŸã—ã¾ã—ãŸã€‚ Summary ä»¥ä¸‹ã€ã„ãšã‚Œã‚‚ãƒ—ãƒã‚°ãƒ©ãƒ è¨è¨ˆæ™‚ã«ç†è§£ã—ã¦ãŠã‹ãªã„ã¨ã€é–‹ç™ºä¸ã¯å¤§ä¸ˆå¤«ãã†ã§ã‚‚å®Ÿç”¨ã—ãŸé€”ç«¯ã«è‹¦ã—ã¾ã•ã‚Œã‚Œã¦ã—ã‹ã‚‚è¨è¨ˆã‹ã‚‰æ²»ã™ç¾½ç›®ã«ãªã‚‹è¦æ³¨æ„ãªç½ ã§ã‚ã‚‹: SELECT çµæžœã¯å…¨éƒ¨ãƒ¡ãƒ¢ãƒªã«è¼‰ã£ã¦ã—ã¾ã† (ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§) å¤§é‡ SELECT ã™ã‚‹å ´åˆã¯ FetchSize, ResultSetType ã‚’è¦è¨å®š åˆ©ç”¨æ™‚ã«ã¯åˆ¶ç´„ãŒã‚ã‚‹ã®ã§ã€è¨è¨ˆæ®µéšŽã‹ã‚‰è€ƒæ…®ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ (å¾Œè¿°) idle æ™‚é–“ã®ã€Œåˆè¨ˆã§ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒåˆ‡ã‚‰ã‚Œã‚‹ å‰å›žã®ã‚¯ã‚¨ãƒªå‡¦ç†ã‹ã‚‰ä¸€å®šæ™‚é–“ä»¥ä¸ŠçµŒ
clavier 2014/08/22
mysql

java

jdbc
ãƒªãƒ³ã‚¯
1