Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 5967 invoked from network); 2 Jan 2008 08:18:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Jan 2008 08:18:41 -0000 Received: (qmail 26988 invoked by uid 500); 2 Jan 2008 08:18:08 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 26963 invoked by uid 500); 2 Jan 2008 08:18:08 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 26952 invoked by uid 99); 2 Jan 2008 08:18:08 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jan 2008 00:18:08 -0800 X-ASF-Spam-Status: No, hits=3.8 required=10.0 tests=HTML_MESSAGE,MIME_QP_LONG_LINE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [203.200.233.227] (HELO mail2.3i-infotech.com) (203.200.233.227) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jan 2008 08:17:55 +0000 Received: from newcorpsmtp.3i-infotech.com (corpsmtp.3i-infotech.com [10.1.46.247]) by mail2.3i-infotech.com (8.14.1/8.13.1) with ESMTP id m028H0q7011158 for ; Wed, 2 Jan 2008 13:47:00 +0530 Received: from newvashilinux.3i-infotech.com (newvashilinux.3i-infotech.com [10.1.46.204]) by newcorpsmtp.3i-infotech.com (8.13.8/8.13.1) with ESMTP id m028Guw2025639 for ; Wed, 2 Jan 2008 13:46:56 +0530 Received: (qmail 2009 invoked by uid 89); 2 Jan 2008 08:16:56 -0000 Received: from unknown (HELO smtppostfix.3i-infotech.com) (10.1.46.183) by newvashilinux.3i-infotech.com with SMTP; 2 Jan 2008 08:16:56 -0000 Received: from RWEGoverance (unknown [10.1.103.110]) by smtppostfix.3i-infotech.com (Postfix) with ESMTP id 26A1C18DD89 for ; Wed, 2 Jan 2008 13:46:56 +0530 (IST) From: "Rohit" To: Subject: file transfer error Date: Wed, 2 Jan 2008 13:46:54 +0530 Message-ID: <001b01c84d17$d6adf390$6e67010a@infotech.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_001C_01C84D45.F0662F90" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-3i-infotech.com-MailScanner1-OpenProtect-Information: Please contact the ISP for more information X-3i-infotech.com-MailScanner1-OpenProtect: Not scanned: please contact your Internet E-Mail Service Provider for details X-3i-infotech.com-MailScanner-OpenProtect-MCPCheck: , X-3i-infotech.com-MailScanner1-OpenProtect-From: rohit.yadav@3i-infotech.com X-3i-infotech.com-MailScanner-OpenProtect-Information: Please contact the ISP for more information X-3i-infotech.com-MailScanner-OpenProtect: Found to be clean X-3i-infotech.com-MailScanner-OpenProtect-From: rohit.yadav@3i-infotech.com X-Virus-Checked: Checked by ClamAV on apache.org ------=_NextPart_000_001C_01C84D45.F0662F90 Content-Type: multipart/alternative; boundary="----=_NextPart_001_001D_01C84D45.F0662F90" ------=_NextPart_001_001D_01C84D45.F0662F90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Dear All, I have a typical problem. When I am trying to copy files from through tomcat on one computer to other computer then I get exceptions as :- java.io.FileNotFoundException: \\10.1.103.110\FileUpload\Punjab\02-jan-08.enr (Access is denied) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:179) at java.io.FileOutputStream.(FileOutputStream.java:131) at extractor.MovingFile.copyFile(MovingFile.java:43) at extractor.MovingFile.copyDirectory(MovingFile.java:31) at extractor.FileGeneratorServlet.doGet(FileGeneratorServlet.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext Valve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137 ) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117 ) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:683) at java.lang.Thread.run(Thread.java:534) and also:- sendKey() java.io.IOException: Access is denied at java.io.WinNTFileSystem.createFileExclusively(Native Method) at java.io.File.createNewFile(File.java:828) at extractor.FileGeneratorServlet.sendKey(FileGeneratorServlet.java:425) at extractor.FileGeneratorServlet.doGet(FileGeneratorServlet.java:101) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext Valve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137 ) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117 ) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:683) at java.lang.Thread.run(Thread.java:534) However when I run tomcat on my machine and try to copy in my own computer then this works fine. Also when I run code only (see Moving File.java) to move file form one computer to other then through it works fine. Thanks and Regards, Rohit Yadav 3i-Infotech ltd | e-Governance | Software Executive | Bangalore 080-30541563 --- This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient.If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that 3i Infotech or its subsidiaries and associated companies, (collectively "3i Infotech"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of 3i Infotech. Before opening any attachments please check them for viruses and defects. ------=_NextPart_001_001D_01C84D45.F0662F90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear=20 All,
 &nb= sp;  I=20 have a typical problem. When I am trying to copy files from through tomcat = on=20 one computer to other computer then I get exceptions as=20 :-
 
java.io.FileNotFoundException: \\10.1.103.1= 10\FileUpload\Punjab\02-jan-08.enr=20 (Access is denied)
 at java.io.FileOutputStream.open(Native=20 Method)
 at=20 java.io.FileOutputStream.<init>(FileOutputStream.java:179)
 a= t=20 java.io.FileOutputStream.<init>(FileOutputStream.java:131)
 a= t=20 extractor.MovingFile.copyFile(MovingFile.java:43)
 at=20 extractor.MovingFile.copyDirectory(MovingFile.java:31)
 at=20 extractor.FileGeneratorServlet.doGet(FileGeneratorServlet.java:97)
 = ;at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at=20 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio= nFilterChain.java:237)
 at=20 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC= hain.java:157)
 at=20 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j= ava:214)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContex= tValve.java:198)
 at=20 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j= ava:152)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:13= 7)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:11= 7)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:102)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav= a:109)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
