<html> <head> <meta name="generator" content="Windows Mail 17.5.9600.20315"> <style type="text/css"></style><style data-externalstyle="true"></style></head> <body dir="ltr"> <div data-externalstyle="false" dir="ltr" style="font-family: 'Meiryo', 'Calibri', 'Segoe UI', 'Microsoft YaHei UI', 'Microsoft JhengHei UI', 'Malgun Gothic', 'sans-serif';font-size:11.4975pt;"><div>å°æž—æ§˜</div><div> </div><div>ãŠä¸–è©±ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚é˜¿å½¢ã§ã™ã€‚</div><div> </div><div>>Eclipseã®ãƒ“ãƒ«ãƒ‰è¨å®šã§ã‚¯ãƒ©ã‚¹ãƒ‘ã‚¹ã«é€šã—ãŸã ã‘ã§ã€ >Tomcatã‹ã‚‰ã‚‚è¦‹ãˆã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã¯é™ã‚Šã¾ã›ã‚“ã€‚ >WEB-INF/libã«POIã®Jarã‚’é…ç½®ã—ã¦ã„ã‚‹ã‹ã€ç¢ºèªã‚’ >ã—ã¦ã¿ã¦ãã ã•ã„ã€‚</div><div> </div><div>Tomcatã®libãƒ•ã‚©ãƒ«ãƒ€ãƒ¼ã¸ã€jarãƒ•ã‚¡ã‚¤ãƒ«ã‚’é…ç½®ã—ãŸã¨ã“ã‚</div><div>ã‚¨ãƒ©ãƒ¼ã¯å‡ºãªããªã‚Šã¾ã—ãŸã€‚æœ¬å½“ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚</div><div> </div><div> </div><div style="padding-top: 5px; border-top-color: rgb(229, 229, 229); border-top-width: 1px; border-top-style: solid;"><div><font face=" 'Meiryo', 'Calibri', 'Segoe UI', 'Microsoft YaHei UI', 'Microsoft JhengHei UI', 'Malgun Gothic', 'sans-serif'" style='line-height: 15pt; letter-spacing: 0.02em; font-family: "Meiryo", "Calibri", "Segoe UI", "Microsoft YaHei UI", "Microsoft JhengHei UI", "Malgun Gothic", "sans-serif"; font-size: 12pt;'>å·®å‡ºäºº: <a href="mailto:koichik@improvement.jp" target="_parent">Koichi Kobayashi</a> é€ä¿¡æ—¥æ™‚: â€Ž2013â€Žå¹´â€Ž12â€Žæœˆâ€Ž14â€Žæ—¥ â€ŽåœŸæ›œæ—¥ â€Ž18â€Ž:â€Ž06 å®›å…ˆ: <a href="mailto:seasar-user@ml.seasar.org" target="_parent">seasar-user@ml.seasar.org</a></div></div><div> </div><div dir=""><div id="readingPaneBodyContent">å°æž— (koichik) ã§ã™ã€‚ > POIã¯Eclipse4.2ã§ã‚¯ãƒ©ã‚¹ãƒ‘ã‚¹ã‚‚é€šã£ã¦ã„ã¾ã™ã€‚ Eclipseã®ãƒ“ãƒ«ãƒ‰è¨å®šã§ã‚¯ãƒ©ã‚¹ãƒ‘ã‚¹ã«é€šã—ãŸã ã‘ã§ã€ Tomcatã‹ã‚‰ã‚‚è¦‹ãˆã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã¯é™ã‚Šã¾ã›ã‚“ã€‚ WEB-INF/libã«POIã®Jarã‚’é…ç½®ã—ã¦ã„ã‚‹ã‹ã€ç¢ºèªã‚’ ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ On Fri, 13 Dec 2013 16:22:26 +0000, <shigeaga@gmail.com> wrote: > > å¤§å¤‰ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ã€ä»¶åã‚’å…¥ã‚Œå¿˜ã‚Œã¾ã—ãŸã€‚ > > å†åº¦é€ä¿¡ã—ã¾ã™ã€‚ > > > é˜¿å½¢ã¨ç”³ã—ã¾ã™ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ > > > > > ç¾åœ¨ã€Teeda1.0.13-sp11  POI 3.9 ã«ã¦ã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºã‚’è¡Œã£ã¦ãŠã‚Šã¾ã™ã€‚ > > å•é¡Œã«ã¤ã„ã¦ã§ã™ãŒã€HSSFWorkbookãŒç„¡ã„(office2003ç”¨) > > FontãŒç„¡ã„(Office2007ä»¥é™) > > ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¦ã„ã¾ã™ã€‚ > > > > > ã‚¨ãƒ©ãƒ¼ã¯Teedaå´ãªã®ã‹POIå´ãªã®ã‹åˆ‡ã‚Šåˆ†ã‘ã¨å¯¾ç–ãŒã§ããªã„ã§ > > ã„ã¾ã™ã€‚POIã¯Eclipse4.2ã§ã‚¯ãƒ©ã‚¹ãƒ‘ã‚¹ã‚‚é€šã£ã¦ã„ã¾ã™ã€‚ > > importæ–‡ã«ã‚‚ã‚¨ãƒ©ãƒ¼ã¯å‡ºã¦ã„ã¾ã›ã‚“ã€‚ > > > > å ´é•ã„ãªè³ªå•ã§ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ã€‚ã”æ•™ç¤ºã®ç¨‹ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ > > > > > é–‹ç™ºç’°å¢ƒ > Oracle11g      Windows8.1 > JDK 1.7 > Tomcat 6.0 > Eclipse 4.2 > > POI 3.9 > > Teeda 1.0.13-sp11 > > > > > ã‚³ãƒ¼ãƒ‰ > > import org.apache.poi.hssf.usermodel.HSSFCell; > import org.apache.poi.hssf.usermodel.HSSFCellStyle; > import org.apache.poi.hssf.usermodel.HSSFClientAnchor; > import org.apache.poi.hssf.usermodel.HSSFDataFormat; > import org.apache.poi.hssf.usermodel.HSSFFont; > import org.apache.poi.hssf.usermodel.HSSFPatriarch; > import org.apache.poi.hssf.usermodel.HSSFPicture; > import org.apache.poi.hssf.usermodel.HSSFRow; > import org.apache.poi.hssf.usermodel.HSSFSheet; > import org.apache.poi.hssf.usermodel.HSSFWorkbook; > import org.apache.poi.ss.usermodel.IndexedColors; > > > > > > import org.seasar.framework.container.annotation.tiger.Component; > import org.seasar.framework.container.annotation.tiger.InstanceType; > > > > > import equipment.system.web.emtbl.AbstractEmtblPage; > > > > > @Component(instance = InstanceType.SINGLETON) > public class  CreateDateMarkService extends AbstractEmtblPage{ > > > > > > public void getReportHozen(){ >   >   final String EXCEL_FOLDER = "C:\\Users\\"; >   final String EXCEL_FILE = "è¨å‚™ä¿å…¨å ±å‘Šæ›¸(FH-1-111æ”¹01).xls"; >   final String EXCEL_SHEET = "åŽŸç´™"; >   >   HSSFWorkbook wb = null; >   >   try { >    wb = new HSSFWorkbook(new FileInputStream(EXCEL_FOLDER + EXCEL_FILE)); >   } catch (FileNotFoundException e1 ){ >    e1.printStackTrace(); >   } catch (IOException e1) { >    e1.printStackTrace(); >   } > >  HSSFWorkbook(new FileInputStream(EXCEL_FOLDER + EXCEL_FILE));ã§ã‚¨ãƒ©ãƒ¼ç™ºç”Ÿ > > > > > ãƒã‚° > > 2013-12-14 00:35:53,595 [http-8080-1] DEBUG org.seasar.framework.aop.interceptors.TraceInterceptor - BEGIN equipment.system.service.CreateDateMarkService#getReportHozen() > 2013-12-14 00:35:53,595 [http-8080-1] DEBUG org.seasar.extension.jta.TransactionImpl - ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã—ã¾ã—ãŸã€‚tx=[FormatId=4360, GlobalId=1386945555842/255, BranchId=] > 2013-12-14 00:36:11,375 [http-8080-1] DEBUG org.seasar.extension.jta.TransactionImpl - ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã—ã¾ã—ãŸã€‚tx=[FormatId=4360, GlobalId=1386945555842/255, BranchId=] > 2013-12-14 00:36:11,392 [http-8080-1] DEBUG org.seasar.framework.aop.interceptors.TraceInterceptor - END equipment.system.service.CreateDateMarkService#getReportHozen() Throwable:java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook > 2013-12-14 00:36:11,392 [http-8080-1] DEBUG org.seasar.framework.aop.interceptors.TraceInterceptor - END equipment.system.web.emtbl.EmtblStampPage#doOnceCreateDatemark() Throwable:java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook > 2013-12-14 00:36:11,392 [http-8080-1] DEBUG org.seasar.teeda.extension.util.TeedaExtensionErrorPageManagerImpl - org/apache/poi/hssf/usermodel/HSSFWorkbook > java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook >  at equipment.system.service.CreateDateMarkService.getReportHozen(CreateDateMarkService.java:153) >  at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.$$getReportHozen$$invokeSuperMethod$$(CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.java) >  at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1$$MethodInvocation$$getReportHozen1.proceed(MethodInvocationClassGenerator.java) >  at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58) >  at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65) >  at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50) >  at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1$$MethodInvocation$$getReportHozen1.proceed(MethodInvocationClassGenerator.java) >  at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73) >  at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1$$MethodInvocation$$getReportHozen1.proceed(MethodInvocationClassGenerator.java) >  at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.getReportHozen(CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.java) >  at equipment.system.web.emtbl.EmtblStampPage.doOnceCreateDatemark(EmtblStampPage.java:50) >  at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4.$$doOnceCreateDatemark$$invokeSuperMethod$$(EmtblStampPage$$EnhancedByS2AOP$$669579a4.java) >  at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4$$MethodInvocation$$doOnceCreateDatemark1.proceed(MethodInvocationClassGenerator.java) >  at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:79) >  at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4$$MethodInvocation$$doOnceCreateDatemark1.proceed(MethodInvocationClassGenerator.java) >  at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73) >  at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4$$MethodInvocation$$doOnceCreateDatemark1.proceed(MethodInvocationClassGenerator.java) >  at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4.doOnceCreateDatemark(EmtblStampPage$$EnhancedByS2AOP$$669579a4.java) >  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >  at java.lang.reflect.Method.invoke(Method.java:601) >  at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96) >  at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:218) >  at org.seasar.teeda.extension.html.impl.HtmlComponentInvokerImpl.invoke(HtmlComponentInvokerImpl.java:163) >  at org.seasar.teeda.extension.html.impl.HtmlActionListener.processAction(HtmlActionListener.java:71) >  at javax.faces.component.UICommand.broadcast(UICommand.java:149) >  at org.seasar.teeda.extension.component.html.THtmlCommandButton.broadcast(THtmlCommandButton.java:78) >  at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:192) >  at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:117) >  at org.seasar.teeda.core.lifecycle.impl.InvokeApplicationPhase.executePhase(InvokeApplicationPhase.java:29) >  at org.seasar.teeda.core.lifecycle.AbstractPhase.execute(AbstractPhase.java:57) >  at org.seasar.teeda.core.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:97) >  at javax.faces.webapp.FacesServlet.service(FacesServlet.java:100) >  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >  at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:79) >  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >  at org.seasar.framework.container.hotdeploy.HotdeployFilter.doHotdeployFilter(HotdeployFilter.java:99) >  at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:67) >  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >  at org.seasar.teeda.extension.filter.MultipartFormDataFilter.doFilter(MultipartFormDataFilter.java:83) >  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >  at org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:69) >  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) >  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) >  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) >  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >  at java.lang.Thread.run(Thread.java:722) > Caused by: java.lang.ClassNotFoundException: org.apache.poi.hssf.usermodel.HSSFWorkbook >  at java.lang.ClassLoader.findClass(ClassLoader.java:522) >  at java.lang.ClassLoader.loadClass(ClassLoader.java:423) >  at org.seasar.framework.container.hotdeploy.HotdeployClassLoader.loadClass(HotdeployClassLoader.java:76) >  at java.lang.ClassLoader.loadClass(ClassLoader.java:356) > > > > > > > > > > Windows ãƒ¡ãƒ¼ãƒ« ã‹ã‚‰é€ä¿¡ -- {   name: "Koichi Kobayashi",   mail: "koichik@improvement.jp",   blog: "http://d.hatena.ne.jp/koichik/",   twitter: "@koichik" } _______________________________________________ Seasar-user mailing list Seasar-user@ml.seasar.org https://ml.seasar.org/mailman/listinfo/seasar-user </div></div></div> </body> </html>