Maruli Lee

I am developing a webservice using Restlet, Spring & Hibernate using JBoss 9.1.0 (EAP 6.4). After starting up the service and navigate to http://localhost:9090/fwd-PMAP/pmap/client/1/campaign/1/staffCat/EXA1(A)/isp/10 I will get java.lang.IncompatibleClassChangeError. I've been stuck with this error for 3 weeks now. Hope someone can figure out what's wrong and point me in the right direction.

Entity manager class
package com.fwd.pmap.util; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import javax.persistence.EntityManager; import javax.persistence.EntityManagerFactory; import javax.persistence.Persistence; public class EntityManagerUtil { static Logger LOGGER = LoggerFactory.getLogger(EntityManagerUtil.class); private static String PERSISTENCE_UNIT_NAME = "pmap"; private static final EntityManagerFactory emf; static { try { emf = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME); } catch (Throwable ex) { System.err.println("Initial SessionFactory creation failed." + ex); throw new ExceptionInInitializerError(ex); } } public static EntityManager getEntityManager() { return emf.createEntityManager(); } public static EntityManager initEntityManager (EntityManager em) { if (!em.getTransaction().isActive()) em.getTransaction().begin(); return em; } public void closeEMF() { emf.close(); } }

The application class
package com.fwd.pmap.service.web; import org.restlet.Application; import org.restlet.Restlet; import org.restlet.routing.Router; public class RestletApplication extends Application { @Override public synchronized Restlet createInboundRoot() { Router router = new Router(getContext()); // Calculate PMAP Plan //http://localhost:9090/fwd-PMAP/pmap/client/1/campaign/1/staffCat/EXA1(A)/isp/10 router.attach("/pmap/client/{client}/campaign/{campaign}/staffCat/{staffCat}/isp/{isp}", PMAPResource.class); router.attach("/pmap/client/{client}/campaign/{campaign}/staffCat/{staffCat}/isp/{isp}/preEx/{preEx}", PMAPResource.class); // Determine ward upgrade //router.attach("/pmap/campaign/{campaign}/ghs/{ghs}/isp/{isp}", PMAPResource.class); // Calculate PMC router.attach("/pmc/calculate", PMCResource.class); return router; } }

The resource class
package com.fwd.pmap.service.web; import org.restlet.data.Reference; import org.restlet.resource.Get; import org.restlet.resource.ServerResource; import com.fwd.pmap.service.dao.PMAPMatrixDAO; import com.fwd.pmap.service.dao.PMAPMatrixDAOImpl; public class PMAPResource extends ServerResource { /* * Injecting DAO here causes java.lang.IncompatibleClassChangeError: Implementing class * I have narrowed down the error and it's due to entitymanager */ PMAPMatrixDAO matrix = new PMAPMatrixDAOImpl(); @Get public String represent() { String clientID = (String) this.getRequestAttributes().get("client"); String campaignID = (String) this.getRequestAttributes().get("campaign"); String staffCat = Reference.decode((String) this.getRequestAttributes().get("staffCat")); String ispID = (String) this.getRequestAttributes().get("isp"); String preEx = (String) this.getRequestAttributes().get("preEx"); String tmp = ""; if(campaignID.equals("1") & staffCat.equals("EXA1(A)") & ispID.equals("10")) tmp = "1"; else tmp = "2"; tmp = matrix.findPMAP(Integer.parseInt(campaignID), staffCat, Integer.parseInt(ispID)); return tmp; } }

DAO
package com.fwd.pmap.service.dao; public interface PMAPMatrixDAO { String findPMAP(int campaignID, String staffCategory, int ispPlanID); String findPMAP(int campaignID, String staffCategory, int ispPlanID, String preEx); }

DAO Implement
package com.fwd.pmap.service.dao; import javax.persistence.EntityManager; import com.fwd.pmap.util.EntityManagerUtil; public class PMAPMatrixDAOImpl implements PMAPMatrixDAO { private EntityManager entityManager = EntityManagerUtil.getEntityManager(); public String findPMAP(int campaignID, String staffCategory, int ispPlanID) { String pmapPlan = ""; // If any of the mandatory fields is empty, return empty string if(campaignID == 0 || staffCategory.isEmpty() || ispPlanID == 0) return "Make sure all parameters are supplied"; String sqlQuery = "SELECT P.PlanName FROM ClientPMAP P, PMAPMatrix M " + "WHERE P.ID = M.ClientPMAPID AND " + "M.campaign_id = :campaignID AND " + "M.StaffCategoryID = (SELECT ID FROM StaffCategory WHERE Name = :staffCat) AND " + "M.isp_plan_id = :planID AND " + "M.PreEx IS NULL"; pmapPlan = (String) entityManager.createNativeQuery(sqlQuery) .setParameter("campaignID", campaignID) .setParameter("staffCat", staffCategory) .setParameter("planID", ispPlanID) .getSingleResult(); return pmapPlan; } public String findPMAP(int campaignID, String staffCategory, int ispPlanID, String preEx) { String pmapPlan = ""; // If any of the mandatory fields is empty, return empty string if(campaignID == 0 || staffCategory.isEmpty() || ispPlanID == 0 || preEx.isEmpty()) return "Make sure all parameters are supplied"; String sqlQuery = "SELECT P.PlanName FROM ClientPMAP P, PMAPMatrix M " + "WHERE P.ID = M.ClientPMAPID AND " + "M.campaign_id = :campaignID AND " + "M.StaffCategoryID = (SELECT ID FROM StaffCategory WHERE Name = :staffCat) AND " + "M.isp_plan_id = :planID AND " + "M.PreEx = :preEx"; pmapPlan = (String) entityManager.createNativeQuery(sqlQuery) .setParameter("campaignID", campaignID) .setParameter("staffCat", staffCategory) .setParameter("planID", ispPlanID) .setParameter("preEx", preEx) .getSingleResult(); return pmapPlan; } }

POM
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.fwd</groupId> <artifactId>fwd-PMAP</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>war</packaging> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <java.version>1.8</java.version> <maven-compiler-plugin.version>3.5.1</maven-compiler-plugin.version> <maven-war-plugin.version>2.6</maven-war-plugin.version> <!-- Spring --> <spring-framework.version>4.0.3.RELEASE</spring-framework.version> <!-- Hibernate / JPA --> <hibernate.version>4.3.5.Final</hibernate.version> <!-- Logging --> <logback.version>1.0.13</logback.version> <slf4j.version>1.7.5</slf4j.version> <log4j.version>1.2.16</log4j.version> <!-- Restlet --> <restlet.version>2.3.4</restlet.version> <commons-lang.version>3.4</commons-lang.version> <jackson.version>2.7.1</jackson.version> </properties> <repositories> <repository> <id>maven-restlet</id> <name>Public online Restlet repository</name> <url>http://maven.restlet.org</url> </repository> </repositories> <dependencies> <!-- Spring and Transactions --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring-framework.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring-framework.version}</version> </dependency> <!-- Spring ORM support --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-orm</artifactId> <version>${spring-framework.version}</version> </dependency> <!-- Spring Scheduler --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> <version>1.3.3.RELEASE</version> </dependency> <!-- Logging --> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${slf4j.version}</version> <!-- <scope>compile</scope> --> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>${logback.version}</version> <!-- <scope>runtime</scope> --> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> <version>${logback.version}</version> </dependency> <!-- Hibernate --> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> <version>${hibernate.version}</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-core</artifactId> <version>${hibernate.version}</version> </dependency> <!-- 3cp0 --> <dependency> <groupId>c3p0</groupId> <artifactId>c3p0</artifactId> <version>0.9.1.2</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-c3p0</artifactId> <version>${hibernate.version}</version> </dependency> <!-- Super CSV --> <dependency> <groupId>net.sf.supercsv</groupId> <artifactId>super-csv</artifactId> <version>2.4.0</version> </dependency> <!-- Copy POJO to POJO --> <dependency> <groupId>org.modelmapper</groupId> <artifactId>modelmapper</artifactId> <version>0.7.5</version> </dependency> <!-- Restlet --> <dependency> <groupId>org.restlet.jee</groupId> <artifactId>org.restlet</artifactId> <version>${restlet.version}</version> </dependency> <dependency> <groupId>org.restlet.jee</groupId> <artifactId>org.restlet.ext.servlet</artifactId> <version>${restlet.version}</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> <version>${commons-lang.version}</version> </dependency> <!-- JSON --> <dependency> <groupId>com.googlecode.json-simple</groupId> <artifactId>json-simple</artifactId> <version>1.1</version> </dependency> </dependencies> <build> <finalName>${project.artifactId}</finalName> <pluginManagement> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war-plugin</artifactId> <version>${maven-war-plugin.version}</version> <configuration> <failOnMissingWebXml>false</failOnMissingWebXml> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>${maven-compiler-plugin.version}</version> <configuration> <source>${java.version}</source> <target>${java.version}</target> <failOnMissingWebXml>false</failOnMissingWebXml> </configuration> </plugin> </plugins> </pluginManagement> </build> </project>

Error
10:27:15,252 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/fwd-PMAP]] (http-localhost/127.0.0.1:9090-1) RestletServlet: [Restlet] ServerServlet: component class is null 10:27:15,481 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/fwd-PMAP]] (http-localhost/127.0.0.1:9090-1) RestletServlet: [Restlet] Attaching application: com.fwd.pmap.service.web.RestletApplication@14cb4bb to URI: /fwd-PMAP 10:27:15,762 WARN [org.jboss.modules] (http-localhost/127.0.0.1:9090-1) Failed to define class org.hibernate.engine.spi.CascadeStyles$BaseCascadeStyle in Module "deployment.fwd-PMAP.war:main" from Service Module Loader: java.lang.IncompatibleClassChangeError: Implementing class at java.lang.ClassLoader.defineClass1(Native Method) [rt.jar:1.8.0_73] at java.lang.ClassLoader.defineClass(Unknown Source) [rt.jar:1.8.0_73] at org.jboss.modules.ModuleClassLoader.doDefineOrLoadClass(ModuleClassLoader.java:361) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ModuleClassLoader.defineClass(ModuleClassLoader.java:482) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ModuleClassLoader.loadClassLocal(ModuleClassLoader.java:277) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ModuleClassLoader$1.loadClassLocal(ModuleClassLoader.java:92) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.Module.loadModuleClass(Module.java:568) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:205) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134) [jboss-modules.jar:1.3.6.Final-redhat-1] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.buildBootstrapServiceRegistry(EntityManagerFactoryBuilderImpl.java:484) [hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.<init>(EntityManagerFactoryBuilderImpl.java:206) [hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.boot.spi.Bootstrap.getEntityManagerFactoryBuilder(Bootstrap.java:51) [hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.HibernatePersistenceProvider.getEntityManagerFactoryBuilder(HibernatePersistenceProvider.java:182) [hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.HibernatePersistenceProvider.getEntityManagerFactoryBuilderOrNull(HibernatePersistenceProvider.java:131) [hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.HibernatePersistenceProvider.getEntityManagerFactoryBuilderOrNull(HibernatePersistenceProvider.java:88) [hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:69) [hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) [hibernate-jpa-2.0-api-1.0.1.Final-redhat-3.jar:1.0.1.Final-redhat-3] at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47) [hibernate-jpa-2.0-api-1.0.1.Final-redhat-3.jar:1.0.1.Final-redhat-3] at com.fwd.pmap.util.EntityManagerUtil.<clinit>(EntityManagerUtil.java:19) [classes:] at com.fwd.pmap.service.dao.PMAPMatrixDAOImpl.<init>(PMAPMatrixDAOImpl.java:9) [classes:] at com.fwd.pmap.service.web.PMAPResource.<init>(PMAPResource.java:16) [classes:] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_73] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [rt.jar:1.8.0_73] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [rt.jar:1.8.0_73] at java.lang.reflect.Constructor.newInstance(Unknown Source) [rt.jar:1.8.0_73] at java.lang.Class.newInstance(Unknown Source) [rt.jar:1.8.0_73] at org.restlet.resource.Finder.create(Finder.java:148) [org.restlet-2.3.4.jar:] at org.restlet.resource.Finder.create(Finder.java:176) [org.restlet-2.3.4.jar:] at org.restlet.resource.Finder.find(Finder.java:193) [org.restlet-2.3.4.jar:] at org.restlet.resource.Finder.handle(Finder.java:219) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.routing.Router.doHandle(Router.java:422) [org.restlet-2.3.4.jar:] at org.restlet.routing.Router.handle(Router.java:639) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202) [org.restlet-2.3.4.jar:] at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:75) [org.restlet-2.3.4.jar:] at org.restlet.Application.handle(Application.java:385) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.routing.Router.doHandle(Router.java:422) [org.restlet-2.3.4.jar:] at org.restlet.routing.Router.handle(Router.java:639) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.routing.Router.doHandle(Router.java:422) [org.restlet-2.3.4.jar:] at org.restlet.routing.Router.handle(Router.java:639) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.doHandle(Filter.java:150) [org.restlet-2.3.4.jar:] at org.restlet.routing.Filter.handle(Filter.java:197) [org.restlet-2.3.4.jar:] at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202) [org.restlet-2.3.4.jar:] at org.restlet.Component.handle(Component.java:408) [org.restlet-2.3.4.jar:] at org.restlet.Server.handle(Server.java:507) [org.restlet-2.3.4.jar:] at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63) [org.restlet-2.3.4.jar:] at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143) [org.restlet-2.3.4.jar:] at org.restlet.ext.servlet.ServerServlet.service(ServerServlet.java:1117) [org.restlet.ext.servlet-2.3.4.jar:] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21] at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1] at java.lang.Thread.run(Unknown Source) [rt.jar:1.8.0_73]

