전자정부프레임워크 PostgreSQL 연동 오류 질문드립니다..

Question

안녕하세요. 전자정부프레임워크+PostgreSQL 연동을 하고싶어서 pom.xml에 해당 dependency를 등록했고,lib폴더 내에 jar파일을 추가했고 properties>java build path 에서 라이브러리를 등록했습니다.그런데 톰캣 서버를 실행시키면 아래와 같은 에러가 뜨면서 페이지를 띄울수가 없습니다. 그리고 package explorer로 보면 프로젝트 폴더에 빨간 느낌표 ! 가 표시되어있습니다.pom.xml에 해당 postgre관련 dependency만 삭제하면 제대로 실행이 됩니다.. 아무래도 이게 문제인것 같은데.. 왜 이것만 추가하면 아예 프로젝트를 못띄우는지 모르겠습니다.. 또 설정 삭제하면 빨간 느낌표도 사라지구요..디비 연동하려면 설정 추가가 필수일텐데.. 왜 추가만하면 이렇게 안되는지..ㅜㅜ 오전 내내 구글링으로 찾아봐서 해결하려했으나 실패해서 질문드립니다.ㅜㅜ 도대체 원인이 뭘까요..ㅜㅜㅜ 답변 부탁드립니다.. 프로젝트 설정 관련 설명====java 1.7 , 전자정부프레임워크3.2, tomcat7 사용중입니다.PostgreSQL 버전 확인해볼시 이 결과가 출력됩니다. PostgreSQL 10.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit추가한 jar파일은 이것입니다. postgresql-42.2.23.jre7.jar 에러 로그====== 9월 10, 2021 1:34:19 오후 org.apache.catalina.core.StandardContext listenerStart SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'egov.exceptionTransfer' defined in file [C:\DLCC_TEST\.metadata\.plugins\org.eclipse.wst.server.core mp0\wtpwebapps\powerservice\WEB-INF\classes\egovframework\spring\com\context-aspect.xml]: Cannot resolve reference to bean 'defaultExceptionHandleManager' while setting bean property 'exceptionHandlerService' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultExceptionHandleManager' defined in file [C:\DLCC_TEST\.metadata\.plugins\org.eclipse.wst.server.core mp0\wtpwebapps\powerservice\WEB-INF\classes\egovframework\spring\com\context-aspect.xml]: Cannot resolve reference to bean 'egovHandler' while setting bean property 'handlers' with key [0]; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [egovframework.com.cmm.EgovComExcepHndlr] for bean with name 'egovHandler' defined in file [C:\DLCC_TEST\.metadata\.plugins\org.eclipse.wst.server.core mp0\wtpwebapps\powerservice\WEB-INF\classes\egovframework\spring\com\context-aspect.xml]; nested exception is java.lang.ClassNotFoundException: egovframework.com.cmm.EgovComExcepHndlr at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:358) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158) 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.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultExceptionHandleManager' defined in file [C:\DLCC_TEST\.metadata\.plugins\org.eclipse.wst.server.core mp0\wtpwebapps\powerservice\WEB-INF\classes\egovframework\spring\com\context-aspect.xml]: Cannot resolve reference to bean 'egovHandler' while setting bean property 'handlers' with key [0]; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [egovframework.com.cmm.EgovComExcepHndlr] for bean with name 'egovHandler' defined in file [C:\DLCC_TEST\.metadata\.plugins\org.eclipse.wst.server.core mp0\wtpwebapps\powerservice\WEB-INF\classes\egovframework\spring\com\context-aspect.xml]; nested exception is java.lang.ClassNotFoundException: egovframework.com.cmm.EgovComExcepHndlr at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:358) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158) 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.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 27 more Caused by: org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [egovframework.com.cmm.EgovComExcepHndlr] for bean with name 'egovHandler' defined in file [C:\DLCC_TEST\.metadata\.plugins\org.eclipse.wst.server.core mp0\wtpwebapps\powerservice\WEB-INF\classes\egovframework\spring\com\context-aspect.xml]; nested exception is java.lang.ClassNotFoundException: egovframework.com.cmm.EgovComExcepHndlr at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1281) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:435) 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.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 39 more Caused by: java.lang.ClassNotFoundException: egovframework.com.cmm.EgovComExcepHndlr at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) at org.springframework.util.ClassUtils.forName(ClassUtils.java:266) at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:419) at org.springframework.beans.factory.support.AbstractBeanFactory.doResolveBeanClass(AbstractBeanFactory.java:1302) at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1273) ... 45 more 제가 추가한 pom.xml의 PostgreSQL 관련 설정 <이것만 삭제하면 다 제대로 돌아갑니다..ㅜ org.postgresql postgresql 42.2.23.jre7 혹시 몰라 pom.xml의 전체 코드도 첨부합니다.. 4.0.0 powerservice powerservice war 1.0.0 powerservice http://www.egovframe.go.kr 3.2.9.RELEASE 3.1.0 mvn2 http://repo1.maven.org/maven2/ true true egovframe http://www.egovframe.go.kr/maven/ true false egovframework.rte egovframework.rte.ptl.mvc ${egovframework.rte.version} commons-logging commons-logging egovframework.rte egovframework.rte.psl.dataaccess ${egovframework.rte.version} egovframework.rte egovframework.rte.fdl.idgnr ${egovframework.rte.version} egovframework.rte egovframework.rte.fdl.property ${egovframework.rte.version} javax.servlet servlet-api provided 2.5 javax.servlet jstl 1.2 commons-dbcp commons-dbcp 1.4 taglibs standard 1.1.2 org.hsqldb hsqldb 2.3.2 org.antlr antlr 3.5 egovframework.rte egovframework.rte.fdl.security ${egovframework.rte.version} egovframework.rte egovframework.rte.fdl.excel ${egovframework.rte.version} egovframework.rte egovframework.rte.bat.core ${egovframework.rte.version} com.googlecode.log4jdbc log4jdbc 1.2 slf4j-api org.slf4j org.jasypt jasypt 1.9.2 cglib cglib 3.1 org.apache.commons commons-compress 1.8.1 xerces xercesImpl 2.11.0 net.sf.ehcache ehcache-core 2.6.9 slf4j-api org.slf4j net.sf.ehcache ehcache-terracotta 2.1.1 org.quartz-scheduler quartz 2.1.7 slf4j-api org.slf4j org.quartz-scheduler quartz-jobs 2.2.1 oro oro 2.0.8 com.ibm.icu icu4j 53.1 commons-net commons-net 3.3 org.apache.commons commons-email 1.3.2 egovframework.com.ems sndng-mail 1.0 javax.servlet.jsp javax.servlet.jsp-api 2.3.1 provided ldapsdk ldapsdk 4.1 com.artofsolving jodconverter 2.2.1 slf4j-api org.slf4j commons-io commons-io commons-fileupload commons-fileupload 1.3.1 commons-io commons-io org.twitter4j twitter4j-core 4.0.2 net.sourceforge.ajaxtags ajaxtags-resources 1.5.7 com.ckeditor ckeditor-java-core 3.5.3 org.apache.xmlgraphics batik-ext 1.7 org.springframework.social spring-social-facebook-web 1.1.1.RELEASE org.springframework.social spring-social-twitter 1.1.0.RELEASE org.apache.httpcomponents httpclient 4.3.5 commons-logging commons-logging com.h2database h2 1.4.180 org.springframework.social spring-social-security 1.1.0.RELEASE spring-security-web org.springframework.security javax.websocket javax.websocket-api 1.0 provided org.glassfish javax.json 1.0.4 org.springframework.ldap spring-ldap-core 2.0.2.RELEASE org.springframework spring-beans org.springframework spring-core org.springframework spring-tx org.slf4j slf4j-api org.slf4j jcl-over-slf4j org.codehaus.jackson jackson-mapper-asl 1.9.2 mysql mysql-connector-java 5.1.31 ojdbc ojdbc 14 commons-collections commons-collections 3.2.1 org.apache.commons commons-collections4 4.0 org.json json 20090211 net.sourceforge.jexcelapi jxl 2.6.12 dom4j dom4j 1.6.1 xmlbeans xmlbeans 2.3.0 jdom jdom 1.0 com.restfb restfb 1.11.0 commons-logging commons-logging 1.1.3 org.apache.httpcomponents httpcore 4.3.2 org.samba.jcifs jcifs 1.3.14-kohsuke-1 thumbnailator thumbnailator 0.4.7 system ${basedir}/src/main/webapp/WEB-INF/lib/thumbnailator-0.4.7.jar servlets.com cos 05Nov2002 okname okname 1.0 system ${basedir}/src/main/webapp/WEB-INF/lib/okname.jar nicepay_pkg nicepay_pkg 0.2 system ${basedir}/src/main/webapp/WEB-INF/lib/nicepay_pkg-0.2.jar nicepay_tx nicepay_tx 0.9.8.11 system ${basedir}/src/main/webapp/WEB-INF/lib/nicepay_tx-0.9.8.11.jar nicepay-lite nicepay-lite 0.9.11 system ${basedir}/src/main/webapp/WEB-INF/lib/nicepay-lite-0.9.11.jar NicdID NicdID 1.0 system ${basedir}/src/main/webapp/WEB-INF/lib/NiceID.jar NiceamcApi NiceamcApi 1.2 system ${basedir}/src/main/webapp/WEB-INF/lib/NiceamcApi_2.jar com.jcraft jsch 0.1.54 jaxen jaxen 1.1.3 system ${basedir}/src/main/webapp/WEB-INF/lib/jaxen-1.1.3.jar xpg_client xpg_client 1.0 system ${basedir}/src/main/webapp/WEB-INF/lib/xpg_client.jar commons-httpclient commons-httpclient 3.0 system ${basedir}/src/main/webapp/WEB-INF/lib/commons-httpclient-3.0.jar ksoap2 ksoap2 2.1.2 system ${basedir}/src/main/webapp/WEB-INF/lib/ksoap2-j2se-full-2.1.2.jar net.sf.opencsv opencsv 2.3 org.postgresql postgresql 42.2.23.jre7 install ${basedir}/target ${artifactId}-${version} org.apache.tomcat.maven tomcat7-maven-plugin 2.2 80 / -Xms256m -Xmx768m -XX:MaxPermSize=256m org.apache.maven.plugins maven-compiler-plugin 1.7 1.7 UTF-8 org.codehaus.mojo hibernate3-maven-plugin 2.1 hbm2ddl annotationconfiguration org.hsqldb hsqldb 2.3.2 org.codehaus.mojo emma-maven-plugin 1.0-alpha-3 org.apache.maven.plugins maven-pmd-plugin 3.1 org.apache.maven.plugins maven-surefire-plugin true once xml **/Abstract*.java **/*Suite.java **/*Test.java org.codehaus.mojo emma-maven-plugin true org.apache.maven.plugins maven-javadoc-plugin 2.9.1 ${basedir}/target/site org.apache.maven.plugins maven-project-info-reports-plugin 2.7 sunlink javadoc true http://docs.oracle.com/javase/6/docs/api/ org.codehaus.mojo emma-maven-plugin true org.codehaus.mojo surefire-report-maven-plugin true report-only org.apache.maven.plugins maven-javadoc-plugin 128m 512m ${encoding} ${encoding} ${encoding} org.apache.maven.plugins maven-jxr-plugin ${encoding} ${encoding} true apidocs

Titus Gaelic · Answer

또 설정 삭제하면 빨간 느낌표도 사라지구요..!find a word

포기해.. · Answer

lib폴더 내에 jar파일을 추가했다는게 무슨말이죠?속성창에서 별도로 path를 추가할 게 없는데 뭘 추가한건지 말이 안써있네요빨간 느낌표는 eclipse의 Markers창이나 Problems 창에 상세 내용이 찍힙니다

FreeMyMind · Answer

여기서 버젼을42.2.23 으로 해도 안되시나요?

JEJE165 · Answer

해결했습니다! C:\eGovFrame-3.2\bin\jdk1.7.0_21\jre\lib\ext 밑에 해당 jar파일을 넣어주니 잘 돌아가네요..ㅜㅜ

전자정부프레임워크 PostgreSQL 연동 오류 질문드립니다..

4개의 답변

#pom.xml 목록