nick sharma

Hi
I have a small problem regarding parsing data in a column using only select statement

Say there is some data "abc;def;ghi;" in a column which needs to be displayed as

abc
def
ghi

using only select statement.

I know we can write a procedure to easily do this but i would like to know how it can be done using only select whether nested or inline.I tried using string functions but couldn't think of some logic to do it.

Thanks
Nikhil

Hi
I have a small problem regarding parsing data in a column using only select statement

Say there is some data "abc;def;ghi;" in a column which needs to be displayed as

abc
def
ghi

using only select statement.

I know we can write a procedure to easily do this but i would like to know how it can be done using only select whether nested or inline.I tried using string functions but couldn't think of some logic to do it

Thanks
Nikhil

Thanks alot cumps.

Hi
Where does oracle store information about a particular table's columns and information about the column being a primary key??
Hope my query is clear.

Regards

Nikhil

Hi
I am using Apache POI to read from excel files,the problem i am facing is that when i store a contact number in a cell,i am unable to read it as a string and store it,if i try to convert it into string using the String.valueOf() method it converts into the proper scientific form.

Can anybody suggest a way to go around this???

Hi
I used the Apache POI to access excel files.The example file given at the location
POI example
It contains the following lines of code which are generating a error
HSSFRow row1 = sheet.getPhysicalRowAt(0);

The error generated is that the above method does not exist in the package
org.apache.poi.hssf.usermodel.HSSFSheet

i have imported all the classes mentioned in the program and followed everything that was required by setting classpath to the jar files downloaded from the Apache site.

How do i solve the above problem.

Thank you

Hi

I have deployed a JSP application on apache server.i have a heap memory limit of 96 mb. How can i optimize its use??any tips for it??

Thanks

1. whats the difference between scope=application and scope=session in the usebean tag??to what extent will the bean object be available in either cases??

2.i was asking about the session attribute in the page tag

<%@ page language="java" session="true" %>
what does session=true mean??

3. if i were to use the same bean for performing various operations in different jsp pages,when i create an object for it using usebean on every page,does it overload my webserver's heap memory??i am using the apache server with 96 mb as my heap memory limit.
is there any way of optimizing the heap memory usage??

Thanks

Hi
1.i wanted to know the use of the scope attribute in the usebean tag??

2. whats the use of session attribute in the page tag??how does it effect a jsp application??

Thanks

Hi

I recently developed an application using Servlets and JSP. The data for the application is supposed to be updated into Mysql through a batch file or excel file.how do i go about dumping data from excel to mysql using java or are there any tools available for it??

Regards

hello can ny1 please help me with the problem??

hello
i call a servlet from a jsp page in order for it to return me an image.everything was fine till i put in some way of recognising the user who is calling the servlet for the image, by reading a cookie already set in the jsp page when the user logs in.i use the following code to recognise the user

Cookie[] cookies = request.getKookies(); HttpSession session = request.getSession(true); boolean foundCookie = false; if(cookies != null) { for(int i = 0; i < cookies.length; i++) { Cookie cookie = cookies[i]; System.out.println("Checking cookies"); System.out.println((String)session.getAttribute("username")); System.out.println("cookie name "+cookie.getName()+" "+cookie.getValue()); if (cookie.getName().equals("user")&& cookie.getValue().equals((String)session.getAttribute("username"))) { foundCookie = true; break; }//end of if }//end of for }//end of if

intrestingly the servlet sets the session right and prints the username attribute right but doesnt get the cookies even though the system has cookies.
whats the problem??
[ June 25, 2008: Message edited by: Bear Bibeault ]

i was trying to get the image from the servlet using the include directive.i know pretty dumb when i should actually use the src variable in the image tag to make life easier sorry for bothering with such a simple thing

Regards
Nick

thanks i got the reply.that was very stupid of me not to try the image source in the first place
:p

sorry but i did not understand the reply.are you telling me that the request dispatcher need not be called and that i should give the servlets address as the location of the image???