I've written a simple reporting application which will generate a report in Excel format. Upon completion the page (ReportList.jsp) will then forward a URL to another page (ReportSuccess.jsp) where user have to right click and choose "Save as" to retrieve the report.

On the development environment (XP SP2 with MS Office installed) there is no problem encountered. However, when I ported over the codes to the server (Windows Server 2003 with Open Office installed), when user right click and "Save as" the type is changed to HTML by default.

I've set the file association of .XLS files to be opened by Calc but still that does not solve it. Any other idea?

Additional info: When I right click on the link to view the properties it showed up correctly as "http://<myIP>:8185/SnetReport/REPORT/Gymboree.xls"

I have modified my code to avoid using OutputStream since it will cause a lot of problem. Now my modified code looks like this:

try { String ROOT_PATH = "C:\\tomcat\\webapps\\SnetReport\\REPORT\\"; FileInputStream in = new FileInputStream(ROOT_PATH + sFilename); response.setContentType("application/xls"); response.setHeader("Content-Disposition", "attachment;filename=\"Report.xls\""); int i; while ((i=in.read()) != -1) { out.write(i); } in.close(); out.close(); } catch(Exception e) { System.out.println("...error while loading: "+e.toString()); }

After I ran through this code my JSP page will refresh and show me this screen:



