Programming
전체 : 763
No. Cate. Subject Name Date Hit
 63  [Oracle] 특정 IP에서 접속 막기 coolx 2004-07-12 3064
 62  [Oracle] DataBase Link coolx 2004-07-12 2912
 61  [MS-SQL] 특수 문자 입력 coolx 2004-07-12 3213
 60  [DB 일반] 일반적인 튜닝의 10단계 coolx 2004-07-12 3077
 59  [MySQL] 대소문자 구별 [1] coolx 2004-07-11 4292
 58  [MySQL] 루트 암호를 잃어버렸을때, coolx 2004-07-11 2643
 57  [Oracle] Disk Read/Write 감시 coolx 2004-07-11 2350
 56  [Javascript] 창 크기 조절하기 coolx 2004-07-11 2744
 55  [Java] Out of Memory Error coolx 2004-07-11 3310
 54  [Oracle] Archive Mode coolx 2004-07-11 3284
 53  [Java] Java Post Data 전송 coolx 2004-07-11 2452
 52  [JSP/Servlet] JSP 기본강좌 #2/2 coolx 2004-07-11 2861
 51  [JSP/Servlet] JSP 기본 강좌 #1/2 coolx 2004-07-11 3145
 50  [JSP/Servlet] JSP 초보를 위한 Bean 을 이용한 회원로그인의 구현 coolx 2004-07-11 4224
 49  [JSP/Servlet] response.sendRedirect vs jsp:forward coolx 2004-07-11 2869
 48  [JSP/Servlet] jsp include 사용시 유의점 [3] coolx 2004-07-11 5599
 47  [JSP/Servlet] request 자체를 encoding하기 coolx 2004-07-11 2499
 46  [Java] Shutdown Hooks Example coolx 2004-07-11 2149
 45  [Java] Shutdown Hooks [5] coolx 2004-07-11 2810
 44  [XML] DOM 2 Handling 예제 (Dom2Example) coolx 2004-07-11 2377

New Comments.... (Programming)
vetetrown Just like Brutal Force, CrazyBulk offers a good range of SARMs alternatives <a href=https://enhanceyourlife.mom/>buy priligy pills</a> Nephrotic syndrome from toddlers to twenties 2024-08-31 13:50
rocaQuott On the basis of our findings, we postulate that the EP4 receptor represents the dominant PGE 2 receptor in pathogenesis of HPS aBS <a href=https://enhanceyourlife.mom/>priligy review members</a> 2024-08-25 03:15
swindler chrome://flags 에서 sameSite 설정을 변경할 수 있는데, 그래도 별 차이가 없는 것 같다. 2022-06-07 11:10
swindler set global sync_binlog=0; 2020-03-20 11:15
swindler show variables like 'innodb_flush_log_at_trx_commit'; 2020-03-20 11:14
swindler show variables like 'sync_binlog'; 2020-01-21 11:07
swindler SET GLOBAL wait_timeout=1800; 2019-08-29 10:55
andrew 이 설정을 어디서 하면 되나요?
저는 비슷한 에러를 띄고 있는 상태입니다.

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect INTEGER value: 'scsc'
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into tb_blog_board(user_id, title, contents, category, blog_contents_img) values (?,?,?,?, ?)
### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect INTEGER value: 'scsc'
; SQL []; Data truncation: Truncated incorrect INTEGER value: 'scsc'; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect INTEGER value: 'scsc'
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

보시는 것 같이 scsc라는 string을 입력했는데 INTEGER로 인식해버리고 에러가 발생하네요 ㅠ
어떤게 문제일까요?
2019-06-10 22:31
swindler 결국 autoreConnect 할때 SET NAMES 적용되지 않는 문제때문에 더 찾아보다가, wait_timeout이 제대로 설정되지 않음을 발견. wait_timeout을 늘리면 해결됨 2018-07-24 18:05
swindler 새로운 문제가 있음. 지금 character set 관련문제가 있어서 처음접속시에 SET names를 던지는데, reconnect 될때 적용되지 않는 문제가 있ㅇ므. 2018-07-01 09:19
Copyright © 1999-2017, swindler. All rights reserved. 367,611 visitor ( 1999.1.8-2004.5.26 ), 2,405,771 ( -2017.01.31)

  2HLAB   2HLAB_Blog   RedToolBox   Omil   Omil_Blog