Upload Excel using IO and servlet

[Prashanth Bhanu]

Hi All,

I'm having a difficulty in uploading a Excel file from my standalone java client to server using servlet.At the server side servlet throws

"I/O exception:Is not in GZIP format" {Thrown by GZIPInputStream}

Note:It is thrown exactly at "in = new GZIPInputStream( in );" (line in the servlet code).I've no clue how this exception is thrown and why uploading of file is not appening.Will be great help if you all ready to help me to address the issue.Thanks in advance

My client code
---------------

public class UploadClient
{
 
public static void main( String[] args ) throws Exception
{
String fileLocationAndName = "C:\\Prashanth\\Any.xls";
final PipedOutputStream pipeOut = new PipedOutputStream();
final PipedInputStream pipeIn = new PipedInputStream( pipeOut );
final InputStream fileIn = new FileInputStream( fileLocationAndName);
final InputStream in = new BufferedInputStream( fileIn );
final OutputStream out = new GZIPOutputStream( pipeOut );
 
Runnable r = new Runnable()
{
public void run()
{
try
{
try
{
byte[] buf = new byte[ 4096 ];
int count = in.read( buf );
while ( count > 0 )
{
System.out.println( "GZipping " + count + " bytes." );
out.write( buf, 0, count );
count = in.read( buf );
}
System.out.println( "Finished gzipping!" );
}
finally
{
pipeOut.flush();
out.flush();
out.close();
in.close();
fileIn.close();
}
}
catch ( Exception e )
{
e.printStackTrace();
}
}
};

// A separate thread fills the PipedInputStream with the gzipped content.
new Thread( r ).start();
 
PostMethod post = new PostMethod(SCBResourceBundleHelper.getClientWebBundle(SCBRBundelConstants.UPLOAD_URL));
post.addParameter("fileName", fileLocationAndName);
//NameValuePair nameValue = new NameValuePair();
post.addParameter("uploadType", "tradeSecuritization");
post.addParameter("line", "onOrOffLine");
post.addParameter("upLoadID", "upLoadID");
post.addParameter("bankGroupCode", "bankGroupCode");
post.addParameter("sourceSystem", "sourceSystem");
post.addParameter("userID", "Prashanth");
post.addParameter("bizDate","bizDate");
post.addParameter("excludeReason","excludeReason");

// It's very important to set Transfer-Encoding to "chunked", unless we
// want to pre-zip the file to disk or memory to figure out an exact
// content-length value.
int AUTO = InputStreamRequestEntity.CONTENT_LENGTH_AUTO;
RequestEntity re = new InputStreamRequestEntity( pipeIn, AUTO );
post.setRequestEntity( re );
post.setRequestHeader( "Content-Encoding", "gzip" );
 
HttpClient client = new HttpClient();
int statusCode = client.executeMethod( post );
 
// Let's see what the server sent back as content.
InputStream response = post.getResponseBodyAsStream();
response = new BufferedInputStream( response );
int c = response.read();
StringBuffer buf = new StringBuffer( 8 * 1024 );
while ( c >= 0 )
{
byte b = (byte) c;
buf.append( (char) b );
c = response.read();
}
post.releaseConnection();
System.out.println( "RESPONSE FROM HTTP SERVER:" );
System.out.println( "------------------------------------------------" );
System.out.println( buf.toString() );
System.out.println( "------------------------------------------------" );
System.out.println( "HTTP Status Code: " + statusCode );
}
 

servlet code is
===================

public class UploadZipServlet extends HttpServlet
{
public void doPost( HttpServletRequest req, HttpServletResponse res )
      throws IOException
{

res.setContentType( "text/plain" );
res.setCharacterEncoding( "UTF-8" );
PrintWriter writer = res.getWriter();

 
String contentEncoding = req.getHeader( "Content-Encoding" );
boolean isGzip = false;
if ( contentEncoding != null )
{
isGzip = "gzip".equalsIgnoreCase( contentEncoding.trim() );
}
if ( isGzip )
{
InputStream in = req.getInputStream();
in = new BufferedInputStream( in );
in = new GZIPInputStream( in );
 
StringBuffer buf = new StringBuffer( 4096 );
int c = in.read();
int count = 0;
while ( c >= 0 )
{
count++;
byte b = (byte) c;
if ( count <= 4096 )
{
buf.append( (char) b );
}
c = in.read();
}
 
writer.println( "First 4KB: " );
writer.println( "-------------------------------------------" );
writer.println( buf.toString() );
writer.println( "-------------------------------------------" );
writer.println( "Content unzipped to " + count + " bytes." );
}
else
{
writer.println( "Content-Encoding is not gzip!" );
writer.println( "-------------------------------------------" );
writer.println( "Content-Encoding: [" + contentEncoding + "]" );
}
 
writer.close();
}
 

}

[Chandan Ghosh]

Hey,

I just run your code using HttpClient 3.1. and it working absolutely fine. I didnt get any such exceptions....

I changed nothing except the url of the post method action.

[Prashanth Bhanu]

Hi Chandan,

Thanks for your prompt reply and testing the code.I'm also using commons-httpclient-3.1.jar in my client projects class path.I've copy and pasted the exact exception i'm getting at the server this might give if at all some thin is wrong at my servlet end..Please suggest....

[8/23/08 22:18:04:944 SGT] 00000030 FileRepositor A ADMR0010I: Document cells/MYD332SD1SNode01Cell/applications/ECHO_magellan_srv_ear.ear/deployments/ECHO_magellan_srv_ear/deployment.xml is modified.

[8/23/08 22:18:37:507 SGT] 00000025 ServletWrappe I SRVE0242I: [ECHO_magellan_srv_ear] [/ECHO_magellan_srv_web] [UploadZipServlet]: Initialization successful.

[8/23/08 22:18:43:366 SGT] 00000025 ServletWrappe E SRVE0068E: Uncaught exception thrown in one of the service methods of the servlet: UploadZipServlet. Exception thrown : java.io.IOException: Not in GZIP format

at java.util.zip.GZIPInputStream.readHeader(GZIPInputStream.java:156)

at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java)

at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java)

at com.scb.web.download.UploadZipServlet.doPost(UploadZipServlet.java)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)

at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)

at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)

at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)

at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:274)

at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)

at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)

[Prashanth Bhanu]

Hi All,


I'm still having trouble in uploading the Excel file to load to the server.Do we have to do any server specific setting(like MIME etc..) for the server to accept GZIP files.....I'm not sure where the problem is...

Thanks in advance