Posts

Showing posts from October, 2016

sql merge

MERGE INTO TOT_INFOA USING TOT_INFO_TEMP B ON (A.info_no = B.info_no AND A.CHK_YM = B.CHK_YM AND A.CHK_DEG = B.CHK_DEG) WHEN MATCHED THEN  UPDATE SET A.CHK_ID = B.CHK_ID

oracle alter default 삭제

Alter Table table_name Modify(column column_type DEFAULT NULL);

llegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value

llegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value 받은 전문을 mapper로 리드할때 발생하는 에러 이며, 전문에 엔터, 탭등의 태그가 들어있을 경우 발생 아래와같이 replaceAll 사용 JsonNode rootNode = objectMapper.readTree(contents).replaceAll("\t", "");

nested exception is java.lang.IllegalArgumentException: Invalid row number (-32768) outside allowable range (0..65535)

Image
excel row 변수가 short 로 되어 있어 int로 변경후 정상

Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[]], Failed to start component [StandardServer[8005]]

Image
java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[]] at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at java.util.concurrent.FutureTask.get(FutureTask.java:83) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:800) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Threa

java.lang.Error: Unresolved compilation problem:

java.lang.Error: Unresolved compilation problem: The method getSafeCnt(ElvtrSpecVo) of type ElvtrSpecServiceImpl must override a superclass method at acdn.welvt.elvtr.service.impl.ElvtrSpecServiceImpl.getSafeCnt(ElvtrSpecServiceImpl.java:68) at acdn.welvt.elvtr.web.ElvtrSpecController.getSafeCnt(ElvtrSpecController.java:359) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAc --- 프로젝트 체크아웃 후 셋팅 후 톰켓 시작시 override 에러 발생 project 우클릭 > properties > java compiler  - use default compliance setttings 가 1.5로 되어 있었다. 1.6으로 변경 후 해결