// org.hibernate.Session 또는 org.springframework.orm.hibernate3.HibernateTemplate 을 이용하여 리턴 받은 리스트값을 Object 배열을 이용하여 추출합니다.

//##  Controller 에서 Service 호출 부분

List dataList = dataService.selectDataMain(currentPage, countPerPage);
Iterator list = dataList .iterator();
while(list.hasNext()) {
    Object[] data = (Object[])list.next();
logger.debug("data[0] : " + data[0] +", data[1] : " + data[1]+", data[2] : " + data[2]+", data[3] : " + data[3]);
}


// ## DAO 부분
 public List selectDataMain(int currentPage, int countPerPage){
  String[] paramNames = new String[]{"currentPage", "countPerPage"};
  Object[] values = new Object[]{currentPage, countPerPage};
 
  List list = getHibernateTemplate().findByNamedQueryAndNamedParam("select.selectDataMainList", paramNames, values);
 
  return list;
 }


###
   branchListL = donationService.findByBranchL(bean.getBranchL());
   branchListM = donationService.findByBranchM(bean.getBranchM());
   branchListS = donationService.findByBranchS(bean.getBranchS());
   BranchList branchM = new BranchList();
   BranchList branchL = new BranchList();
   BranchList branchS = new BranchList();  
   Iterator iter1 = branchListL.iterator();
   Iterator iter2 = branchListM.iterator();
   Iterator iter3 = branchListS.iterator();
   if(iter1.hasNext()){
    branchL = (BranchList)iter1.next();
   }
   if(iter2.hasNext()){
    branchM = (BranchList)iter2.next();
   }
   if(iter3.hasNext()){
    branchS = (BranchList)iter3.next();
   }
   if(branchM.getBranchName() != null) {
    branchM.setBranchName(" / " + branchM.getBranchName());
   }
   if(branchS.getBranchName() != null){
    branchS.setBranchName(" / " + branchS.getBranchName());
   }

11 25, 2009 15:19 11 25, 2009 15:19

Trackback URL : http://develop.sunshiny.co.kr/trackback/342

Leave a comment


참고 사이트 :
http://cafe.naver.com/deve.cafe?iframe_url=/ArticleRead.nhn%3Farticleid=931



저의 경우는 아래 링크에 설명해준대로,
constraint 속성을 갖는 컬럼에 not-null 값을 주라는 내용대로 수정을 하니 정상 작동 되었습니다.

지금 에러 내용은 참조 관계를 맺고있는 컬럼이 NULL 값일경우에 발생하는것 같습니다.
constraint 가 지정되어 있는 컬럼의 설정이 NULL이라면 NOT-NULL 설정을 하고,
 NULL 값이 있을 경우에 기본값으로 대체 해줍니다.

ALTER TABLE BOARD
ADD
(
 CODE_SEQ NUMBER DEFAULT 0 NOT NULL
) ;


http://forum.hibernate.org/viewtopic.php?p=2317328&sid=d23e1db025c03d787537195f3ef530b9


심각: Servlet.service() for servlet action threw exception
org.springframework.orm.hibernate3.HibernateSystemException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of kr.or.copyright.freeuse.domain.community.Bulletin.setCodeSeq; nested exception is org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of kr.or.copyright.freeuse.domain.community.Bulletin.setCodeSeq
org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of kr.or.copyright.freeuse.domain.community.Bulletin.setCodeSeq
        at org.hibernate.tuple.PojoTuplizer.setPropertyValuesWithOptimizer(PojoTuplizer.java:203)
        at org.hibernate.tuple.PojoTuplizer.setPropertyValues(PojoTuplizer.java:173)
        at org.hibernate.persister.entity.BasicEntityPersister.setPropertyValues(BasicEntityPersister.java:2919)
        at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113)
        at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:530)
        at org.hibernate.loader.Loader.doQuery(Loader.java:436)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1345)
        at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
        at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
        at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2471)
        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:351)
        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:332)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:113)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:167)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:621)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:614)
        at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:389)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:312)
        at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:383)
        at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:378)
        at kr.or.copyright.freeuse.dao.community.BulletinDAO.selectByBulletinSeq(BulletinDAO.java:89)
        at kr.or.copyright.freeuse.dao.community.BulletinDAO$$FastClassByCGLIB$$3017e74c.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
02 23, 2009 18:03 02 23, 2009 18:03

Trackback URL : http://develop.sunshiny.co.kr/trackback/145

Leave a comment


ERROR - ContextLoader.initWebApplicationContext(177) | Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/context/applicationContext-jdbc.xml]: Initialization of bean failed; nested exception is org.hibernate.MappingException: Could not determine type for: String, for columns: [org.hibernate.mapping.Column(user_id)]
org.hibernate.MappingException: Could not determine type for: String, for columns: [org.hibernate.mapping.Column(user_id)]
// 해당하는 컬럼명 정의가 잘못되었을때 
// 여기서는 user_id 컬럼 속성을 String 로 주어서 발생한 에러. 소문자로 string 변경해줌.
// 해당하는 컬럼명을 검색 확인하여 hbm.xml 파일 안의 테이블 <class>로 정의된 속성을 확인 함.

 at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:265)
 at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:252)
 at org.hibernate.mapping.RootClass.validate(RootClass.java:189)
 at org.hibernate.cfg.Configuration.validate(Configuration.java:839)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1000)
 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:746)
 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:673)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:962)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:354)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:223)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:271)
 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:312)
 at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
 at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:230)
 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:156)
 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
 at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
 at org.apache.catalina.core.StandardService.start(StandardService.java:516)
 at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2009. 2. 20 오후 2:29:33 org.apache.catalina.core.StandardContext listenerStart
02 20, 2009 14:39 02 20, 2009 14:39

Trackback URL : http://develop.sunshiny.co.kr/trackback/144

Leave a comment


Recent Posts

  1. Linux - Telnet 서비스 비활성및 실행
  2. NT - 서버 원격데스크탑 연결
  3. NT - http와 https간에 세션 공유가...
  4. Unix - 대량 파일 이동, 삭제시 Argu...
  5. Oracle - SYS_CONTEXT 함수를 이용하...

Recent Comments

  1. 네. 고맙습니다^^ 행복한 한해 보... sunshiny 01 16,
  2. sunshiny님. 안녕하세요... 올려 주... yihans 01 16,
  3. 답글 주셔서 고맙습니다^^ 소스 복... sunshiny 01 11,
  4. 관리자만 볼 수 있는 댓글입니다. 비밀방문자 01 11,
  5. 넵 답변감사합니다^^ 좋은 하루 되... 노로링

Recent Trackbacks

  1. 윈도우 cmd 명령어 팁 월풍도원(月風道院) - Delight on th... %M
  2. 파일 압축 Like RadioHead %M
  3. Mysql - mysql 설치후 Character set... 멀고 가까움이 다르기 때문 %M

Calendar

«   02 2012   »
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29      

Bookmarks

  1. 위키피디아
  2. MysqlKorea
  3. Oracle All Documentation
  4. 엑셈
  5. 오라클 클럽
  6. 네이버개발자센터
  7. API - Java
  8. API - Spring
  9. Java Community
  10. Reference - Spring
  11. 스프링사용자
  12. 자바지기
  13. Ready System
  14. Solaris Freeware
  15. Linux-Site
  16. RedHat Korea
  17. 윈디하나의 솔라나라

Site Stats

TOTAL 217714 HIT
TODAY 16 HIT
YESTERDAY 115 HIT