공유

IN 을 사용해 주시면 됩니다.

SELECT * FROM EMP

WHERE 1 =1 

AND DEPTNO IN ( 1 , 2 , 3)

UPDATE * FROM EMP

WHERE 1 =1 

AND DEPTNO IN ( 1 , 2 , 3)

DELETE * FROM EMP

WHERE 1 =1 

AND DEPTNO IN ( 1 , 2 , 3)

<iterate prepend="IN" property="test" open="(" close=")" conjunction=",">

#test[]#

</iterate>

에러 : [Error]Could not find acceptable representation

해결 : pom.xml 에 jackson-core-asl-x.jar, jackson-mapper-asl-x.jar maven으로 받을 수 있게 추가

Ajax로 데이타를 요청시 필요로 하는 데이타는 나왔지만 이 값을 돌려주지 못하는 상황이 발생하였음.

결과물을 json형식으로 반환하기 위해 매핑 시켜줄 jar파일이 없어서 생긴 오류로 생각되어서

메이븐 디펜던시에 jackson-core-asl-x.jar, jackson-mapper-asl-x.jar 라이브러리를 추가해주니 데이타가  

올바르게 return됨. 

가지 가능성이 있을 것 같습니다.

우선, 호출하신 URL 상의 확장자가 ContentNegotiatingViewResolver에 등록된 mediaTypes에 해당되는 json으로 호출되었는지 확인 부탁드립니다.  (예를 들면, /springrest/cgr.json 으로 호출되어야 확장자에 따라 동작함)

다음으로는 <mvc:annotation-driven />와 같이 별도 MVC 설정을 사용하시는 경우라면 jacksonMessageConverter나 AnnotationMethodHandlerAdapter 등의 설정을 제외시켜 놓으시면 되실 것 같습니다. 

이 경우는 사용된 library에 따라 ContentNegotiatingViewResolver 역할을 자동으로 등록하도록 되어 있습니다.

org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'chatFriendService' is defined

at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:575)

at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1114)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:279)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:270)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)

at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:445)

at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:419)

at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:547)

at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155)

at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)

at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:304)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:633)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)

at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:651)

at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:602)

at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:665)

at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:521)

at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:462)

at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)

at javax.servlet.GenericServlet.init(GenericServlet.java:160)

at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3954)

at org.apache.catalina.loader.WebappLoader.backgroundProcess(WebappLoader.java:426)

at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1345)

at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1530)

at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1540)

at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1540)

at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1519)

at java.lang.Thread.run(Thread.java:662)

원인

1. dispatcher-servlet.xml 에 Service , Repository 를 제외 시키겠다 하여서

dispatch-servlet.xml에서는 보통 Contorller 영역의 내용만 스캔되도록 설정하실껍니다.
contextConfigLocation 영역에 설정하는 XML에 Contorller 영역을 뺀 나머지 영역을 스캔하도록 설정하시면 구분이 명확해지면서 문제가 해결되실꺼 같네요.

<context:annotation-config />
    <context:component-scan base-package="test"> 
    <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>

2. service 와 impl 동일 

EduRegUsrController @Controller 클래스에서.. EduRegUsrService라는 이름의 @Service를 지정하신 것 같은데.. 실제 .. "EduRegUsrService"로 정의된 @Service 클래스가 없으셔서 발생된 오류입니다. (대소문자 구분)


Controller에서 참조하는 interface를 구현한 Impl 클래스(클래스로 직접 참조하는 경우 해당 클래스)가 @Service로 정의되어 있고.. 정의된 이름이 동일한지 확인

http://winmargo.tistory.com/144

http://apache.tt.co.kr//commons/dbcp/binaries/commons-dbcp-1.4-bin.zip

출저 : The type org.apache.commons.fileupload.FileUpload cannot be resolved.

1. eGovFrame Web Project 생성 / General Checking

Tomcat 실행 시 발생한 에러

org.springframework.web.context.ContextLoaderListener

해결방안

readme.txt

.

해결 후 확인

ServerView -> Modules -> Path

EgovSampleController.java

@RequestMapping(value = "/egovSampleList.do")

http://IP:PORT/Path/mappingValue

= localhost:8080/egovSampleList.do