Hello to everybody I ' need some help with the microsoft jdbc driver for MSSQL 2000
In a web application using dbforms_1.1.4pr2_2031114 i generate the edit and list pages by devgui I have some problems with SQL Server 2000 Driver for JDBC when i access to the edit page (generate by devgui). The Edit page try to get the record from a table with text (blob) data type from a SQLServer2000. The exact error is : ERROR [ApplicationServerThread] (DataSource.java:422) - java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1. This is what a i'have known from the microsoft support a the address http://support.microsoft.com/default.aspx?kbid=824106 -------------------------------------------- SYMPTOMS You have a Java application that uses JDBC to retrieve a ResultSet object by using the Microsoft SQL Server 2000 Driver for JDBC. When you try to read a column in the ResultSet, you may receive the following error message: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1. Note In this error message, the words "can not" are a misspelling for the word "cannot." The column number that the error message refers to is dependent on the schema of your ResultSet object. CAUSE This error occurs with ResultSet objects that contain a BLOB column (for example, text, ntext, or image data types). The driver cannot return a BLOB column out of order because it does not cache all the content of BLOB data types because of size limitations. For any row in the ResultSet, you can read any column from left to right, and each column should be read only one time. If you try to read columns out of order, or if you re-read a column from the ResultSet, you may receive the error message that the "Symptoms" section describes. To prevent the problem, read the ResultSet columns in order. ... ... ------------------------------------------- I'm not able to modify the dbforms java source , does anyone knows any work around or patch to resolve this problem ? Thank you for any suggestions to averybody Andrea Gallato ecommerce.it s.r.l. Galleria Spagna,28 - 35127 Padova tel. 049760475 fax 0498701549 [EMAIL PROTECTED] ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
