Mani Balasubramanian

Greenhorn
+ Follow
since Jan 03, 2002
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
In last 30 days
0
Forums and Threads

Recent posts by Mani Balasubramanian

Hi,
We have a procedure in which a parameter is of type NUMBER.
There are 2 applications using this procedure, the first application uses websphere and the second one uses iPlanet.
The websphere application that binds a integer to this paramenter.
The second application binds an string to the third parameter.
Due to this we are often getting "ORA-06502: PL/SQL: numeric or value error: character to numbe
r conversion error"
I am in a position to give a temporary solution, till the code is fixed.
Can clearing the share pool fix the problem or we need to do something more than that?
Thanks,
Mani
We are expiercing a TEMP tablespace full.
The TEMP tablespace sizing is normally big enough (4 GB) to handle day to day operation. Due to the usage of LOB data in our application the TEMP tablespace usage becomes a problem. Do we have to do anything from the programming side to reduce the size or do we have to set some parameters in database to take care of this.
Thanks in advance
21 years ago
I have task which involves storing and retrieving of blob images into Oracle database.i have initialised the blob column with empty_blob().
but i get error while trying to get the locator of this blob column. how to solve this please help me out
Thanks Peter,
My case is the second one, where the users log into network and access the site. The browser is also Internet Explorer. Do I need to go for JAAS in that case?
Can you explain how the NTLM authentication is done in case of IE-NT combination.
Thanks,
Mani
22 years ago
Can we do network authentication in JSP. For example, while accessing a webpage it should pop-up a standard NT authentication dialog.
If we can do the authentication, which application server supports this?
Thanks,
Mani
22 years ago
Hi,
Is there any provision in javamail to login as superuser or mailserver admin and retrieve mails for other users.
Thanks,
Mani
22 years ago
Hi,
Just to add that we are trying to Compress the output using filters and it works fine with servlet. But with JSP we are unable to Compress the response becasue we are not able to wrap the
response.
The problem with below code is that responseString is always returning empty for JSP but returning the content for servlet. By the way we are running it on Oracle9ias.
----------------
public class CharArrayWrapper extends HttpServletResponseWrapper
{
private CharArrayWriter charWriter;

public CharArrayWrapper(HttpServletResponse response)
{
super(response);
charWriter = new CharArrayWriter();
}

public PrintWriter getWriter()
{
return(new PrintWriter(charWriter));
}

public String toString()
{
return(charWriter.toString());
}

public char[] toCharArray()
{
return(charWriter.toCharArray());
}
}

public void doFilter(ServletRequest request,ServletResponse response,FilterChain chain) throws ServletException, IOException
{
HttpServletRequest req = (HttpServletRequest)request;
HttpServletResponse res = (HttpServletResponse)response;
if (!isGzipSupported(req))
{
chain.doFilter(req,res);
}
else
{
System.out.println("GZIP supported");
// Tell browser we are sending it gzipped data.
res.setHeader("Content-Encoding", "gzip");

// Invoke resource, accumulating output in the wrapper.
CharArrayWrapper responseWrapper =new CharArrayWrapper(res);
chain.doFilter(req,responseWrapper);

// Get character array representing output.
char[] responseChars = responseWrapper.toCharArray();
String responseString = responseWrapper.toString();
System.out.println("Response String..."+responseString);
// Make a writer that compresses data and puts
// it into a byte array.
ByteArrayOutputStream byteStream =new ByteArrayOutputStream();
GZIPOutputStream zipOut = new GZIPOutputStream(byteStream);
OutputStreamWriter tempOut = new OutputStreamWriter(zipOut);
// Compress original output and put it into byte array.
tempOut.write(responseChars);

// Gzip streams must be explicitly closed.
tempOut.close();

// Update the Content-Length header.
res.setContentLength(byteStream.size());
// Send compressed result to client.
OutputStream realOut = res.getOutputStream();
byteStream.writeTo(realOut);
}
}
----------
Thanks
Srinath
22 years ago
Hi,
Can anyone tell me how to get read the content of the response into a String (or any array objects)
I am sure this can be done using HttpServletResponseWrapper.
Thanks,
Mani
[ May 28, 2002: Message edited by: Mani Balasubramani ]
22 years ago
Interstingly I too have this session problem. I have a HTML frame contains 2 JSPs. When I access session values from both the pages, its throwing LockTimedOutException.
I think it has something to do with session synchronization.
22 years ago
Does the JS file downloads everytime into the clients machine when the IE setting is set to "Every visit to the page"?
Hi,
In our application, we have to perform lot of checks in the database.
Right now we are doing these thru' stored procedure (One procedure per check). These procudures returns the status of the check(true or false) as well as the data that are failed during the check. The data is returned in the form of OracleTypes.CURSOR (ResultSet).
In JSP, if the a check fails, we are putting the callablestatement in the session.
In another page we take the callablestatement from the session, execute it and traverse the resultset to display the datas that are failed during the check.
In this process, some records are getting locked (intermittent). We cant able to simulate a particular scenario where this is happening. Eventhough it is happening very rarely, it is a very serious problem for us.
Any clue or suggestion please...
Thanks,
Mani
Have you tried this
Jsp variable in javascript:
<script language="javascript">
var javascriptVar = "<%=jspVar%>";
</script>
The otherway round is not possibile directly. Either you have to pass the javascript variable as a url to another jsp page or submit the page to another jsp page with javascript variable as a hidden field.
23 years ago
JSP
I think the singleton obj doesn't solve the problem either, because when u need to cache the preparedstmt u also need to cache the corresponding connection object in the singleton object, ur thoughts on this please

Originally posted by David O'Meara:
Depending on the database you use and its support for PreparedStatements, yes, it should prevent the database from having to continually having to compile the statement.
There is a short article from TheServerSide here
Dave.



Thanks for your reply. I am using Oracle 8i. In my case, i am not calling the same query many times in a JSP page. But I am reloading the entire JSP page, which means that i am once again creating another instance of preparedStatement object. Is there any way to avoid this?
Thanks again.
Hi,
I have a jsp page in which i am fetching some data from the database and showing it on the screen. The page gets reloaded every 5 mins. I am using stmt.executeQuery() to fetch the datas. So, every time the page is reloaded, the query has to be executed in the backend.
Is there any way to cache a Statement object and reuse it again (without compiling the query again in database)?
Will the use of preparedStatement solve the problem?