&n= bsp;at=20 org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
=  at=20 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)<= BR> at=20 org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn= ection(Http11Protocol.java:705)
 at=20 org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)<= BR> at=20 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja= va:683)
 at=20 java.lang.Thread.run(Thread.java:534)
 
and also:= -

sendKey()
java.io.IOException: Access is denied
 at=20 java.io.WinNTFileSystem.createFileExclusively(Native Method)
 at=20 java.io.File.createNewFile(File.java:828)
 at=20 extractor.FileGeneratorServlet.sendKey(FileGeneratorServlet.java:425)
&n= bsp;at=20 extractor.FileGeneratorServlet.doGet(FileGeneratorServlet.java:101)
&nbs= p;at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at=20 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio= nFilterChain.java:237)
 at=20 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC= hain.java:157)
 at=20 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j= ava:214)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContex= tValve.java:198)
 at=20 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j= ava:152)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:13= 7)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:11= 7)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:102)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav= a:109)
 at=20 org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveConte= xt.java:104)
 at=20 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)=
 at=20 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
&n= bsp;at=20 org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
=  at=20 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)<= BR> at=20 org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConn= ection(Http11Protocol.java:705)
 at=20 org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)<= BR> at=20 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.ja= va:683)
 at=20 java.lang.Thread.run(Thread.java:534)
 

 
 &nb= sp; =20 However when I run tomcat on my machine and try to copy in my own computer = then=20 this works fine.
 &nb= sp; =20 Also when I run code only (see Moving File.java) to move file form one= =20 computer to other then through it works fine.

Thanks and Regards,

Rohit Yadav
3i-Infotech ltd | e-Governance | Software Executive | Bangalore=20
080-30541563

 


This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by any= one who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recip= ient acknowledges that 3i Infotech or its subsidiaries and associated companies, (collectively "3i Infotech"), are unable to exercise control or e= nsure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in t= his message are those of the individual sender and no binding nature of the mes= sage shall be implied or assumed unless the sender does so expressly with due authority of 3i Infotech. Before opening any attachments please check them = for viruses and defects.