In addition, Tomcat shows following message:

Nov 29, 2007 10:44:38 AM org.apache.jasper.runtime.PageContextImpl release
WARNING: Internal error flushing the buffer in release()

No no no. The codes are within the JSP tags <% %>

Actually my JSP will be calling a Java program which will generate a report in Excel (Using JExcel API). After the report is created it will be stored in C:\tomcat\webapps\SnetReport\REPORT

What I am trying to do is to pop up a save file dialog box so that the user can retrieve the file from the web instead of having to go into the folder to get it manually.

Hi Ben,

It's in JSP, that's why I posted it under the JSP forum.

Additional info, this chunck of codes are embedded within

<form name="frm" method="POST">
//Code goes here
</form>
[ November 27, 2007: Message edited by: Maruli Lee ]

I had a previous program which is working fine so I just copied the chunk of code and paste it on the new program which I am building. Basically my program will generate a report using JExcel API and then I will try to display it on the web so that user can Open/Save/Cancel it (the normal IE notification window). Furthermore, there is no error message on the tomcat log.

String output = "C:\\tomcat\\webapps\\SnetReport\\REPORT\\" + sFilename; File f = new File (output); //set the content type(can be excel/word/powerpoint etc..) response.setContentType ("application/xls"); //set the header and also the Name by which user will be prompted to save response.addHeader ("Content-Disposition", "attachment;filename=\"Gymboree.xls\" "); //get the file name String name = f.getName().substring(f.getName().lastIndexOf("/") + 1,f.getName().length()); try { //OPen an input stream to the file and post the file contents thru the //servlet output stream to the client m/c InputStream in = new FileInputStream(f); // The program will not get past the line below [B]ServletOutputStream outs = response.getOutputStream();[/B] int bit = 256; int i = 0; while ((bit) >= 0) { bit = in.read(); outs.write(bit); } outs.flush(); outs.close(); in.close(); } catch (IOException e) { e.printStackTrace(System.out); }

