Programming
전체 : 764
No. Cate. Subject Name Date Hit
 514  [Oracle] WebSphere Oracle CLOB 입력 deok1 2008-12-26 5625
 513  [개발일반] 형상관리(소스코드 관리툴) Perforce swindler 2008-12-16 5100
 512  [Oracle] TOAD (토드) set define off [1] swindler 2008-12-15 9615
 510  [JSP/Servlet] 웹스피어 한글 문제 관련   swindler 2008-12-13 6239
 509  [Java] 환경변수 출력 swindler 2008-12-13 3872
 508  [Javascript] form 값중에 name에 .이 들어간 값을 구하기 swindler 2008-12-11 4197
 507  [Java] ORACLE JDBC 관련 문제들 [76] swindler 2008-12-05 39444
 506  [개발일반] The Boyer-Moore Algorithm   swindler 2008-12-04 4486
 505  [개발일반] The Knuth-Morris-Pratt Algorithm   swindler 2008-12-04 4648
 504  [개발일반] Brute Force Algorithm   swindler 2008-12-04 4216
 502  [Javascript] firefox control (ctrl) 키 제어 swindler 2008-11-19 3928
 501  [Javascript] Explorer, Firefox, javascript 키보드 제어 swindler 2008-11-19 4005
 497  [JSP/Servlet] tomcat get, post 전송방식 한글 깨짐문제 swindler 2008-11-10 5908
 496  [Java] eclipse 로그보기 - LogWatcher [530]   swindler 2008-11-10 16381
 492  [Oracle] Oracle Obfuscation Toolkit (DES 암호화) [1] swindler 2008-11-03 5328
 491  [Java] Vista의 Timezone 버그? swindler 2008-11-03 3721
 490  [Java] struts config - wildcard 사용 [1] swindler 2008-11-03 5558
 489  [Java] Velocity Template Language (한글)   swindler 2008-10-28 4020
 488  [Java] eclipse Tomcat plugin에서 파라메터 추가하기 swindler 2008-10-27 3822
 485  [Oracle] 숫자로만 구성된 컬럼의 max값 구하기 swindler 2008-10-20 4028

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