I'm getting the following error when doing a select statement in my servlet: Tue Jun 29 14:13:25 CDT 1999: WMSServlet: *** SQLException caught *** in select Tue Jun 29 14:13:25 CDT 1999: WMSServlet: SQLState: null Tue Jun 29 14:13:25 CDT 1999: WMSServlet: Message: Protocol violation Tue Jun 29 14:13:25 CDT 1999: WMSServlet: Vendor: 0 The select statement is: select * from wms where work_id >= 49 and work_id <= 49 It appears that there is some invalid data in one of the fields which affects this as I can change the data and everything is fine. Has anyone seen anything like this using JDBC and the Oracle Type 4 thin driver? We use classes111.zip and it is running Oracle 7.3.4. The bad data appears to be a combination of some sort of carriage returns with the possibility of the # indicator in there. If I eliminate the # indicator, it works (It's before a number at the end like #30.) Put the # back at the beginning and it just sits there and spins without any error. Take it out, it works. Put it in other rows, it works (there are actually other ones there and they work). I can remove the carriage returns, and # signs are OK. The carriage returns are put in by entering information into a textarea box on an html form which automatically wraps (Netscape 4.06). By the way, I was using a connection pool and it seems to tie things up to the point of eventually not working. Once this occurs, I can go through about 40 rows and then it just sits there. Even without a connection pool, this thing will sometimes just sit there. Is there anything anyone can think of that causes this? I can't imagine not being able to process any kind of data in a column. By the way, the data is in a varchar2(500) column. Thanks, Gary ___________________________________________________________________________ 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
