<html> <head> <meta name="generator" content="Windows Mail 17.5.9600.20315"> <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><br></div><div>現在、Teeda1.0.13-sp11  POI 3.9 にてシステムの開発を行っております。</div><div>問題についてですが、HSSFWorkbookが無い(office2003用)</div><div>Fontが無い(Office2007以降)</div><div>というエラーが発生しています。</div><div><br></div><div>エラーはTeeda側なのかPOI側なのか切り分けと対策ができないで</div><div>います。POIはEclipse4.2でクラスパスも通っています。</div><div>import文にもエラーは出ていません。<br></div><div data-signatureblock="true"><div>場違いな質問で申し訳ありません。ご教示の程よろしくお願いいたします。</div><div><br></div><div>開発環境<br>Oracle11g      Windows8.1<br>JDK 1.7<br>Tomcat 6.0<br>Eclipse 4.2</div><div>POI 3.9</div><div>Teeda 1.0.13-sp11 </div><div><br></div><div>コード</div><div>import org.apache.poi.hssf.usermodel.HSSFCell;<br>import org.apache.poi.hssf.usermodel.HSSFCellStyle;<br>import org.apache.poi.hssf.usermodel.HSSFClientAnchor;<br>import org.apache.poi.hssf.usermodel.HSSFDataFormat;<br>import org.apache.poi.hssf.usermodel.HSSFFont;<br>import org.apache.poi.hssf.usermodel.HSSFPatriarch;<br>import org.apache.poi.hssf.usermodel.HSSFPicture;<br>import org.apache.poi.hssf.usermodel.HSSFRow;<br>import org.apache.poi.hssf.usermodel.HSSFSheet;<br>import org.apache.poi.hssf.usermodel.HSSFWorkbook;<br>import org.apache.poi.ss.usermodel.IndexedColors;<br></div><div><br></div><div>import org.seasar.framework.container.annotation.tiger.Component;<br>import org.seasar.framework.container.annotation.tiger.InstanceType;</div><div><br></div><div>import equipment.system.web.emtbl.AbstractEmtblPage;</div><div><br></div><div>@Component(instance = InstanceType.SINGLETON)<br>public class  CreateDateMarkService extends AbstractEmtblPage{ </div><div><br></div><blockquote style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px;" dir="ltr"><div>public void getReportHozen(){<br>  <br>  final String EXCEL_FOLDER = "C:\\Users\\";<br>  final String EXCEL_FILE = "設備保全報告書(FH-1-111改01).xls";<br>  final String EXCEL_SHEET = "原紙"; <br>  <br>  HSSFWorkbook wb = null;<br>  <br>  try {<br>   wb = new HSSFWorkbook(new FileInputStream(EXCEL_FOLDER + EXCEL_FILE));<br>  } catch (FileNotFoundException e1 ){<br>   e1.printStackTrace();<br>  } catch (IOException e1) {<br>   e1.printStackTrace();<br>  }</div></blockquote><div> HSSFWorkbook(new FileInputStream(EXCEL_FOLDER + EXCEL_FILE));でエラー発生</div><div><br></div><div>ログ</div><div>2013-12-14 00:35:53,595 [http-8080-1] DEBUG org.seasar.framework.aop.interceptors.TraceInterceptor - BEGIN equipment.system.service.CreateDateMarkService#getReportHozen()<br>2013-12-14 00:35:53,595 [http-8080-1] DEBUG org.seasar.extension.jta.TransactionImpl - トランザクションを開始しました。tx=[FormatId=4360, GlobalId=1386945555842/255, BranchId=]<br>2013-12-14 00:36:11,375 [http-8080-1] DEBUG org.seasar.extension.jta.TransactionImpl - トランザクションをロールバックしました。tx=[FormatId=4360, GlobalId=1386945555842/255, BranchId=]<br>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<br>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<br>2013-12-14 00:36:11,392 [http-8080-1] DEBUG org.seasar.teeda.extension.util.TeedaExtensionErrorPageManagerImpl - org/apache/poi/hssf/usermodel/HSSFWorkbook<br>java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook<br> at equipment.system.service.CreateDateMarkService.getReportHozen(CreateDateMarkService.java:153)<br> at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.$$getReportHozen$$invokeSuperMethod$$(CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.java)<br> at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1$$MethodInvocation$$getReportHozen1.proceed(MethodInvocationClassGenerator.java)<br> at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)<br> at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)<br> at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)<br> at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1$$MethodInvocation$$getReportHozen1.proceed(MethodInvocationClassGenerator.java)<br> at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)<br> at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1$$MethodInvocation$$getReportHozen1.proceed(MethodInvocationClassGenerator.java)<br> at equipment.system.service.CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.getReportHozen(CreateDateMarkService$$EnhancedByS2AOP$$4baf02a1.java)<br> at equipment.system.web.emtbl.EmtblStampPage.doOnceCreateDatemark(EmtblStampPage.java:50)<br> at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4.$$doOnceCreateDatemark$$invokeSuperMethod$$(EmtblStampPage$$EnhancedByS2AOP$$669579a4.java)<br> at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4$$MethodInvocation$$doOnceCreateDatemark1.proceed(MethodInvocationClassGenerator.java)<br> at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:79)<br> at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4$$MethodInvocation$$doOnceCreateDatemark1.proceed(MethodInvocationClassGenerator.java)<br> at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)<br> at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4$$MethodInvocation$$doOnceCreateDatemark1.proceed(MethodInvocationClassGenerator.java)<br> at equipment.system.web.emtbl.EmtblStampPage$$EnhancedByS2AOP$$669579a4.doOnceCreateDatemark(EmtblStampPage$$EnhancedByS2AOP$$669579a4.java)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:601)<br> at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)<br> at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:218)<br> at org.seasar.teeda.extension.html.impl.HtmlComponentInvokerImpl.invoke(HtmlComponentInvokerImpl.java:163)<br> at org.seasar.teeda.extension.html.impl.HtmlActionListener.processAction(HtmlActionListener.java:71)<br> at javax.faces.component.UICommand.broadcast(UICommand.java:149)<br> at org.seasar.teeda.extension.component.html.THtmlCommandButton.broadcast(THtmlCommandButton.java:78)<br> at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:192)<br> at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:117)<br> at org.seasar.teeda.core.lifecycle.impl.InvokeApplicationPhase.executePhase(InvokeApplicationPhase.java:29)<br> at org.seasar.teeda.core.lifecycle.AbstractPhase.execute(AbstractPhase.java:57)<br> at org.seasar.teeda.core.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:97)<br> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:100)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:79)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.seasar.framework.container.hotdeploy.HotdeployFilter.doHotdeployFilter(HotdeployFilter.java:99)<br> at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:67)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.seasar.teeda.extension.filter.MultipartFormDataFilter.doFilter(MultipartFormDataFilter.java:83)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:69)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)<br> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)<br> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<br> at java.lang.Thread.run(Thread.java:722)<br>Caused by: java.lang.ClassNotFoundException: org.apache.poi.hssf.usermodel.HSSFWorkbook<br> at java.lang.ClassLoader.findClass(ClassLoader.java:522)<br> at java.lang.ClassLoader.loadClass(ClassLoader.java:423)<br> at org.seasar.framework.container.hotdeploy.HotdeployClassLoader.loadClass(HotdeployClassLoader.java:76)<br> at java.lang.ClassLoader.loadClass(ClassLoader.java:356)</div><div><br></div><div><br></div><div><br></div></div> </div> </body> </html>