Programming
전체 : 764
No. Cate. Subject Name Date Hit
 394  [Java] ArrayList, HashSet, HashMap, LinkedHashSet swindler 2007-09-28 3784
 393  [JSP/Servlet] mysql CacheRowSet 사용하기 swindler 2007-09-13 4065
 392  [JSP/Servlet] 세션 타임아웃과 HttpSessionBindingListener swindler 2007-09-06 5241
 391  [Javascript] 클립보드에 복사 swindler 2007-09-06 3595
 390  [기타 DB] Apache Derby swindler 2007-08-27 6001
 389  [Java] 만들다 그만둔 Java Class File 분석기 [2]   swindler 2007-08-25 6374
 388  [개발일반] 버전관리 시스템 Subversion swindler 2007-08-22 7126
 387  [MySQL] mysql rand() swindler 2007-08-21 3399
 386  [개발일반] Ant #2/2 swindler 2007-08-21 3860
 385  [개발일반] Ant #1/2 swindler 2007-08-21 4046
 384  [Javascript] window.open 으로 뜬 창이 있는지 체크 [1] swindler 2007-08-16 5271
 383  [기타 DB] SQLite swindler 2007-08-13 3328
 382  [개발일반] 웹사이트 디버깅을 도와주는 HttpWatch swindler 2007-08-08 5045
 380  [Oracle] ORA-01103: database name 'ORCL' in control file is not 'DEFAULT' [1] swindler 2007-07-31 8820
 379  [Oracle] oracle 10g 설치후 ORA-00201 swindler 2007-07-31 4729
 378  [MS-SQL] MS-SQL 다른 포트로 접속하기 swindler 2007-07-11 3890
 377  [HTML] IE6, 7 height, min-height 처리 [62] swindler 2007-07-04 3401
 376  [CSS] CSS핵(hack) 정리 swindler 2007-07-03 3632
 375  [개발일반] Araxis Merge Tool (diff는 저리가라)   swindler 2007-06-28 4341
 374  [Java] javax.mail 인증통해서 메일 발송시 [2] swindler 2007-06-21 7410

New Comments.... (Programming)
priligy for sale Briefly the stomach and the left lung from each rat were placed into separate 50 ml tubes priligy kaufen He definitely yell at your money you check him and sue him at the male hormone tests for erectile dysfunction Virginia police station 2025-06-30 22:16
dapoxetine abuse For a more complete list, including less recent studies, please click on oranges <a href=https://enhanceyourlife.mom/>best site to buy priligy canada</a> 2025-06-22 02:30
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