------=_NextPart_001_001D_01C84D45.F0662F90-- ------=_NextPart_000_001C_01C84D45.F0662F90 Content-Type: java/*; name="MovingFile.java" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="MovingFile.java" import java.io.*;=0A= import javax.swing.*;=0A= import java.sql.*;=0A= =0A= public class MovingFile{=0A= public static void main(String[] args) throws IOException{=0A= // String date=3DgetSystemDate();=0A= =0A= String src =3D "D:/FileExtractionData/19-nov-2007.enr";=0A= File srcDir =3D new File(src);=0A= String dst =3D "//10.1.103.142/MISReport/19-nov-2007.enr" ;= =0A= File dstDir =3D new File(dst);=0A= copyDirectory(srcDir, dstDir );=0A= }=0A= public static void copyDirectory(File srcDir, File dstDir ) throws IOExce= ption {=0A= =0A= =0A= if (srcDir.isDirectory()) {=0A= if (!dstDir.exists()) {=0A= dstDir.mkdir();=0A= }=0A= =0A= String[] children =3D srcDir.list();=0A= for (int i=3D0; i 0) {=0A= out.write(buf, 0, len);=0A= }=0A= in.close();=0A= out.close();=0A= }=0A= }=0A= /* public static String getSystemDate(){=0A= String date=3Dnull;=0A= String datetime=3Dnull;=0A= Connection con=3Dnull;=0A= Statement stmnt=3Dnull;=0A= ResultSet rs=3Dnull;=0A= =0A= try{=0A= con=3DgetTinxsysConnection();=0A= stmnt =3D con.createStatement();=0A= =0A= String query =3D"Select to_char(sysdate,'dd-mon-yyyy') from= dual";=0A= // System.out.println(" Sql query is "+query);=0A= rs =3D stmnt.executeQuery(query );=0A= int i=3D0;=0A= while(rs.next()){=0A= =0A= date =3D rs.getString(1);=0A= }=0A= // System.out.println(" Date and time is "+date);=0A= }catch(Exception e1){=0A= e1.printStackTrace();=0A= System.out.println("Exception is "+e1);=0A= }=0A= finally{=0A= try{=0A= =0A= if(rs!=3Dnull)rs.close();=0A= if(stmnt!=3Dnull)stmnt.close();=0A= if(con!=3Dnull)con.close();=0A= }catch(Exception e1){=0A= System.out.println("Exception in closing "+e1);=0A= }=0A= }=0A= =0A= return date;=0A= }=0A= =0A= // Added by shrikrishna for making a directory end=0A= =0A= //*** mathod to obtain connection=0A= =0A= public static Connection getTinxsysConnection() {=0A= =0A= Connection connection_extract=3Dnull;=0A= try {=0A= try {=0A= Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();=0A= } catch (IllegalAccessException illegalAccessException) {=0A= illegalAccessException.printStackTrace();=0A= } catch (InstantiationException instantiationException) {=0A= instantiationException.printStackTrace();=0A= }=0A= } catch (ClassNotFoundException e1) {=0A= System.out.println("Driver error");=0A= e1.printStackTrace();=0A= }=0A= try {=0A= connection_extract =3D DriverManager.getConnection("jdbc:or= acle:thin:@10.1.103.150:1521:infotech", "tinxsys_syn", "tinxsys_syn");=0A= // System.out.println("Connection to tinxsys successful");= =0A= =0A= } catch (SQLException sqlException) {=0A= System.out.println("Unable to connect to tinxsys database");= =0A= sqlException.printStackTrace();=0A= }=0A= return connection_extract;=0A= }=0A= =0A= }*/= ------=_NextPart_000_001C_01C84D45.F0662F90 Content-Type: java/*; name="UploadEncrypt.java" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="UploadEncrypt.java" // File for encryption,decryption,generating secret key=0A= =0A= package extractor;=0A= =0A= import java.io.File;=0A= import java.io.*;=0A= import java.io.FileInputStream;=0A= import java.io.FileOutputStream;=0A= import java.io.IOException;=0A= import java.io.InputStream;=0A= import java.io.OutputStream;=0A= import java.security.spec.AlgorithmParameterSpec;=0A= import java.util.zip.ZipEntry;=0A= import java.util.zip.ZipOutputStream;=0A= import javax.crypto.Cipher;=0A= import javax.crypto.CipherOutputStream;=0A= import javax.crypto.KeyGenerator;=0A= import javax.crypto.SecretKey;=0A= import javax.crypto.spec.IvParameterSpec;=0A= import javax.crypto.CipherInputStream;=0A= =0A= =0A= public class UploadEncrypt=0A= {=0A= Cipher ecipher;=0A= Cipher dcipher;=0A= byte[] buf =3D new byte[1024];=0A= private SecretKey key =3D null;=0A= =0A= public UploadEncrypt()=0A= {=0A= try=20=0A= {=0A= key =3D KeyGenerator.getInstance("DES").generateKey();=0A= =0A= // Create an 8-byte initialization vector=0A= =0A= byte[] iv =3D new byte[]{(byte)0x8E, 0x12, 0x39, (byte)0x9C, 0x07= , 0x72, 0x6F, 0x5A};=0A= AlgorithmParameterSpec paramSpec =3D new IvParameterSpec(iv);= =0A= =0A= ecipher =3D Cipher.getInstance("DES/CBC/PKCS5Padding");=0A= dcipher =3D Cipher.getInstance("DES/CBC/PKCS5Padding");=0A= =0A= // CBC requires an initialization vector=0A= =0A= ecipher.init(Cipher.ENCRYPT_MODE, key, paramSpec);=0A= dcipher.init(Cipher.DECRYPT_MODE, key, paramSpec);=0A= =0A= }=0A= catch (Exception e)=0A= {=0A= e.printStackTrace();=0A= }=0A= =0A= } // UploadEncrypt=0A= =0A= =0A= public boolean encrypt(InputStream in, OutputStream out)=0A= {=0A= try=20=0A= {=0A= =0A= // Bytes written to out will be encrypted=0A= =20=20=0A= out =3D new CipherOutputStream(out, ecipher);=0A= =0A= // Read in the cleartext bytes and write to out to encrypt=0A= int numRead =3D 0;=0A= while ((numRead =3D in.read(buf)) >=3D 0)=0A= {=0A= out.write(buf, 0, numRead);=0A= }=0A= out.close();=0A= }=0A= catch (java.io.IOException e)=0A= {=0A= e.printStackTrace();=0A= return false;=0A= }=0A= =0A= return true;=0A= =0A= } // encrypt=0A= =0A= public static boolean decrypt(InputStream in, OutputStream out, SecretK= ey key)=0A= {=0A= try=20=0A= {=0A= byte[] iv =3D new byte[]{(byte) 0x8E, 0x12, 0x39, (byte) 0x9C, 0x07, 0= x72, 0x6F, 0x5A};=0A= AlgorithmParameterSpec paramSpec =3D new IvParameterSpec(iv);= =0A= Cipher dcipher =3D Cipher.getInstance("DES/CBC/PKCS5Padding");=0A= dcipher.init(Cipher.DECRYPT_MODE, key, paramSpec);=0A= byte[] buf =3D new byte[1024];=0A= =0A= // Bytes read from in will be decrypted=0A= =0A= in =3D new CipherInputStream(in, dcipher);=0A= =0A= // Read in the decrypted bytes and write the cleartext to out=0A= =0A= int numRead =3D 0;=0A= while ((numRead =3D in.read(buf)) >=3D 0)=0A= {=0A= out.write(buf, 0, numRead);=0A= }=0A= out.close();=0A= in.close();=0A= =0A= }=0A= catch (Exception e)=0A= {=0A= e.printStackTrace();=0A= return false;=0A= }=0A= return true;=0A= =0A= }=0A= =0A= =0A= public SecretKey getKey()=0A= {=0A= return this.key;=0A= } // getKey=0A= =0A= public Cipher getDcipher()=0A= {=0A= return this.dcipher;=0A= } // getDcipher=0A= =0A= =0A= public boolean deleteEnr(String filename)=0A= {=0A= try=0A= {=0A= =09=09=09=09=0A= File file =3D new File(filename);=0A= file.delete();=0A= }=0A= catch(Exception e)=0A= {=0A= e.printStackTrace();=0A= return false;=0A= }=0A= =0A= return true;=0A= =0A= } // deleteEnr=0A= =0A= =0A= public boolean checkDelimiter(String record, String delimiter)=0A= {=0A= int index =3D record.indexOf(delimiter);=0A= if (index <=3D 0)=0A= return false;=0A= =0A= return true;=0A= }// checkDelimiter=0A= =0A= =0A= public boolean readFile(String filePath, String delimiter)=0A= {=0A= boolean status =3D false;=0A= try=0A= {=0A= =09=09=09=09=0A= if (filePath !=3D null)=0A= {=0A= =0A= FileReader fileReader =3D new FileReader(filePath);=0A= BufferedReader bufferedReader =3D new BufferedReader(fileReader);=0A= String strLine =3D null;=0A= while ((strLine =3D bufferedReader.readLine()) !=3D null)=0A= {=0A= if (!strLine.equals(""))=0A= status =3D checkDelimiter(strLine.trim(), delimiter);=0A= }=0A= fileReader.close();=0A= }=0A= =0A= }=0A= catch (Exception e)=0A= {=0A= e.printStackTrace();=0A= return status;=0A= }=0A= =0A= return status;=0A= =0A= }// readFile=0A= =0A= =0A= } // end of class=0A= ------=_NextPart_000_001C_01C84D45.F0662F90 Content-Type: java/*; name="MovingFile.java" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="MovingFile.java" // File to copy the files from client machine to server machine=0A= =0A= package extractor;=0A= =0A= import java.io.*;=0A= import javax.swing.*;=0A= =0A= public class MovingFile{=0A= =0A= public static void copyDirectory(File srcDir, File dstDir) throws IOExcep= tion=0A= {=0A= System.out.println("srcDir "+srcDir);=0A= System.out.println("dstDir "+dstDir);=0A= try=0A= {=0A= =0A= if (srcDir.isDirectory())=0A= {=0A= if (!dstDir.exists())=0A= dstDir.mkdir();=0A= =0A= String[] children =3D srcDir.list();=0A= for (int i=3D0; i 0)=0A= {=0A= out.write(buf, 0, len);=0A= }=0A= in.close();=0A= out.close();=0A= }=0A= =0A= }= ------=_NextPart_000_001C_01C84D45.F0662F90 Content-Type: java/*; name="FileGeneratorServlet.java" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="FileGeneratorServlet.java" //Servlet to generate files,zipping,encrypting and transferring files=0A= =0A= package extractor;=0A= =0A= import javax.servlet.*;=0A= import javax.servlet.http.*;=0A= import java.io.*;=0A= import java.sql.CallableStatement;=0A= import java.sql.Connection;=0A= import java.sql.Date;=0A= import java.sql.Timestamp;=0A= import java.sql.DriverManager;=0A= import java.sql.ResultSet;=0A= import java.sql.SQLException;=0A= import java.sql.Statement;=0A= import java.util.ArrayList;=0A= import java.util.*;=0A= import java.util.zip.*;=0A= import java.io.ObjectInputStream;=0A= import java.io.ObjectOutputStream;=0A= import javax.crypto.Cipher;=0A= import javax.crypto.spec.IvParameterSpec;=0A= import javax.crypto.KeyGenerator;=0A= import javax.crypto.SecretKey;=0A= import java.net.URL;=0A= import java.net.URLConnection;=0A= import java.security.spec.AlgorithmParameterSpec;=0A= import java.io.*;=0A= import javax.swing.*;=0A= =0A= =0A= public class FileGeneratorServlet extends HttpServlet implements Serializab= le=0A= {=0A= =0A= static String stateCode=3Dnull;=0A= static String serverUrl=3Dnull;=0A= static String serverRootDir=3Dnull;=0A= static String serverSubDir=3Dnull;=0A= static String clientDirectory=3Dnull;=0A= static String connectionURL=3Dnull;=0A= static String driverName=3Dnull;=0A= static String userName=3Dnull;=0A= static String password=3Dnull;=0A= static String serverURLToLoad=3Dnull;=0A= static String date=3Dnull;=0A= =0A= public void init(ServletConfig config) throws ServletException=0A= {=0A= serverUrl=3Dconfig.getInitParameter("serverUrl");=0A= serverRootDir=3Dconfig.getInitParameter("serverRootDir");=0A= serverSubDir=3Dconfig.getInitParameter("serverSubDir");=0A= stateCode=3Dconfig.getInitParameter("stateCode");=0A= clientDirectory=3Dconfig.getInitParameter("clientDirectory");=0A= connectionURL=3Dconfig.getInitParameter("connectionURL");=0A= driverName=3Dconfig.getInitParameter("driverName");=0A= userName=3Dconfig.getInitParameter("userName");=0A= password=3Dconfig.getInitParameter("password");=0A= serverURLToLoad=3Dconfig.getInitParameter("serverURLToLoad");=0A= serverURLToLoad=3DserverURLToLoad+"?stateCode=3D"+stateCode;=0A= date=3DgetSystemDate();=0A= }=0A= =0A= =0A= public synchronized void doGet(HttpServletRequest request, HttpServlet= Response response) throws ServletException, IOException=0A= {=0A= String fromDate=3Dnull;=0A= String toDate=3Dnull;=0A= SecretKey key=3Dnull;=0A= String serverURL=3Dnull;=0A= try=0A= {=0A= System.out.println("value of parameter is "+serverUrl = +" "+serverRootDir+" "+serverSubDir+" "+stateCode);=0A= fromDate=3Drequest.getParameter("fromDate");=0A= toDate=3Drequest.getParameter("toDate");=0A= System.out.println("from date is =3D"+fromDate+" to date is =3D"= +toDate);=0A= =0A= //creating text files=0A= =0A= createTextFiles(fromDate,toDate);=0A= =0A= // zipping files and encrypt=0A= =0A= key=3DcreateZipAndEncrypt();=0A= System.out.println("secret key to send is "+key);=0A= =0A= //transfering files to server"//10.1.103.64/FileUpload/Punjab/"+date+".enr";= =0A= =0A= String clientDir=3DclientDirectory+"/"+date+".enr";=0A= String serverDir =3D"//"+serverUrl+"/"+serverRootDir+"/"+serverSubD= ir+"/"+date+".enr";=0A= String dstDirectory=3D"//"+serverUrl+"/"+serverRootD= ir+"/"+serverSubDir+"/"+date ;=0A= File file=3Dnew File(dstDirectory);=0A= if(!file.isDirectory())=0A= new File(dstDirectory).mkdir();=0A= =0A= File srcDir =3D new File(clientDir);=0A= File dstDir =3D new File(serverDir);=0A= =0A= // MovingFile.copyDirectory(srcDir, dstDir);=0A= copyDirectory(srcDir, dstDir);=0A= //sending secret key to server=0A= =0A= sendKey(key);=0A= =0A= response.sendRedirect(serverURLToLoad);=0A= =0A= =0A= }=0A= catch(Exception e1)=0A= {=0A= e1.printStackTrace();=0A= System.out.println("unable to generate files ");=0A= }=0A= =0A= =0A= }=0A= =0A= =0A= =0A= =0A= =0A= //*** method to create text Files=0A= =0A= public static synchronized void createTextFiles(String fromDate,String = toDate)=0A= {=0A= =0A= try=0A= {=0A= // Creating dealer MASTER files=0A= =0A= String query_DLMB=3D " select 'DLMB$'||RC_NO||'$'||RC_NO||'$'||DM_TRA= DE_NAME||'$'||DEALER_ADDRESS1||'$'|| DEALER_ADDRESS2||'$'|| DEALER_ADDRESS3= ||'$$$$'||SUBSTR(LOCATION_ID,3,3)||'$$'|| BUSINESS_CONSTITUTION_DTLS||'$$'|= |to_char(VALIDITY_DATE,'dd-mon-yyyy')||'$'||to_char(CANCEL_DATE,'dd-mon-yyy= y')||'$'||DEALER_STATUS "+=0A= " FROM ETM_DM_DEALER WHERE SUBSTR(RC_N= O,5,1) <> 9 AND((RC_APPROVAL_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"')= OR (MODIFIED_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"' ) OR (CANCEL_DA= TE BETWEEN '"+fromDate+"' AND '"+toDate+"' )) AND RC_NO NOT LIKE 'T%' and r= ownum<10000 ORDER BY 1 ";=0A= createFile(query_DLMB,"DLMB");=0A= =0A= String query_BDWS=3D " SELECT DISTINCT 'BDWS$'||B.RC_NO||'$'||B.RC_NO= ||'$$'||B.ADDRESS1||'$'||B.ADDRESS2||'$'||B.ADDRESS3||'$$$' FROM ETT_DM_BUS= S_PLACES B, ETM_DM_DEALER D "+=0A= " WHERE B.ADDRESS_TYPE=3D'AD' AND B.BU= SS_PLACE_TYPE=3D'OF' AND B.STATE_CODE=3D'03' AND B.RC_NO =3D D.RC_NO AND((= D.RC_APPROVAL_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"') OR (D.MODIFIED= _DATE BETWEEN '"+fromDate+"' AND '"+toDate+"' ) OR (D.CANCEL_DATE BETWEEN = '"+fromDate+"' AND '"+toDate+"' )) and rownum<10000 ";=0A= createFile(query_BDWS,"BDWS");=0A= =0A= String query_WDWS=3D " SELECT DISTINCT 'WDWS$'||W.RC_NO||'$'||W.RC_NO= ||'$$'||W.ADDRESS1||'$'||W.ADDRESS2||'$'||W.ADDRESS3||'$$$' FROM ETT_DM_BUS= S_PLACES W, ETM_DM_DEALER D "+=0A= " WHERE W.ADDRESS_TYPE=3D'AD' AND W.BU= SS_PLACE_TYPE=3D'GD' AND W.STATE_CODE=3D'03' AND W.RC_NO =3D D.RC_NO AND((D= .RC_APPROVAL_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"') OR (D.MODIFIED_= DATE BETWEEN '"+fromDate+"' AND '"+toDate+"' ) OR (D.CANCEL_DATE BETWEEN '= "+fromDate+"' AND '"+toDate+"' )) and rownum<10000";=0A= createFile(query_WDWS,"WDWS");=0A= =0A= String query_DLBO=3D " SELECT DISTINCT 'DLBO$'||BS.RC_NO||'$'||BS.RC_= NO||'$$'||BS.ADDRESS1||'$'||BS.ADDRESS2||'$'||BS.ADDRESS3||'$$$$$' FROM ETT= _DM_BUSS_PLACES BS, ETM_DM_DEALER D "+=0A= " WHERE BS.ADDRESS_TYPE=3D'AD' AND BS.= BUSS_PLACE_TYPE=3D'OF' AND BS.STATE_CODE<>'03' AND BS.RC_NO =3D D.RC_NO = AND((D.RC_APPROVAL_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"') OR (D.MOD= IFIED_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"' ) OR (D.CANCEL_DATE BET= WEEN '"+fromDate+"' AND '"+toDate+"' )) and rownum<10000 ";=0A= createFile(query_DLBO,"DLBO");=0A= =0A= //Creating C-Form files=0A= =0A= String query_CIDL=3D " SELECT DISTINCT 'CIDL$'||B.RC_NO||'$'||B.RC_N= O||'$'||A.DM_TRADE_NAME||'$'||SUBSTR(B.LOCATION_ID ,3,3)||'$$'||to_char(B.I= SSUE_DATE,'dd-mon-yyyy')||'$'||B.SERIES||'$'||B.SERIAL_NO "+=0A= " FROM TT_FI_RD_EQUEST_ISSUE_NEW B, = ETM_DM_DEALER A WHERE A.RC_NO =3D B.RC_NO AND B.APPROVAL_DATE BETWEEN '"+f= romDate+"' AND '"+toDate+"' AND B.FORM_NO=3D'FR01' and rownum<10000";=0A= createFile(query_CIDL,"CIDL");=0A= =0A= String query_CUDL=3D " SELECT DISTINCT 'CUDL$'||A.RC_NO||'$'||A.RC_N= O||'$'||B.SALES_TAX_NO||'$$'||B.DEALER_NAME||'$$$$$$$$'||B.SERIES||'$'||B.S= ERIAL_NO||'$'||COUNT(B.SERIES||B.SERIAL_NO)||'$'||SUM(B.AMOUNT)||'$$' "+=0A= " FROM ETT_FI_FORMS_UTILIZATION A, ETT_= FI_FORMS_UTILIZATION_DTLS B WHERE A.FORM_NO=3D'FR01' AND A.FORMS_UTILIZATI= ON_NO=3DB.FORMS_UTILIZATION_NO and rownum<10000 "+=0A= " AND B.CREATION_DATE BETWEEN '"+fromDate+"' = AND '"+toDate+"' GROUP BY A.RC_NO,B.SALES_TAX_NO, B.DEALER_NAME,B.SERIES, B= .SERIAL_NO ";=0A= createFile(query_CUDL,"CUDL");=0A= =0A= String query_CBDL=3D " SELECT DISTINCT 'CBDL$'||a.RC_NO||'$'||a.RC_N= O||'$'||b.SERIES||'$'||b.SERIAL_NO||'$'||b.INVOICE_NO||'$'||TO_CHAR(b.DISTR= IBUTED_DATE,'DD-MON-YYYY')||'$'||AMOUNT||'$' FROM ETT_FI_FORMS_UTILIZATION= a, ETT_FI_FORMs_UTILIZATION_DTLS b "+=0A= " WHERE a.form_no=3D'FR01' AND a.FOR= Ms_UTILIZATION_NO=3Db.FORMs_UTILIZATION_NO AND b.CREATION_DATE BETWEEN '"+f= romDate+"' AND '"+toDate+"' and rownum<10000 ";=0A= createFile(query_CBDL,"CBDL");=0A= =0A= //Creating E1 Form files=0A= =0A= String query_E1ID=3D " SELECT DISTINCT 'E1ID$'||B.RC_NO||'$'||B.RC_NO|= |'$'||A.DM_TRADE_NAME||'$'||SUBSTR(B.LOCATION_ID ,3,3)||'$$'||to_char(B.ISS= UE_DATE,'dd-mon-yyyy')||'$'||B.SERIES||'$'||B.SERIAL_NO "+=0A= " FROM TT_FI_RD_EQUEST_ISSUE_NEW B,= ETM_DM_DEALER A WHERE A.RC_NO =3D B.RC_NO AND B.APPROVAL_DATE BETWEEN '"+= fromDate+"' AND '"+toDate+"' AND B.FORM_NO=3D'FR0004' and rownum<10000 ";= =0A= createFile(query_E1ID,"E1ID");=0A= =0A= String query_E1UD=3D" SELECT DISTINCT 'E1UD$'||A.RC_NO||'$$'||B.SALES_= TAX_NO||'$$$$$$$$$$'||B.SERIES||'$'||B.SERIAL_NO||'$'||COUNT(B.SERIES||B.SE= RIAL_NO)||'$'||SUM(B.AMOUNT)||'$$' "+=0A= " FROM ETT_FI_FORMS_UTILIZATION A, ETT_FI_FORMS_UTILIZ= ATION_DTLS B WHERE A.FORM_NO=3D'FR0004' AND A.FORMS_UTILIZATION_NO=3DB.FOR= MS_UTILIZATION_NO and rownum<10000 "+=0A= " AND B.CREATION_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"' G= ROUP BY A.RC_NO,B.SALES_TAX_NO, B.DEALER_NAME,B.SERIES, B.SERIAL_NO ";=0A= createFile(query_E1UD,"E1UD");=0A= =0A= String query_E1BD=3D " SELECT DISTINCT 'E1BD$'||a.RC_NO||'$'||a.RC_NO|= |'$'||b.SERIES||'$'||b.SERIAL_NO||'$'||b.INVOICE_NO||'$'||TO_CHAR(b.DISTRIB= UTED_DATE,'DD-MON-YYYY')||'$'||AMOUNT||'$' FROM ETT_FI_FORMS_UTILIZATION a= , ETT_FI_FORMs_UTILIZATION_DTLS b "+=0A= " WHERE a.form_no=3D'FR0004' AND a.= FORMs_UTILIZATION_NO=3Db.FORMs_UTILIZATION_NO AND b.CREATION_DATE BETWEEN '= "+fromDate+"' AND '"+toDate+"' and rownum<10000 ";=0A= createFile(query_E1BD,"E1BD");=0A= =0A= //Creating E2 Form files=0A= =0A= String query_E2ID=3D " SELECT DISTINCT 'E2ID$'||B.RC_NO||'$'||B.RC_NO|= |'$'||A.DM_TRADE_NAME||'$'||SUBSTR(B.LOCATION_ID ,3,3)||'$$'||to_char(B.ISS= UE_DATE,'dd-mon-yyyy')||'$'||B.SERIES||'$'||B.SERIAL_NO "+=0A= " FROM TT_FI_RD_EQUEST_ISSUE_NEW B,= ETM_DM_DEALER A WHERE A.RC_NO =3D B.RC_NO AND B.APPROVAL_DATE BETWEEN '"+= fromDate+"' AND '"+toDate+"' AND B.FORM_NO=3D'FR0005' and rownum<10000 ";= =0A= createFile(query_E2ID,"E2ID");=0A= =0A= String query_E2UD=3D" SELECT DISTINCT 'E2UD$'||A.RC_NO||'$$'||B.SALES_= TAX_NO||'$$$$$$$$$$'||B.SERIES||'$'||B.SERIAL_NO||'$'||COUNT(B.SERIES||B.SE= RIAL_NO)||'$'||SUM(B.AMOUNT)||'$$' "+=0A= " FROM ETT_FI_FORMS_UTILIZATION A, ETT_FI_FORMS_UTILIZ= ATION_DTLS B WHERE A.FORM_NO=3D'FR0005' AND A.FORMS_UTILIZATION_NO=3DB.FOR= MS_UTILIZATION_NO and rownum<10000 "+=0A= " AND B.CREATION_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"' G= ROUP BY A.RC_NO,B.SALES_TAX_NO, B.DEALER_NAME,B.SERIES, B.SERIAL_NO ";=0A= createFile(query_E2UD,"E2UD");=0A= =0A= String query_E2BD=3D " SELECT DISTINCT 'E2BD$'||a.RC_NO||'$'||a.RC_NO|= |'$'||b.SERIES||'$'||b.SERIAL_NO||'$'||b.INVOICE_NO||'$'||TO_CHAR(b.DISTRIB= UTED_DATE,'DD-MON-YYYY')||'$'||AMOUNT||'$' FROM ETT_FI_FORMS_UTILIZATION a= , ETT_FI_FORMs_UTILIZATION_DTLS b "+=0A= " WHERE a.form_no=3D'FR0005' AND a.= FORMs_UTILIZATION_NO=3Db.FORMs_UTILIZATION_NO AND b.CREATION_DATE BETWEEN '= "+fromDate+"' AND '"+toDate+"' and rownum<10000 ";=0A= createFile(query_E2BD,"E2BD");=0A= =0A= //Creating F-Form files=0A= =0A= String query_FIDL=3D " SELECT DISTINCT 'FIDL$'||B.RC_NO||'$'||B.RC_N= O||'$'||A.DM_TRADE_NAME||'$'||SUBSTR(B.LOCATION_ID ,3,3)||'$$'||to_char(B.I= SSUE_DATE,'dd-mon-yyyy')||'$'||B.SERIES||'$'||B.SERIAL_NO "+=0A= " FROM TT_FI_RD_EQUEST_ISSUE_NEW B, = ETM_DM_DEALER A WHERE A.RC_NO =3D B.RC_NO AND B.APPROVAL_DATE BETWEEN '"+f= romDate+"' AND '"+toDate+"' AND B.FORM_NO=3D'FR0003' and rownum<1000 ";=0A= createFile(query_FIDL,"FIDL");=0A= =0A= String query_FUDL=3D " SELECT DISTINCT 'FUDL$'||A.RC_NO||'$'||A.RC_N= O||'$'||B.SALES_TAX_NO||'$$'||B.DEALER_NAME||'$$$$$$$$'||B.SERIES||'$'||B.S= ERIAL_NO||'$'||COUNT(B.SERIES||B.SERIAL_NO)||'$'||SUM(B.AMOUNT)||'$$' "+=0A= " FROM ETT_FI_FORMS_UTILIZATION A, ETT_= FI_FORMS_UTILIZATION_DTLS B WHERE A.FORM_NO=3D'FR0003' AND A.FORMS_UTILIZA= TION_NO=3DB.FORMS_UTILIZATION_NO and rownum<10000 "+=0A= " AND B.CREATION_DATE BETWEEN '"+fromDate+"' = AND '"+toDate+"' GROUP BY A.RC_NO,B.SALES_TAX_NO, B.DEALER_NAME,B.SERIES, B= .SERIAL_NO ";=0A= createFile(query_FUDL,"FUDL");=0A= =0A= String query_FBDL=3D " SELECT DISTINCT 'FBDL$'||a.RC_NO||'$'||a.RC_N= O||'$'||b.SERIES||'$'||b.SERIAL_NO||'$'||b.INVOICE_NO||'$'||TO_CHAR(b.DISTR= IBUTED_DATE,'DD-MON-YYYY')||'$'||AMOUNT||'$' FROM ETT_FI_FORMS_UTILIZATION= a, ETT_FI_FORMs_UTILIZATION_DTLS b "+=0A= " WHERE a.form_no=3D'FR0003' AND a.F= ORMs_UTILIZATION_NO=3Db.FORMs_UTILIZATION_NO AND b.CREATION_DATE BETWEEN '"= +fromDate+"' AND '"+toDate+"' and rownum<10000 ";=0A= createFile(query_FBDL,"FBDL");=0A= =0A= //Creating H-Form files=0A= =0A= String query_HIDL=3D " SELECT DISTINCT 'HIDL$'||B.RC_NO||'$'||B.RC_N= O||'$'||A.DM_TRADE_NAME||'$'||SUBSTR(B.LOCATION_ID ,3,3)||'$$'||to_char(B.I= SSUE_DATE,'dd-mon-yyyy')||'$'||B.SERIES||'$'||B.SERIAL_NO "+=0A= " FROM TT_FI_RD_EQUEST_ISSUE_NEW B, = ETM_DM_DEALER A WHERE A.RC_NO =3D B.RC_NO AND B.APPROVAL_DATE BETWEEN '"+f= romDate+"' AND '"+toDate+"' AND B.FORM_NO=3D'FR0002' and rownum<10000 ";=0A= createFile(query_HIDL,"HIDL");=0A= =0A= String query_HUDL=3D " SELECT DISTINCT 'HUDL$'||A.RC_NO||'$'||A.RC_N= O||'$'||B.SALES_TAX_NO||'$$'||B.DEALER_NAME||'$$$$$$$$'||B.SERIES||'$'||B.S= ERIAL_NO||'$'||COUNT(B.SERIES||B.SERIAL_NO)||'$'||SUM(B.AMOUNT)||'$$' "+=0A= " FROM ETT_FI_FORMS_UTILIZATION A, ETT_= FI_FORMS_UTILIZATION_DTLS B WHERE A.FORM_NO=3D'FR0002' AND A.FORMS_UTILIZA= TION_NO=3DB.FORMS_UTILIZATION_NO and rownum<10000 "+=0A= " AND B.CREATION_DATE BETWEEN '"+fromDate+"' = AND '"+toDate+"' GROUP BY A.RC_NO,B.SALES_TAX_NO, B.DEALER_NAME,B.SERIES, B= .SERIAL_NO ";=0A= createFile(query_HUDL,"HUDL");=0A= =0A= String query_HBDL=3D " SELECT DISTINCT 'HBDL$'||a.RC_NO||'$'||a.RC_N= O||'$'||b.SERIES||'$'||b.SERIAL_NO||'$'||b.INVOICE_NO||'$'||TO_CHAR(b.DISTR= IBUTED_DATE,'DD-MON-YYYY')||'$'||AMOUNT||'$' FROM ETT_FI_FORMS_UTILIZATION= a, ETT_FI_FORMs_UTILIZATION_DTLS b "+=0A= " WHERE a.form_no=3D'FR0002' AND a.F= ORMs_UTILIZATION_NO=3Db.FORMs_UTILIZATION_NO AND b.CREATION_DATE BETWEEN '"= +fromDate+"' AND '"+toDate+"' and rownum<10000 ";=0A= createFile(query_HBDL,"HBDL");=0A= =0A= //CREATING PERIODIC RETURN FILES=0A= =0A= String query_PRDL=3D " SELECT DISTINCT 'PRDL$'||A.RC_NO= ||'$$'||TO_CHAR(A.RETURN_PERIOD_FROM,'DD-MON-YYYY')||'$'||TO_CHAR(A.RETURN_= PERIOD_TO,'DD-MON-YYYY')||'$'||TO_CHAR(A.FILING_DATE,'DD-MON-YYYY')||'$'||A= .INTER_STATE_SALES||'$'||A.CST_LIABILITY||'$' FROM ETT_RA_VAT A,ETM_DM_DEAL= ER D "+=0A= " WHERE A.RC_NO =3D D.RC_NO AND((= D.RC_APPROVAL_DATE BETWEEN '"+fromDate+"' AND '"+toDate+"') OR (D.MODIFIED= _DATE BETWEEN '"+fromDate+"' AND '"+toDate+"' ) OR (D.CANCEL_DATE BETWEEN = '"+fromDate+"' AND '"+toDate+"' )) and rownum<10000 ";=0A= createFile(query_PRDL,"PRDL");=0A= =0A= =0A= =0A= =0A= =0A= =0A= }=0A= catch(Exception e1)=0A= {=0A= e1.printStackTrace();=0A= System.out.println("unable to make DLMB file");=0A= }=0A= }=0A= =0A= =0A= =0A= =0A= //*** mathod to create text files=0A= =0A= public static synchronized void createFile(String query,String ta= bleCode)=0A= {=0A= Connection con=3Dnull;=0A= Statement stmnt=3Dnull;=0A= ResultSet rs=3Dnull;=0A= String record;=0A= BufferedWriter bw2 =3Dnull;=0A= int i=3D0;=0A= =0A= String directory=3DclientDirectory+"/"+date;=0A= String originalFile=3Ddirectory+"/"+tableCode+".txt";=0A= try=0A= {=0A= con=3DgetStateConnection();=0A= File file=3Dnew File(directory);=0A= if(!file.isDirectory())=0A= new File(directory).mkdir();=0A= =0A= File f=3Dnew File(originalFile);=0A= if(f.exists())=0A= {=0A= f.delete();=0A= f.createNewFile();=0A= }=0A= bw2 =3Dnew BufferedWriter(new FileWriter(originalFile));=0A= =0A= stmnt =3D con.createStatement();=0A= rs =3D stmnt.executeQuery(query);=0A= while(rs.next())=0A= {=0A= record =3D rs.getString(1);=0A= i++;=0A= bw2.write(record);=0A= bw2.newLine();=0A= }=0A= =0A= bw2.close();=0A= }=0A= catch(Exception e1)=0A= {=0A= e1.printStackTrace();=0A= System.out.println("Exception is "+e1);=0A= }=0A= finally=0A= {=0A= try=0A= {=0A= bw2.close();=0A= if(rs!=3Dnull)rs.close();=0A= if(stmnt!=3Dnull)stmnt.close();=0A= if(con!=3Dnull)con.close();=0A= }=0A= catch(Exception e2)=0A= {=0A= e2.printStackTrace();=0A= }=0A= }=0A= =0A= }=0A= =0A= // method to create zip files and encrypt=0A= =0A= public static synchronized SecretKey createZipAndEncrypt()=0A= {=0A= =0A= UploadEncrypt uploadEncrypt =3D null;=0A= SecretKey key =3D null;=0A= Cipher cipherForDenr =3D null;=0A= BufferedInputStream in =3D null;=0A= int count;=0A= String directory=3DclientDirectory+"/"+date;=0A= File inFolder=3Dnew File(directory);=0A= File outFolder=3Dnew File(directory+".zip");=0A= String encryptFile =3D directory+".enr";=0A= String encryptFileLOC_remote =3D "//10.1.103.110/FileUpload/Punjab/";=0A= =0A= //Zipping file=0A= =0A= try=0A= {=0A= ZipOutputStream out =3D new ZipOutputStream(new BufferedOutputStream(n= ew FileOutputStream(outFolder)));=0A= byte[] data =3D new byte[1000];=0A= String files[] =3D inFolder.list();=0A= for (int i=3D0; i 0)=0A= {=0A= out.write(buf, 0, len);=0A= }=0A= in.close();=0A= out.close();=0A= }=0A= =0A= =0A= }=0A= ------=_NextPart_000_001C_01C84D45.F0662F90 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org ------=_NextPart_000_001C_01C84D45.F0662F90--