I don't know if this could impact and if it's the same in your code but didn't you
forget a ')' in your query :
pSql = "INSERT INTO tbl_qa_errors (project_id, reported_by,error_type, is_urgent,
error_title, notes) values (?,?,?,?,?,?)";
>>> <<<
Walt Meyer a écrit :
> I don't see anything wrong with what you have. I'm doing something similar
> against an Oracle database and not having any problems. Maybe something SQL
> server is doing?
>
> Walt
>
> -----Original Message-----
> From: Neal Cabage [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 25, 2000 2:42 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Values not trimming - writing to DB
>
> Thanks for taking a look. Here's basically what I am doing. This is a
> method of a bean I am using. I have determined (by testing) that the values
> are still without trailing spaces once fed into the method. It seems to be
> something that happens after arriving in the method and during/after writing
> to the dB. The odd thing is ... that even if something funky was going on
> ... I presumed that my varChar dataType in SQL server would automatically
> prevent this from happening.
>
> Well, I have found a way if living with this I suppose (simply trimming
> every value on the way out of the db) but I would *really* like to know the
> solution if you have any thought.
>
> Thanks in advance!
>
> Neal
>
> public void addError(int projId, String reporter, String type, int
> urgent,
> String title, String notes) {
> // Add a new error to the database
> try{
>
> pSql = "INSERT INTO tbl_qa_errors (project_id,
> reported_by,
> error_type, is_urgent, error_title, notes values (?,?,?,?,?,?)";
> PreparedStatement pst = cn.prepareStatement(pSql);
> pst.setInt(1,projId);
> pst.setString(2,reporter.trim());
> pst.setString(3,type.trim());
> pst.setInt(4,urgent);
> pst.setString(5,title.trim());
> pst.setString(6,notes.trim());
> pst.execute();
>
> }catch (Exception
> {
> System.err.println(ex);
> }
>
> }
>
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Walt Meyer
> Sent: Friday, August 25, 2000 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JSP-INTEREST] Values not trimming - writing to DB
>
> Are you doing this
>
> String string1 = somevariable;
> String string2 = someothervariable;
>
> string1.trim();
> string2.trim();
>
> and then using string1 and string2 in the prepared statement?
>
> Walt
>
> -----Original Message-----
> From: Neal Cabage [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 25, 2000 8:13 AM
> To: [EMAIL PROTECTED]
> Subject: Values not trimming - writing to DB
>
> I am setting values into my dB (SQL server) and using a prepared statement
> to do so. I simply put in the values from my form and that should be that.
> The values (once in the dB) however have a ton of empty spaces at the end of
> the values however, up to the full length of the dB field.
>
> Here's the source of my confusion:
> 1. The dataTypes in SQLServer are set to VarChar, not char.
> 2. I am using the .trim() method on each string prior to setting it in the
> prepared statement
> 3. I just rolled the code that does the dB insert into a bean - but the
> identical code within my JSP didn't give me thatproblem.
>
> Does anyone why this would be or how I could get around it?
>
> Thanks.
> Neal
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> 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
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> 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
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> 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
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> 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
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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