If the lastname is the column after firstname in table created, the
above statement will throw the following exception:
Exception java.sql.SQLException: [Microsoft][SQLServer JDBC
Driver]ResultSet can not re-read row data for column 5.
Column 5 is <firstname>. With other JDBC drivers, the above problem does
not occur. Just wondering if there is any workaround or must I declare the
assignments accordingly?
Best Regards,
Roy Tan
The above error happens if you attempt to re-read a ResultSet column or read
a column less then the last column read.
This can be over come if you use
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDA
TABLE)
instead of the default createStatement(). The reason is that that default
generates TYPE_FORWARD_ONLY ResultSets.
"Roy Tan" <roy...@hotmail.com> wrote in message
news:unA43MI0BHA.1584@tkmsftngp04...
Sridhar Paladugu
Microsoft Developer Support
JDBC Webdata
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order
your FREE Security Tool Kit, please visit
<http://www.microsoft.com/security>.
-----
Christophe GOGUYER DESSAGNES
Product Manager
Arcad Software
Mail : mailto:c...@arcadsoftware.com
ICQ : 16336625
Web : http://www.arcadsoftware.com
"Sridhar Paladugu[MS]" <sr...@online.microsoft.com> a écrit dans le message
de news: n#m1w9P1BHA.1752@cpmsftngxa07...
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
--
-----
Christophe GOGUYER DESSAGNES
Product Manager
Arcad Software
Mail : mailto:c...@arcadsoftware.com
ICQ : 16336625
Web : http://www.arcadsoftware.com
"Neil Pike" <neil...@compuserve.com> a écrit dans le message de news:
VA.00005c7...@compuserve.com...
The problem will be with data types such as IMAGE or any long datatypes. What
happens here is if you are using any data types which contains long data the
driver opens pointer to that buffer instead of storing that data in the local
buffer. So If your SELECT list contains any long data columns(text, ntext,
image) then you will not be able to reread data in the resultset based on the
current driver implementation. So the simple work around is to process the
result in order or to avoid longdata columns when you do not want them in
current logic.
I hope this might help you.
Regards,
--
-----
Christophe GOGUYER DESSAGNES
Product Manager
Arcad Software
Mail : mailto:c...@arcadsoftware.com
ICQ : 16336625
Web : http://www.arcadsoftware.com
"Sridhar Paladugu[MS]" <sr...@online.microsoft.com> a écrit dans le message
de news: wKuudyd9BHA.2252@cpmsftngxa08...
This behaviour change might change some time later. But for now we do not have
any plans to change this behaviour.
Thanks,
Thx.
--
-----
Christophe GOGUYER DESSAGNES
Product Manager
Arcad Software
Mail : mailto:c...@arcadsoftware.com
ICQ : 16336625
Web : http://www.arcadsoftware.com
"Sridhar Paladugu[MS]" <sr...@online.microsoft.com> a écrit dans le message
de news: TDOU7Iq9BHA.1764@cpmsftngxa07...