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

snjx id:snjx

JDBCã«é–¢ã™ã‚‹snjxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

ResultSetMetaDataã®getColumnLabel()ã¨getColumnName() - ã‚„ãã“ã‚„ã
åŸºæœ¬ã“ã®2ã¤ã®ãƒ¡ã‚½ãƒƒãƒ‰ã¯åŒã˜å€¤ã‚’è¿”ã™å®Ÿè£…ã«å„JDBCãƒ‰ãƒ©ã‚¤ãƒã¯ãªã£ã¦ã‚‹ã¨æ€ã†ã®ã ã‘ã©ï¼ˆå°‘ãªã„ç§ã®çµŒé¨“ä¸Šã¯ä»Šã¾ã§ãã†ã ã£ãŸï¼‰ã€mysql-connector 5.1.6ã§åˆã‚ã¦é•ã†ãƒ‘ã‚¿ãƒ¼ãƒ³ã«å·¡ã‚Šåˆã„ã¾ã—ãŸã€‚ ã€Œselect xxx as yyy from zzzã€ ãªã‚“ã¦SQLã‚’æ›¸ãã¨ã¾ã‚ã€ã€Œyyyã€ãŒè¿”ã£ã¦ãã‚‹ã®ã‚’æœŸå¾…ã™ã‚‹ã‚ã‘ãªã‚“ã§ã™ãŒã€mysql-connector 5.1.6ã§ã¯ã€getColumnLabel()ã ã¨ã€Œyyyã€ã€getColumnName()ã ã¨ã€Œxxxã€ã€‚ æ•°å¹´å‰MySQLä½¿ã£ãŸæ™‚ã¯ã“ã‚“ãªçµæžœã˜ã‚ƒãªã‹ã£ãŸæ°—ãŒã™ã‚‹ãªã‚ã€‚ Java SE 6 ã‹ã‚‰æŽ¡ç”¨ã®JDBC4.0ãŒã‚‰ã¿ã®å¤‰æ›´ã‚„ã‚‚ã—ã‚Œã‚“ï¼ˆæœªç¢ºèªï¼‰ã€‚Java SE 6ã®JavaDocã®ã‚³ãƒ¡ãƒ³ãƒˆã‚’è¦‹ã‚‹é™ã‚Šã«ãŠã„ã¦ã¯ã“ã‚ŒãŒæ£ã—ã„å‹•ä½œãªã‚ˆã†ãªæ°—ãŒã™ã‚‹ã—ã€‚ ã¾ã‚DAOã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã‚‚è‡ªä½œã—ãªã„ã¨è§¦ã‚‰ãªã„éƒ¨åˆ†ã§ã¯ã‚ã‚‹ã¨ã¯æ€ã„ã¾ã™ãŒ
snjx 2018/06/25
ã“ã“ã«ã¯æ›¸ã‹ã‚Œã¦ã„ãªã„ã‘ã©ã€Oracle JDBCã ã¨ColumnLabelã¨ColumnNameã§åŒã˜å€¤ã€ã‚‰ã—ã„ã€‚ã»ã‚“ã¨ã‹ï¼Ÿæš«å®šå¯¾å‡¦ã¯selectæ–‡ã‚’ã‚µãƒ–ã‚¯ã‚¨ãƒªã§åŒ…ã‚“ã§ã—ã¾ã†ã“ã¨ã€‚

JDBC

mysql

MariaDB

DB

sql

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

æŠ€è¡“

è€ƒå¯Ÿ
ãƒªãƒ³ã‚¯
MariaDB Products & Tools Downloads | MariaDB
MariaDB Enterprise Server: Enhanced, hardened and secured for mission-critical applications MariaDB Enterprise Server is a hardened version of MariaDB Community Server built for production deployments. It undergoes extensive QA, is configured for production by default and includes enterprise features to improve operating efficiency at scale and support the most secure environments. MariaDB Enterpr
snjx 2018/06/13
DB

sql

mysql

MariaDB

jdbc

java

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

è³‡æ–™

æŠ€è¡“
ãƒªãƒ³ã‚¯
Spring+MySQLã§MySQLã®æŽ¥ç¶šåˆ‡ã‚Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ä½¿ç”¨ã«ã‚ˆã‚‹ã‚¨ãƒ©ãƒ¼ã®å¯¾ç– - yyhayashi303's diary
ã“ã‚“ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ãŸã®ã§èª¿ã¹ã¦ã¿ã‚‹ã€‚ ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 229,658,792 milliseconds ago. The last packet sent successfully to the server was 229,658,820 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing conne
snjx 2016/04/08
ã“ã‚Œå…¥ã‚Œã¦ã€ã¡ã‚‡ã£ã¨æ§˜åè¦‹

mysql

jdbc

springboot

æŠ€è¡“

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

java
ãƒªãƒ³ã‚¯
Spring JPA ã§SELECTæ™‚ã¯Slaveã‚µãƒ¼ãƒã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ - Qiita
ã‚„ã‚ŠãŸã„ã“ã¨ Spring JPAã‚’ä½¿ã£ã¦Master-Slaveæ§‹æˆã®æ™‚ã«SELECTã¯Slave,ãã®ä»–ã¯Masterã‚µãƒ¼ãƒã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢,ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ ReplicationDriver MySQL 5.6 Spring 3.2.8 hibernate ãƒ†ã‚¹ãƒˆã®æ§‹æˆ Customer.java ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚¯ãƒ©ã‚¹ CustomerRepository.java JpaRepositoryã‚’ç¶™æ‰¿ã—ãŸã‚¯ãƒ©ã‚¹. findãªã©ã‚’è¡Œã„ã¾ã™ CustomerService.java CustomerRepositoryã‚’å‘¼ã³å‡ºã—ã¾ã™ Testã‚¯ãƒ©ã‚¹ CustomerServiceã‚’å‘¼ã³å‡ºã—ã¾ã™ ã‚³ãƒ¼ãƒ‰ã¯ä¸‹è¨˜ã« https://github.com/hachi-eiji/spring-jpa-practice/ å®Ÿç¾æ–¹æ³• ReplicationDriverã¯autoCommit=f
snjx 2016/02/04
mysql

