Craig,
I completely agree with you . I suggest that each person be as responsible
like a list administrator and take up responsibility to limit ourselves to
the API which is supposed to be discussed . I am glad that you voiced an
opinion of the majority .
looking forward to a more productive discussion .
mayur shetye
----- Original Message -----
From: T A Flores <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 11:23 PM
Subject: Re: I am sorry.. for posting into this grrop.
> 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 {
> >
> >
> >
> > file://rs.moveToInsertRow();
> > file://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
> >
> > file://rs.insertRow();
> > file://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, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
