Servlets :: Fetch Data From Backend (DB2) And Export To Excel - Slow File Download
Jan 31, 2014
Recently we got an issue about file download. We are using below code to fetch the data from backend(DB2) and export to excel.
Before Jan 15 it use to take 2 minutes to download the file (2 MB size). But now its taking half an hour to download.
response.setContentType("application/vnd.ms-excel");
response.setHeader("content-disposition","attachment; filename=Attendance_Report.xls");
We have restarted server, system but still problem exists. We found that there is no code level or data base level or network level issues.
Now we have to see server level issue. What are the factors which effects the file downloading at server level.
We are using websphere 6.1 ,java1.4
View Replies
ADVERTISEMENT
Aug 15, 2014
I need to get the html in string when i hit the hit the jsp in servlets basically i need to put the output of jsp in pdf file when i hit one link i need to download that data in pdf file. I am using itextpdf.
Sample code
pResponse.setContentType("application/pdf");
((HttpServletResponse) pResponse).setHeader("Content-Disposition", "attachment; filename=report.pdf");
//Get the output stream for writing PDF object
OutputStream outStream=pResponse.getOutputStream();
ByteArrayOutputStream baosPDF = new ByteArrayOutputStream();
[Code] ....
I need to convert the sample download.jsp to html so that i can parse
// XMLWorkerHelper.getInstance().parseXHtml(docWriter, document,new FileInputStream(jspPath),new FileInputStream(csspath) ,null ,new XMLWorkerFontProvider());
View Replies
View Related
May 27, 2010
I have a requirement to download the data from DB to CSV/Excel. What I did is retrieving all the records from DB and store in the List and pass that list to the jsp page. In JSP page, I am using the below setting to download it to CSV/EXCEL.
response.setContentType("application/vnd.ms-excel");
String fileName = "Report"+System.currentTimeMillis()+".xls";
response.setHeader("Content-disposition","attachment;filename="+fileName);
It was working fine. But I have an issues in it. Excel is capable of storing it only 65,536 rows. Even all the data getting downloaded to CSV/excel (> 65,536), while saving I am getting error from excel saying that it can't save more than 65,536 rows and the below data won't be saved.
This workbook contains data in cells outside of the row and column limit of the selected file format.
Data beyond 256 (IV) columns by 65,536 rows will not be saved.
Formula references to data in this region will return a #REF! error.
I am not opt for POI apache third party at this point of time. Is it possible to download it in other sheets if it exceeds the max limit.
Example: Having data of around 100,000.
Download 65,536 - Sheet 1
Remaining in Sheet 2,3.. of the same excel.
View Replies
View Related
May 2, 2015
I am trying to export a DB record to an excel sheet. Below is the code which I tried. I am not getting any error but still only the first record of the table is getting inserted into the excel sheet. But when I try printing, I prints all the records. Below is the code I did to insert records.
for (int i=0;i<ColumnCount;i++) {
System.out.println("Inside for");
Label label=new Label(i,0,rsmd.getColumnName(i+1),cellFormat);
sheet.addCell(label);
WritableCell cell = sheet.getWritableCell(i+1, 0);
System.out.println("Column " + rsmd.getColumnName(i+1)+ " inserted");
cell.setCellFormat(cellFormat);
[code]....
I hope i am making a logical mi stake in the for loop. But still i am unable to locate that.
View Replies
View Related
May 28, 2014
I have a JSP and Java program which will read data from Excel and add them dynamically to create table.My requirement is i should able to edit the columns what ever the data that was fetched from Excel and export those contents to another excel file.This should happen on clicking a button, i mean to exporting the contents of the table.
View Replies
View Related
Feb 24, 2014
As of now am using icefaces 1.8.2 provided tags for downloading data into excel sheet where i can download all the data from a data table. But now the requirement is like need to download the data into excel sheet based on values passed from UI as parameters to the action class method.
Attaching the code snippet along with this post.
CustomerList.xhtml :-
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<ice:outputLabel value="Export:" />
[Code] ....
View Replies
View Related
Nov 27, 2012
Is there a way to inform the Entity Manager or force the JPA provider to reload data from the database? The scenario could be data being updated by a store procedure or direct SQLPlus maintenance, without restarting the Application Server, the JPA need to load the newly updated data from the database.
I think the current JPA API is not enough. The void refresh(java.lang.Object entity) from EntityManager need to pass in the Entity object, I will like to know how to refresh the entire JPA Entity data after the physical table data being update from backend.
View Replies
View Related
Oct 2, 2014
I have a class that do a soap request to a web service , the response is containing a base64 string repressing a file content , how can i send this string to a servlet (maybe any other way) to send it to the user as a downloaded file .
View Replies
View Related
Jan 12, 2015
This issue is regarding response from the servlet
I have written a code to download .csv file with records from DB.
To download records i am uploading a .CSV file containing telephone number.
After downloading the .CSV file page is not getting refreshed.
Below is the code snippet i am using,where i am setting response content type as test/csv.
ServletOutputStream op = resp.getOutputStream();
// Set content type of output
resp.setContentType("text/csv");
resp.setHeader("Content-Disposition", "attachment; filename="test"");
op.flush();
op.close();
How that page will get refreshed after csv file download or after response.
View Replies
View Related
Jun 7, 2014
1) I will have to create two columns in MYSQL database and insert data in that, each column contain 8-9 k data.
2) Then i need to plot this data in chosen GUI in three separate plots on one screen as shown in attached image.
3) Time interval for X-axis for plotting individual graph is 0.001.
4) Then i need to plot these two waveform data against each other as XY graph as shown in graph.
How to do this or what language and technique i need to choose.
View Replies
View Related
Apr 11, 2015
I have a FileChooser:
JFrame parentFrame = new JFrame();
JFileChooser fileChooser = new JFileChooser();
fileChooser.setDialogTitle(txtPushCode.getText());
int userSelection = fileChooser.showSaveDialog(parentFrame);
if (userSelection == JFileChooser.APPROVE_OPTION) {
[Code] ....
But as you can see, it downloads only to "C:android empcoloricon.png". I want to download it to path where I chose in FileChooser with the name and extension I choose. In short, how can I use dynamic file path names in where ever I want in my applications?
View Replies
View Related
Oct 19, 2014
If I want to load data in excel file into table. what is the best way to do it?
View Replies
View Related
Oct 6, 2014
I am trying to display a list fetched from DB in a JSP.
My servlet mapping is:
<servlet>
<description></description>
<display-name>DocumentsServlet</display-name>
<servlet-name>DocumentsServlet</servlet-name>
<servlet-class>com.xyz.servlet.DocumentsServlet</servlet-class>
[Code] ...
The code in the servlet is:
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<Doc> docs = null;
Connection con = null;
[Code] ....
The code in JSP is:
<%
List<WWDoc> completedDocsList = (List)request.getAttribute("completedDocs");
System.out.println("In JSP == "+completedDocsList.size());
%>
The request is not coming back to the JSP page.
If I change the servlet and have "request.getRequestDispatcher("/pages/ViewCompletedWWDocs.jsp").forward(request, response);" un commented, I get exception "java.lang.IllegalStateException: Cannot forward a response that is already committed".
View Replies
View Related
Apr 9, 2015
I would like to understand how does multipart/form-data works during file upload scenario's, Does it chunks the data from client to server while transferring the files ?
View Replies
View Related
Jun 25, 2014
I am developing my college's project in JSP using jquery to open a magnific popup when user clicks on a link and the in the magnific Popup must be fetched from Mysql and i tried two approaches for this:
1. magnific Popup type is ajax here i passed the variable value in the link of href (after '?') to another JSP page where connection to database is created and queries are written in JSTL to fetch data and show this in magnific Popup .. But i failed in this approach, don't know in another JSP page the data without having database connection is loaded in the magnific Popup easily but not database data..
2. magnific Popup type inline here i need to pass the variable value in the same page between different tags..
View Replies
View Related
May 27, 2014
[public class Login
{
private String username;
private String password;
private String login_time;
private String logout_time;
private String status;
private String late;
[Code]...
but i am getting an error as but i am getting an error as
java.lang.NoSuchMethodException: com.tribro.chandu.Login.post();
View Replies
View Related
Nov 9, 2014
I've recently tried to write a file parser for the .x3d file type as it's one of the few 3d model types I can find written in easy to understand (and interpret) English. While it technically does work (or what I have so far), the issue is that it takes far too long (17 minutes) to parse just a part of the file (the vertices of the model).This is the code for the object itself:
import java.io.*;
import com.sun.j3d.utils.geometry.*;
import javax.media.j3d.*;
import javax.vecmath.*;
public class ModelLoader {
BranchGroup object = new BranchGroup();
BufferedReader reader;
String line = "start";
[code]....
Anyway, here are some observations I've made about the file:
-The line in the file itself that contains all the vertices is all one giant string according to the file.
-There are apparently 18,000 vertices in all (according to the command at line 18).
-Unless Netbeans automatically terminates infinite loops after a certain amount of time, it is most definitely NOT an infinite loop as I have seen the program terminate on its own (after 17 minutes, though).
I had a theory that maybe organizing each vertex into its own line and then having the program switch to the next line when it's done reading that vertex might make the program run faster, but I'm not sure why it would, so I thought I'd come here in case that theory turned out to be a dead end.
View Replies
View Related
Oct 8, 2014
We have a website used for downloading large files as large as 6gb and sometimes larger. We have all files in FTP server. The websit is JSP/Servlet /Tomcat combination. Below is code sample. I need a solution to increase the download speed. I understand it is bound to network bandwidth but are the steps that we need to take while we have such large files.I read about multipart downloads,gunzip streaming.
//first connect to FTP server and login and keep connection
Calendar cal=Calendar.getInstance();
startTime=cal.getTime();
fis=ftp.downloadFile(ftpclient,separator+resourceID);
response.setContentType("application/*");
response.setHeader("Content-Disposition", "attachment; filename="" + downloadFileName + "";");
byte[] bytes = new byte[1024];
[code]....
View Replies
View Related
Jul 3, 2014
I have a code that writes the text file uploaded in a server but I want to write a text that I get it from jsp page by request, how can I write it?
FileInputStream fileToDownload ;
private static final int BYTES_DOWNLOAD = 1024;
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws IOException{
response.setContentType("text/plain");
String name = request.getParameter("n");
response.setHeader("Content-Disposition",
[Code] ....
View Replies
View Related
Mar 25, 2015
I need to fetch the values inside the tag/node of an XML file.
The xml.file looks like this,
<numeric_values>
<data cc="100" ln="58">2291</data>
<data cc="100" ln="59">2291</data>
<data cc="105" ln="58">2389</data>
<data cc="105" ln="59">2389</data>
<data cc="110" ln="59">1</data>
<data cc="110" ln="57">1</data>
[Code]...
I need the value of cc and ln.
For example the first line contains cc = 100 and i need to fetch 100 and ln = 58 and i need the value 58.
View Replies
View Related
Aug 13, 2014
I'm trying to export a runnable jar file that requires lwjgl. Everything works in eclipse as I'm using
-Djava.library.path=nativewindows
as a VM Argument for the jinput .dll files.
After exporting & launching the jar it doesn't work of course! I get this error:
java.lang.UnsatisfiedLinkError: no junput-dx8 in java.library.path
I'm not sure how to make it work outside of eclipse....
View Replies
View Related
Jun 30, 2013
Below is my first servlet program:
FirstServlet.java:
package edu.aspire;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.Servlet;
import javax.servlet.ServletConfig;
[Code] .....
web.xml:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
[Code] ....
Deployement:
To deploy my project into %TOMCAT_HOME%webapps folder.
Right click on Project ->Export-> War File
Project Name: Hello
Destination: D:Program FilesApache Software FoundationTomcat 6.0webappsHello.war
Result found in web browser:
HTTP Status 404 - /Hello/first
And Hello.war file is not found in webapps folder too after exporting as .war.
I am using Apache tomcat 6.0.37, eclipse 3.7.2 release, tomcat plugin :com.sysdeo.eclipse.tomcat_3.3.0
View Replies
View Related
Oct 5, 2014
How to append the data in excel .. Checking the file if its known or unknown then save it to excel file like example
when i first run the program 3 files there in excel
when i run for the second time same it will be 6 files there in java
Here is the code
public String QueryACL(String myFilePaths) {
try {
SHAOneReported = new PrintWriter(new FileOutputStream(TodayDate.format(date) + "-SHA1SummaryReport.xls", true));
} catch (FileNotFoundException exc) {
JOptionPane.showMessageDialog(null, "File not Found.");
[Code] ....
View Replies
View Related
Jul 19, 2014
I am using JSF,richfaces. Need to import data from Excel file and show it in datatable.
How to achieve this?
View Replies
View Related
Jun 9, 2014
Export data to excell using XSSFWorkbook ... I am having error
javax.el.ELException: java.lang.OutOfMemoryError: Java heap space
Now I what to modify my code to BigGridDemo.java
[URL] ....
[URL] ....
How can I modify my code to BigGridDemo.java. This is my code
import com.bea.common.security.xacml.context.Result;
import com.sun.jmx.snmp.Timestamp;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.OutputStream;
[Code] ....
View Replies
View Related
Apr 23, 2015
I am trying to get the excel spreadsheet data and converting it in someway to java. I'm looking for something that will print out the java code itself that way I can embed it into future projects.
View Replies
View Related