JDBC

jpa

ã‚ã¨ã§èªã‚€

æŠ€è¡“

è³‡æ–™

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

java
ãƒªãƒ³ã‚¯
JPAã§ãƒžã‚¹ã‚¿ãƒ¼/ã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆã®MySQLã‚’ä½¿ã†ãž | nagaseyasuhito Daily works.
ã“ã®è¨˜äº‹ã¯Java EE Advent Calendarã®18æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚æ˜¨æ—¥ã¯n_agetsuã•ã‚“ã®Apache Shiro ã‚’ä½¿ã£ã¦ã¿ã¾ã—ãŸã§ã—ãŸã€‚ Webã‚µãƒ¼ãƒ“ã‚¹ã‚„ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚Šã‚„ã™ã„ã®ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ã§ã™ã€‚ãã—ã¦ã“ã‚Œã‚‰ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«MySQLãŒå¤šãä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚ é«˜è² è·ãªMySQLã®è² è·åˆ†æ•£ã®ä¸€ã¤ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒžã‚¹ã‚¿ãƒ¼/ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã«ã—ã¦INSERT/UPDATE/DELETEãªã©æ›´æ–°ç³»ã®ã‚¯ã‚¨ãƒªã¯ãƒžã‚¹ã‚¿ãƒ¼ã«å¯¾ã—ã¦è¡Œã„ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ãƒžã‚¹ã‚¿ãƒ¼ã®æ›´æ–°å†…å®¹ã‚’ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ãƒˆã€SELECTãªã©å‚ç…§ç³»ã®ã‚¯ã‚¨ãƒªã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã—ã¦è² è·åˆ†æ•£ã‚’è¡Œã†æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ãã®ã‚ˆã†ãªãƒžã‚¹ã‚¿ãƒ¼/ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã®MySQLã«JPAã‚’ä½¿ã£ã¦ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã™ã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ MySQLã®JDB
snjx 2016/02/04
mysql

JDBC

jpa

ã‚ã¨ã§èªã‚€

æŠ€è¡“

è³‡æ–™

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

java
ãƒªãƒ³ã‚¯
Oracle DBã‚’ERMasterã§ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã—ã¦ã¿ã‚‹ - å°ã•ã„é ƒã¯ã‚¨ãƒ©å‘¼å¸
ã¯ã˜ã‚ã« ä»Šå¹´ã‹ã‚‰ã€ã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚’å¼•ãç¶™ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†ã‚·ã‚¹ãƒ†ãƒ ã§ã€å„ãƒ†ãƒ¼ãƒ–ãƒ«ã®é …ç›®å®šç¾©æ›¸ã®ã‚ˆã†ãªè³‡æ–™ãŒã‚ã‚‹ã“ã¨ã¯åˆ†ã‹ã£ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹è³‡æ–™ã‚’ã¿ãŸã“ã¨ãŒãªã„ã®ã§ã€æ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã§ã€ERå›³ã‚’ãŠã“ã™ã“ã¨ãŒã§ããªã„ã‹ã¨è€ƒãˆã¾ã—ãŸã€‚ ã‚°ãƒ©ã‚¹ç‰‡æ‰‹ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ~è²©å£²ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ç·¨ (DBMagazine SELECTION)posted with amazlet at 13.01.06æ¢…ç”° å¼˜ä¹‹ ç¿”æ³³ç¤¾ å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 34,882 Amazon.co.jp ã§è©³ç´°ã‚’è¦‹ã‚‹ DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ERMasterã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã¨ã€æ—¢å˜ã®Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ERå›³ã‚’ç”Ÿæˆã§ãã‚‹ã“ã¨ãŒåˆ†ã‹ã‚Šã¾ã—ãŸã€‚ DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãª
snjx 2016/02/01
JDBC

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

eclipse

ERå›³

ermaster

DB

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

æŠ€è¡“

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
6. ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç† (2)
6.2. ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ã®æº–å‚™ Spring ã§ã¯ org.springframework.transaction.PlatformTransactionManager ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã‚’å®Ÿè£…ã™ã‚‹å…·è±¡ã‚¯ãƒ©ã‚¹ã¨ã—ã¦ JDBC, JDO, Hibernate, JTA ãã‚Œãžã‚Œã«ä»¥ä¸‹ã®ã‚¯ãƒ©ã‚¹ã‚’ç”¨æ„ã—ã¦ã„ã¾ã™ã€‚ org.springframework.jdbc.datasource.DataSourceTransactionManager org.springframework.orm.jdo.JdoTransactionManager org.springframework.orm.hibernate.HibernateTransactionManager org.springframework.transaction.jta.JtaTransactionManager JDBC ã‚’ä½¿ç”¨ã™
snjx 2016/01/26
transaction

JDBC

JTA

spring

æŠ€è¡“

è³‡æ–™

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º
ãƒªãƒ³ã‚¯
1