ram kumar

Ranch Hand

+ Follow

news 146 Posts 35 Threads

since May 22, 2008

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by ram kumar

XML on SOAP and HTTP, basic understanding

Yes, Thanks man ! Good Work.

>>5. When HTTP Can carry the XML Messages ! Why SOAP is used to carry the XML Messages ? SOAP can be discarded !

>> Can you write me a simple wsdl that has a operation called Print(String value) that passes string as a parameter and returns a String response ...
"Welcome ! Greetings ". that would help me understand the framework.

>> I am using RAD and WebSphere6.1 integarated with Rapid Application Development IDE ...

Right now >>

I am having a WSDL file, and a java code(Webservice) is generated from the WSDL file, I use SOAP UI tool to test the webservice.,,

Unfortunately,

But i dont understand anything, since the wsdl file is too long to read and am new to webservices.

At the end, I need to understand

1.how is this wsdl written, how is the server code generated.
2.How is the client making a call to this framework.
3. The whole framework

I would need this to really put myself up in web services

I need to get a sample tutorial, a very simple tutorial ... that would work in RAD and websphere6.1 to create a web service.

""How are which things related? ""

the relation of XML / SOAP / HTTP / WSDL

Hope,
You will render a good helping hand, thanks Ivan Krizsan

15 years ago

Web Services

XML on SOAP and HTTP, basic understanding

I am very new bie to web services, and I just have simple doubts.

1.Is SOAP Protocol designed to carry messages in the xml format ?

2.Why cant HTTP carry the XML ? SOAP is also a similar protocol to HTTP !

3.What is WSDL doing here ?

4.How are they related ?

Though the answer is, big or small i would like to learn this through people, who are well versed in it?

Please dont provide me links !

I have read enough !

I just need to get cross verified about these concepts.

Would some one just help me in this aspect !

15 years ago

Web Services

Writing on excel file using POI

Ankit Garg wrote:

ram kumar wrote:The pop-up thing will work with this servlet solution (I think you want the pop-up to appear as it is the correct behavior)...

Yes ! Isint it right !

Well it is the right behavior. Browsers don't support excel files so they will ask you what you want to do with the response. Usually the browser lets you save the file or open it using a helper application...

No , I need to save the file to the disk .

I should give an option like that and that is the requirement too.

16 years ago

Other Open Source Projects

Writing on excel file using POI

Hey ankit and All !

After Converting from jsp to Servlet code for generating excel,

1.It does not change its color in the background and fore ground.
am not able to get the OPEN/SAVE/CLOSE dialog box.

2.if i say res.setContentType("application/vnd.ms-excel");

its giving me an empty excel file with no contents.

Please help in this regard.

I have give the servlet Code too,