[ November 27, 2007: Message edited by: Maruli Lee ]
[ November 27, 2007: Message edited by: Bear Bibeault ]

Stuart Ash: No, this is not a homework. This is the last part of a project I am working on (report generation)

Thomas Drew: Thanx for the link. Actually, I am using that API for my report generation.

Jesper de Jong:
Input String is:
Action: Shafqat is supportive to company initiatives and changes, but I find that he personally preferred to have a clear plan to guide his work in a scheduled and systematic way. Impact: Several coordinating roles are created in his team to pre-planned flexibility for his team to meet the production needs or changes more effectively. Suggestion: Shafqat is encourged to give more supports to his technicians after allocating responsibilities to them and work closely with them in order to produce effective outcomes.

Expected Output is:
Action: Shafqat is supportive to company initiatives and changes, ........ his work in a scheduled and systematic way. Impact: Several coordinating roles are created in his team to ......... changes more effectively. Suggestion: Shafqat is encourged to give more supports to ........ closely with them in order to produce effective outcomes.

Executed Output is:
Action: Shafqat is supportive to company initiatives and changes, ........ his work in a scheduled and systematic way. Impact: Several coordinating roles are created in his team to ............ his team to meet the production needs or changes more effectively. Suggestion: Shafqat is encourged to give more supports to his technicians after allocating responsibilities to them and work closely .......outcomes.

