Pagination problem: ask in jdbc for sqlserver2000 does not support the case of secondary rollback how to implement paging? Find the code, thank you.

Category: Java SE
 
kdwjh0287
2011-08-31 01:57:25

Sponsored Links
My brother software configuration:
sql server 2000
jdbc for sql server 2000 (sp3)
tomcat 5.0
paging code I wrote when the first run rs.last (); running rs.beforfist ()
found error: jdbc for sql server 2000 does not support rs.beforfist (), the cursor is not supported rollback.
cursor to ask how to avoid secondary rollback in case of implement paging it?
demand paging detailed code, thank you!

Sponsored Links

aa3999169
2011-08-31 02:02:27
call a stored procedure in the process inside paging. . .
luolula
2011-08-31 02:11:57
My software configuration:
sql server 2000
jdbc for sql server 2000 (sp3)
tomcat 5.0
I wrote paging code, first run rs.last (); running rs.beforfist ()
found error: jdbc for sql server 2000 does not support rs.beforfist () , indicating that the cursor does not support rollback.
cursor to ask how to avoid secondary rollback in case of implement paging it?
demand paging detailed code, thank you!
mbnlfj
2011-08-31 02:14:18
My software configuration:
sql server 2000
jdbc for sql server 2000 (sp3)
tomcat 5.0
paging code I wrote when first run rs.last (); running rs.beforfist ()
found error: jdbc for sql server 2000 does not support rs . beforfist (), rollback cursor is not supported.
cursor to ask how to avoid secondary rollback in case of implement paging it?
demand paging detailed code, thank you!

zhang40789
2011-08-31 02:32:33
another jdbc drivers using jtds better, the driver does not support Microsoft's second readback!
dxtkwj
2011-08-31 02:37:15
jtds or hibernate
cinderellafan
2011-08-31 02:46:03
Hibernate config with jtds jdbc driver.
goog5y9ol
2011-08-31 02:58:44
Consult jdbc for sqlserver2000 does not support secondary return roll case how to implement paging? Find the code, thank you.
Domain and server ip had changed since 8/23/2013. Suspend the user registration and posts for program maintenance.