package servlettest; import java.io.FileOutputStream; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.HSSFColor; public class TestServlet extends HttpServlet { public void doPost(HttpServletRequest req, HttpServletResponse res) { System.out.println("printing from servlet"); //res.setContentType("application/vnd.ms-excel"); //res.setHeader("Content-Disposition","attachment; filename=\"myexcel.xls\""); //demo of creating excel files using jsp //An excel file is built in the following hierarchy... //workbook->worksheet->row and cells // we have to create that one by one accordingly and populate it. try { //creating a new workbook HSSFWorkbook workbook = new HSSFWorkbook(); //create a new worksheet HSSFSheet worksheet1 = workbook.createSheet(); worksheet1.setColumnWidth((short)5,(short)10000); //create rows .. row index starts at zero //use the sheet object to create a row in that sheet. HSSFRow row1 = worksheet1.createRow(5); row1.setHeight((short)2000); //create cells on those rows. //HSSFCell cell1 = row1.createCell((short)0); //create a cell style HSSFCellStyle style1 = workbook.createCellStyle(); //set cell width and height //apply background color to the cell style1.setFillBackgroundColor(HSSFColor.YELLOW.index); //apply pattern to the background fill style1.setFillPattern(HSSFCellStyle.FINE_DOTS); //apply fore ground color to the cell //style1.setFillForegroundColor(HSSFColor.VIOLET.index); //apply alignment to the cell style1.setAlignment(HSSFCellStyle.ALIGN_CENTER); //create a font HSSFFont font1 = workbook.createFont(); //apply color to the font font1.setColor(HSSFFont.COLOR_NORMAL); //set font size //font1.setFontHeight((short)76);//not exact point as in excel .. please dont use it font1.setFontHeightInPoints((short)76); //set this font in style style1.setFont(font1); //create cells on those rows. HSSFCell cell1 = row1.createCell((short)5); //set style to the cell cell1.setCellStyle(style1); //POPULATE THE CELL cell1.setCellValue("HAI"); //create a stream to write this excel file FileOutputStream fout = new FileOutputStream("C:/sampleexcel1.xls"); //FileOutputStream fout = new FileOutputStream("C:/excelExample.xls"); //write the excel file workbook.write(fout); //flush the stream fout.flush(); //close the stream fout.close(); System.out.println("Excel file generated successfully ! "); } catch(Exception e) { System.out.println("Exception on this page : "+e); } } }

show more

16 years ago

Other Open Source Projects

Writing on excel file using POI

Ankit Garg wrote:Just read this to find out what you are doing wrong.

The pop-up thing will work with this servlet solution (I think you want the pop-up to appear as it is the correct behavior)...

The pop-up thing will work with this servlet solution (I think you want the pop-up to appear as it is the correct behavior)...

Yes ! Isint it right !

show more

16 years ago

Other Open Source Projects

Writing on excel file using POI

Ankit Garg wrote:Ram you are still doing it wrong. You need to do something like this in a Servlet

doGet(...){ response.setContentType("application/vnd.ms-excel"); //create an excel file's content using the POI library HSSFWorkbook workbook = new HSSFWorkbook(); : : : workbook.write(response.getOutputStream()); }

Yes ! Ankit am trying to integrate that ina servlet as Ulf said.

Of course, do you think that the background

color as i mentioned in the first post will change by making it as a servlet.

also the dialog box.

If so let me have touch on it.

show more

16 years ago

Other Open Source Projects

Writing on excel file using POI

Code corrected.

Hi Ankit, can you just answer some other questions in this scenario

Is that ok.

Still can any one help me in bringing the background color.

and

bringing the dialog box that will popup if i have used

contentType = "vnd.msexcel"

<%//i need this line to popup the dialog box.
//but it does not print any thing in the excel.
//@ page contentType="application/vnd.ms-excel"
%>

<%@ page language="java" %> <%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFFont"%> <%@page import="org.apache.poi.hssf.util.HSSFColor"%> <%//i need this line to popup the dialog box. //but it does not print any thing in the excel. //@ page contentType="application/vnd.ms-excel" %> <%@page import="java.io.FileOutputStream"%> <% try { out.println("Generating excel files"); out.println(" "); //demo of creating excel files using jsp //An excel file is built in the following hierarchy... //workbook->worksheet->row and cells // we have to create that one by one accordingly and populate it. //creating a new workbook HSSFWorkbook workbook = new HSSFWorkbook(); //create a new worksheet HSSFSheet worksheet1 = workbook.createSheet(); worksheet1.setColumnWidth((short)5,(short)10000); //create rows .. row index starts at zero //use the sheet object to create a row in that sheet. HSSFRow row1 = worksheet1.createRow(5); row1.setHeight((short)2000); //create cells on those rows. //HSSFCell cell1 = row1.createCell((short)0); //create a cell style HSSFCellStyle style1 = workbook.createCellStyle(); //set cell width and height //apply background color to the cell style1.setFillBackgroundColor(HSSFColor.YELLOW.index); //apply pattern to the background fill style1.setFillPattern(HSSFCellStyle.DIAMONDS); //apply fore ground color to the cell //style1.setFillForegroundColor(HSSFColor.VIOLET.index); //apply alignment to the cell style1.setAlignment(HSSFCellStyle.ALIGN_CENTER); //create a font HSSFFont font1 = workbook.createFont(); //apply color to the font font1.setColor(HSSFFont.COLOR_NORMAL); //set font size //font1.setFontHeight((short)76);//not exact point as in excel .. please dont use it font1.setFontHeightInPoints((short)76); //set this font in style style1.setFont(font1); //create cells on those rows. HSSFCell cell1 = row1.createCell((short)5); //set style to the cell cell1.setCellStyle(style1); //POPULATE THE CELL cell1.setCellValue("HAI"); //create a stream to write this excel file FileOutputStream fout = new FileOutputStream("C:/senet/Eclipse-ServerVersion/workspace/TomcatTestProjects/demo excel sheet/excel1.xls"); //FileOutputStream fout = new FileOutputStream("C:/excelExample.xls"); //write the excel file workbook.write(fout); //flush the stream fout.flush(); //close the stream fout.close(); out.println("Excel file generated successfully ! "); } catch(Exception e) { out.println("Exception on this page : "+e); } %>

show more

16 years ago

Other Open Source Projects

Writing on excel file using POI

Ankit Garg wrote:Ram what are you doing. You have added some HTML to that page, then later on you are creating a excel sheet in your JSP . You should separate the two things. Also when you say that the excel file is empty, what do you mean by that?? Do you mean to say that the excel file saved at C:\excelExample.xls??

Yes ! there are no contents in the excel file , saying size 0 kb.

how do you seperate the html and jsp code in this page !

i need both ! atleast to display title of the page.

show more

16 years ago

Other Open Source Projects

Writing on excel file using POI

Dear All ranchers,

Am using apache POI to write an excel

with one row, one cell, value "HAI"

row -5 cell -6 , value - hai

I have 2 clarifications.

1.when i say this line

<%@ page contentType="application/vnd.ms-excel" %>

It shows me a dialog box that says <OPEN> <SAVE> <CANCEL>

but none of the excel sheet contents are getting printed in the excel sheet , am getting a plain excel sheet

why ?

I need that dialog box and the content as HAI in the ROW -5 and Cell - 6 location.

2.when i comment that line and execute its working fine

as

< commented >
<%//@ page contentType="application/vnd.ms-excel" %>

3.when i say

style1.setFillBackgroundColor(HSSFColor.YELLOW.index);

it fills the cell with normal black.

color "yellow" is not coming in the background.

everything else is fine

I have given the code too :

Please clarify me, as am very new to this forum..

<html> <head> <title>Demo Downloading Excel Sheet from JSP</title> </head> <body> Hi ! This is your Excel Download page ! </body> </html> <%@ page language="java" %> <%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%> <%@page import="org.apache.poi.hssf.usermodel.HSSFFont"%> <%@page import="org.apache.poi.hssf.util.HSSFColor"%> <%//i need this line to popup the dialog box. //but it does not print any thing in the excel. //@ page contentType="application/vnd.ms-excel" %> <%@page import="java.io.FileOutputStream"%> <% try { //demo of creating excel files using jsp //An excel file is built in the following hierarchy... //workbook->worksheet->row and cells // we have to create that one by one accordingly and populate it. //creating a new workbook HSSFWorkbook workbook = new HSSFWorkbook(); //create a new worksheet HSSFSheet worksheet1 = workbook.createSheet(); worksheet1.setColumnWidth((short)5,(short)10000); //create rows .. row index starts at zero //use the sheet object to create a row in that sheet. HSSFRow row1 = worksheet1.createRow(5); row1.setHeight((short)2000); //create cells on those rows. //HSSFCell cell1 = row1.createCell((short)0); //create a cell style HSSFCellStyle style1 = workbook.createCellStyle(); //set cell width and height //apply background color to the cell style1.setFillBackgroundColor(HSSFColor.YELLOW.index); //apply pattern to the background fill style1.setFillPattern(HSSFCellStyle.DIAMONDS); //apply fore ground color to the cell //style1.setFillForegroundColor(HSSFColor.VIOLET.index); //apply alignment to the cell style1.setAlignment(HSSFCellStyle.ALIGN_CENTER); //create a font HSSFFont font1 = workbook.createFont(); //apply color to the font font1.setColor(HSSFFont.COLOR_NORMAL); //set font size //font1.setFontHeight((short)76);//not exact point as in excel .. please dont use it font1.setFontHeightInPoints((short)76); //set this font in style style1.setFont(font1); //create cells on those rows. HSSFCell cell1 = row1.createCell((short)5); //set style to the cell cell1.setCellStyle(style1); //POPULATE THE CELL cell1.setCellValue("HAI"); //create a stream to write this excel file //FileOutputStream fout = new FileOutputStream("C:/senet/Eclipse-ServerVersion/workspace/TomcatTestProjects/demo excel sheet/excel1.xls"); FileOutputStream fout = new FileOutputStream("C:/excelExample.xls"); //write the excel file workbook.write(fout); //flush the stream fout.flush(); //close the stream fout.close(); //out.println("Excel file generated successfully ! "); } catch(Exception e) { out.println("Exception on this page : "+e); } %>

show more

16 years ago

Other Open Source Projects

Including property file in the jar

Also, why dont you use fileoutputstream instead of file and printwriter

Any Advantages ?

show more

16 years ago

Java in General

Including property file in the jar

Hey All,

I searched how to set that in the properties

I did that too.

But, there lies the problem, am hard coding the path ,

since, prop.store uses fileoutputstream...

Is there any way to avoid this hard coding...

new FileOutputStream("C:/senet/Eclipse-ServerVersion/workspace/WorkOuts/src/ResourceBundle/mainpackage/test.properties");

:rolleyes: //setting the property FileOutputStream fout = new FileOutputStream("C:/senet/Eclipse-ServerVersion/workspace/WorkOuts/src/ResourceBundle/mainpackage/test.properties"); prop.setProperty("Process", "Success"); prop.store(fout, "Setting Property");

Complete code :

package ResourceBundle.mainpackage; import java.io.FileOutputStream; import java.io.InputStream; import java.io.PrintStream; import java.util.Properties; public class DemoGetResourceAsStream { public void usingGetResource() { try { //InputStream InputStream in = getClass().getResourceAsStream("test.properties"); System.out.println("in = "+in); Properties prop = new Properties(); prop.load(in); //get the property value System.out.println("prop.getProperty = "+prop.getProperty("Thanks")); //setting the property FileOutputStream fout = new FileOutputStream("C:/senet/Eclipse-ServerVersion/workspace/WorkOuts/src/ResourceBundle/mainpackage/test.properties"); prop.setProperty("Process", "Success"); prop.store(fout, "Setting Property"); //listing all the properties in the property file PrintStream out = new PrintStream(System.out); System.setOut(out); prop.list(out); } catch(Exception e) { System.out.println("Exception : "+e); } } public static void main(String args[]) { DemoGetResourceAsStream obj = new DemoGetResourceAsStream(); obj.usingGetResource(); } }

show more

16 years ago

Java in General

Including property file in the jar

K. Tsang wrote:Looks ok to me. As long as you get the "expected" output once the Properties is loaded then you should be fine.

Well since you are loading from within jar, but if you are generating on the fly - just to get your head think, what happens if the properties file has read/write access permission problems.

what should be done to change the access rights.

let that be part of the discussion .

Also,

This would be my important question like as get property , do we have a setProperty method that would set a property and value.

if setProperty is not there, how can we achieve it.

Is that just using fileoutputstream...

show more

16 years ago

Java in General

Including property file in the jar

K. Tsang wrote:

ram kumar wrote:Later i will start using it in all my logics

Hey Ram, honestly if you want to hard-code the path to the properties file bundle with jar, why don't you just generate it on the fly. Exactly what is in this properties file? Enter these things as properties -D when running java can be another option.

If the really want to bundle the ClassLoader.getResource(...) should work as is. Although the path of the properties file inside the jar needs to be fixed. And I don't suggest you put that file in the default package. Suppose your package structure is:

toppackage subpackage1 subpackage2

Put the file in say toppackage then you use "ClassLoader.getResource("toppackage/abc.properties");"

Thanks First !

That was a valid input, also.

some how i modified the code to behave this way ..

what do you think about this code.

i set the test.properties in the same package, where DemoGetResourceAsStream.java resides

i mean package ResourceBundle.mainpackage;

It worked perfectly,

I am doubting as will it work for unix machines also, without no change in the code.

package ResourceBundle.mainpackage; import java.io.InputStream; import java.util.Properties; public class DemoGetResourceAsStream { public void usingGetResource() { try { InputStream in = getClass().getResourceAsStream("test.properties"); System.out.println("in = "+in); Properties prop = new Properties(); prop.load(in); System.out.println("prop.getProperty = "+prop.getProperty("Welcome")); } catch(Exception e) { System.out.println("Exception : "+e); } } public static void main(String args[]) { DemoGetResourceAsStream obj = new DemoGetResourceAsStream(); obj.usingGetResource(); } }

AnyMore comments and chages are welcome

show more

16 years ago

Java in General

Including property file in the jar

ram kumar wrote:

Gamini Sirisena wrote:Try here first...

Is that possible to include that line of code to read as resourceBundle.

Later i will start using it in all my logics

Hey guys please give me a source code,

I am not able to point to the right directory to read a property file as a resourceBundle

am getting filenotfound exception.

say c:\tmp in windows and /tmp in unix machines

i have given the below code too.

am placing the test.properties in the same ResourceBundle package only still ot able to read.

my objective is, -- i will not say the Absolute path of the test.properties,

wherever test.properties is there in the machine, my program should get it from windows machines as well as unix machines

exclusive of the path and location it is present !

package ResourceBundle; import java.io.FileInputStream; import java.util.Enumeration; import java.util.PropertyResourceBundle; import java.util.ResourceBundle; public class DemoGetResourceAsStream { public void usingGetResource() { try { ResourceBundle rs = new PropertyResourceBundle(new FileInputStream("/test.properties")); System.out.println("rs = "+rs); Enumeration en = rs.getKeys(); while(en.hasMoreElements()) { System.out.println("usingGetResource : = "+en.nextElement()); } } catch(Exception e) { System.out.println("Exception : "+e); } } public static void main(String args[]) { DemoGetResourceAsStream obj = new DemoGetResourceAsStream(); obj.usingGetResource(); } }

Thanks

show more

16 years ago

Java in General

Including property file in the jar

Gamini Sirisena wrote:Try here first...

Is that possible to include that line of code to read as resourceBundle.

Later i will start using it in all my logics

show more

16 years ago

Java in General