P.S: Results are based on int iAllowedChar = 138

[ November 21, 2005: Message edited by: Maruli Lee ]

[ November 21, 2005: Message edited by: Maruli Lee ]
[ November 21, 2005: Message edited by: Maruli Lee ]

Dear Java programmer,

I am building a string manipulator function in java. A list of long string will be sliced into a few parts before adding them into excel's cell.

Basically, I have defined the width of the cell in the excel template that i created. A cell will be able to show up to 160 characters, the 161st character would be shown on the next row

However there are a few rules:
1. If there is a carriage return, the next string after it will be put in the next row.
2. If the 160th character is part of a word, that word should be put in the next row. For example: "Manipulation" and the 160th char is "p", the whole word Manipulation will be inserted into the next row.

I have wrote the code but it is still not perfect yet. Anyone who can help me to correct it?

import java.lang.*; import java.util.*; import java.sql.*; import java.io.Serializable; import java.text.*; import java.lang.Float; import java.util.Date; public class StringManipulator implements Serializable { public String mod_comment(String comment) throws SQLException, Exception { int i = 0;// Variable for loop purposes int x = 0; int iCount = 0; int iRowNeeded = 0;// Variable to determine how many rows are needed for comments int iAllowedChar = 160;// This is the amount of char to be shown in a cell, including space int iCurr = 0, iFirst = 0, iLast = 0; int iTotalChar = comment.length(); String sChunk = ""; String sModifiedComment = ""; System.out.println("************************************************"); System.out.println(comment); System.out.println("************************************************"); System.out.println("\n"); // Scan through the comments for(i=0; i<=iTotalChar-1; i++) { // Get <iAllowedChar> characters and store into a temporary variable // If total chars are less than <iAllowedChar>, store whole comments into temp var. // If total chars are more than <iAllowedChar>, break comments into chunks of <iAllowedChar> to work on if (i == 0) iFirst = 0; else iFirst = i; if (iTotalChar < iAllowedChar) iAllowedChar = iTotalChar; if ((iFirst+iAllowedChar) > iTotalChar) { sChunk = comment.substring(iFirst, iTotalChar); iLast = -1; } else { sChunk = comment.substring(iFirst, iFirst+iAllowedChar); iLast = sChunk.indexOf("\n", iFirst);// Check for carriage return (CR) } if (iLast >= 0)// If there is no CR, it will return -1 { sModifiedComment = sModifiedComment + sChunk.substring(iFirst, iLast); sModifiedComment = sModifiedComment + "\n"; i = (i + iLast); } else { if ( (iFirst+iAllowedChar) > iTotalChar ) iLast = iTotalChar - 1; else iLast = iFirst+iAllowedChar; if ( (iLast+1) <= iTotalChar && (iLast+2) <= iTotalChar ) { // Is the next character a space? if (comment.substring(iLast, iLast+1).equals(" ")) { sModifiedComment = sModifiedComment + comment.substring(iFirst, iLast); sModifiedComment = sModifiedComment + "\n"; i = iLast + 1; } else { // Loop back from the last char (in a cell) to detect blank space // This is to split the 'unfinished' word and insert to the next cell for(x=iLast; x>0 && x<=iLast; x--) { if (comment.substring(x-1, x).equals(" ")) { sModifiedComment = sModifiedComment + comment.substring(iFirst, (x-1)); sModifiedComment = sModifiedComment + "\n"; i = (x-1); x = 0;// To break the loop } } } } else { sModifiedComment = sModifiedComment + comment.substring(iFirst, iLast); sModifiedComment = sModifiedComment + "\n"; i = iLast; } } iRowNeeded++; }// End for loop System.out.println("sModifiedComment = " + sModifiedComment); return sModifiedComment; } public static void main(String [] args) throws SQLException, Exception { StringManipulator SM = new StringManipulator(); String sTEMP = "Action:\n"; sTEMP = sTEMP + "Shafqat is supportive to company initiatives and changes, but I find that he personally preferred to have a clear plan to guide his work in a scheduled and systematic way. \n\n"; sTEMP = sTEMP + "Impact: \n"; sTEMP = sTEMP + "Several coordinating roles are created in his team to pre-planned flexibility for his team to meet the production needs or changes more effectively. \n\n"; sTEMP = sTEMP + "Suggestion:\n"; sTEMP = sTEMP + "Shafqat is encourged to give more supports to his technicians after allocating responsibilities to them and work closely with them in order to produce effective outcomes."; SM.mod_comment(sTEMP); } }

Dear Tomcat users,

I'm developing a JSP application with MS SQL as the database. During the process of certain pages the tomcat suddenly just crash and the application comes to a halt. The crash didn't happen on just that pages, it can happen on any page in the application and it happen intermittently.

Does anyone has any idea what i should check on in order to combat this?

P.S: I am running on Tomcat 4.1.29 and Windows XP SP2

Regards,
Mar
[ January 20, 2005: Message edited by: Maruli Lee ]

Hi guys,

Hashtable solved my problems. Neways, thanx for all of your suggestion. Really appreciate that.

My apologies for not describing the matter well enough. Here it is with more details.

What i want to establish is:
===========================================================================
I have a .java file which establish connection to the database, retrieve data and store them into a Result Set.

Over to the JSP page, I would like to use this Result Set for comparison. Basically i am doing a translation from English to Other language. If there is a text "Password" on the login page, I have to get the text "Password" and look for it in the database, retrieve the translated words and displays it on the page.
===========================================================================

I have tried doing that by opening up the result set each time i need to translate (recalling the function in the .java file). However, the page loads much slower and therefore i would like to try other alternative.

Dear Java programmers,

I just started my first project on java and there are so many questions i would like to know the answer. However, the main priority is whether it is possible to create a public result set which is shared by all the JSP pages.

Regards,
Mar