Hi,
I've also had some unaccountable SQL truncation errors with
JDBC-ODBC-SQL Server, but without the termination.
I don't quite get why you've got the ..."+passwd+"... in there -
couldn't this go in as another ? ?
Cheers,
Danny.
> qian jianhua wrote:
>
> Sorry, my following code throws some SQLException that I can't
> understand. I wonder who can help me.
> Thank you.
>
> The codes are:
> String query1= "update customer set
> customer_passwd='"+passwd+"',customer_comm='"
> +comm_method+"',customer_pwq=?,customer_pwa=? where
> customer_num="
> +num;
> PreparedStatement stmt1=con.prepareStatement(query1);
> stmt1.setString(1,pwd_question);
> stmt1.setString(2,pwd_answer);
> int n1=stmt1.executeUpdate();
>
> The SQLExceptions are:
> SQLException:22001 [Microsoft][ODBC SQL Server Driver][SQL
> Server]String or binary data would be truncated. 8152
> SQLException:01000 [Microsoft][ODBC SQL Server Driver][SQL Server]The
> statement has been terminated. 3621
>
> Qian.
> 1999.5.5
--
Intermittent Web site :
http://members.xoom.com/dayers/_XOOM/dayers/index.html
Alternate email :
[EMAIL PROTECTED]
___________________________________________________________________________
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
