You can try to remove your blob field from your table. Dbforms is reading the columns twice - so this error can occur. The jdbc definitions allows to read the columns as often as you need - only MS seems to need a extra way.....
Somebody could change dbforms to read each row only once.... Cheers Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von [EMAIL PROTECTED] > Gesendet: Dienstag, 25. Mai 2004 18:00 > An: [EMAIL PROTECTED] > Betreff: [dbforms] SQLServer 2000 Driver for JDBC ResultSet > can not re-read row data for column > > 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 > ------------------------------------------------------- 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_id149&alloc_id66&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
