Malla Reddy,
Not only is this an inappropriate question for this and the Servlet
list but it has been asked, answered, and reposted to the on the JSP
list just with a different email address.
At the risk of starting another flame fest on both the JSP and Servlet
interest list over questions like this and the effort of the asker in
solving their problem I am sending one of the only positive things that
did come to life in the feeding frenzy. A previous post from one of
the engineers from Sun on inappropriate/off-topics questions I have
pasted the quote. I thank the person who originally brought this post
back out into the open.
<Quote>
Let me make it very clear why asking (and answering) off-topic
questions is counterproductive.
As anyone who recognizes my name will tell you, I'm one of the folks
who knows quite a bit about servlets :-). Coupled with that, my
personality drives me to want to share what I know, and to help
people. Over the last few years, I have answered hundreds (maybe even
thousands?) of such questions.
But (there is always a but ...) my time available to do this is limited.
At the moment, I have more than 250 messages (just from the last two
days) in my SERVLET-INTEREST folder that I haven't read yet. Usually,
I do that while waiting for compiles, or having my first morning
coffee, or whatnot. However, a quick scan of the message headers says
that well over 50% of these messages are off topic. Even though I know
the answers to most of the questions about JDBC drivers and such, that
is not why I'm here -- I want to share what I know about building web
apps with servlet and JSP technology.
As a result, over the last few months, and as the percentage of off
topic questions and answers has dramatically increased, I spend less
and less time on SERVLET-INTEREST. It simply takes too much time to
scan and ignore the off-topic stuff, so I don't even have time to
notice the questions that can and should be answered.
This is not what I want. This should not be what you want either.
The way to avoid that is to be polite to the folks like me, who *want*
to answer relevant questions. And that politeness revolves around
respecting the rules of the community in which we are participating
here. Both asking, and answering, off topic questions violates that
principle of respect, and discourages high quality exchanges about the
single topic we all want to talk about, or we wouldn't have joined in
the first place.
Thanks for letting me pontificate a little, although I had to violate a
personal policy (to never respond to an off-topic post) to do it :-).
Craig McClanahan
</Quote>
----- Original Message -----
From: malla reddy choodi <[EMAIL PROTECTED]>
Date: Wednesday, January 10, 2001 8:23 am
Subject: I am sorry.. for posting into this grrop.
> Hi,
>
> I am working on upload into and download from database. I am using
> jspsmartupload api.
>
> Please help me any one worked on this api.. I am getting an error like
>
> An error occurs : java.sql.SQLException: Internal Error: Unable to
> constructa Datum from the specified input 0 file(s) uploaded in
> the database
>
>
> When the file size is less then 4KB.. and I am getting an error
> like this
> when the file size is grater then 4KB I am getting an error like
> this..
> An error occurs : java.sql.SQLException: ORA-01008: not all
> variables bound
>
>
>
>
> When I was trying to insert a row into database by using result
> set by using
>
> rs.moveToInsertRow();
> rs.insertRow();
> I am getting another error like
>
>
> java.sql.SQLException: Io exception: Connection reset by peer:
> JVM_recv in
> socke
> t input stream read
> at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
> at
> oracle.jdbc.driver.OracleResultSetImpl.internal_close(OracleResultSet
> Impl.java)
> at
> oracle.jdbc.driver.OracleResultSetImpl.close(OracleResultSetImpl.java
> )
> at
> oracle.jdbc.driver.ScrollableResultSet.close(ScrollableResultSet.java
> )
> at
> oracle.jdbc.driver.UpdatableResultSet.close(UpdatableResultSet.java)
> at
> examples.jsp.smart.sample4_jsp_1._jspService(sample4_jsp_1.java:166)
> at
> com.sun.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
> at
> com.sun.jsp.runtime.JspServlet$JspServletWrapper.service(JspServlet.j
> ava:88)
> at
> com.sun.jsp.runtime.JspServlet.serviceJspFile(JspServlet.java:218)
> at com.sun.jsp.runtime.JspServlet.service(JspServlet.java:294)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
> at
> com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:155
> )
> at com.sun.web.core.Context.handleRequest(Context.java:414)
> at
> com.sun.web.server.ConnectionHandler.run(ConnectionHandler.java:139)
> HANDLER THREAD PROBLEM: java.io.IOException: Socket Closed
> java.io.IOException: Socket Closed
> at java.net.PlainSocketImpl.getInputStream(Unknown Source)
> at java.net.Socket$1.run(Unknown Source)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.Socket.getInputStream(Unknown Source)
> at
> com.sun.web.server.ConnectionHandler.run(ConnectionHandler.java:161)
>
>
>
> Here is the code..
>
>
>
> ResultSet rs = stmt.executeQuery("SELECT Ta.* FROM
> MP1.TBL_UPLOAD Ta where
> ID =1");
>
>
> // if the resultset is not null
> if (rs.next()){
>
> // Initialization
> mySmartUpload.initialize(pageContext);
>
> // Upload
> mySmartUpload.upload();
>
> // upload file in the DB if this file is not missing
> if (!mySmartUpload.getFiles().getFile(0).isMissing()){
>
> try {
>
>
>
> //rs.moveToInsertRow();
> //rs.updateInt("ID",2);
>
> rs.updateString("FILENAME",
> mySmartUpload.getFiles().getFile(0).getFileName());
>
> // Add the current file in the DB
> field
>
> System.out.println("I am before
> update Row()" +
> mySmartUpload.getFiles().getFile(0).getFileName());
>
>
> mySmartUpload.getFiles().getFile(0).fileToField(rs,"ATTACHMENT");
> System.out.println("I am before
> update Row()");
>
>
> // Update
>
> //rs.insertRow();
> //rs.first();
>
> rs.updateRow();
>
>
> count++;
>
> } catch(Exception e) {
> out.println("An error occurs : " +
> e.toString()); }
>
> }
>
> }
>
> // Display the number of files uploaded
> out.println(count + " file(s) uploaded in the database.");
>
> rs.close();
> stmt.close();
> con.close();
>
>
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
========================================================================
===
> To unsubscribe, send email to [EMAIL PROTECTED] and include in
> the body
> of the message "signoff RMI-USERS". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
> For a list of frequently asked RMI questions please refer to:
> http://java.sun.com/products/jdk/rmi/faq.html
>
> To view past RMI-USERS postings, please see:
> http:
>
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
