hkpaul
asked on
SQL server JDBC driver don't support resultset.last()?
Hello everyone,
HELP! HELP!
I connect SQLServer via ms jdbc driver. In my jsp application, i want to perform paging.
But, it is don't support resultset.last()?
When i try this, there is an exception. How can I solve the problem?
Paul
HELP! HELP!
I connect SQLServer via ms jdbc driver. In my jsp application, i want to perform paging.
But, it is don't support resultset.last()?
When i try this, there is an exception. How can I solve the problem?
Paul
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
also my configuration is:
tomcat, SQL Server 2000
and i put [msutil.jar, mssqlserver.jar, and msbase.jar] at
tomcat/common/lib
tomcat, SQL Server 2000
and i put [msutil.jar, mssqlserver.jar, and msbase.jar] at
tomcat/common/lib
Can you show me the code where you decleare resultset and where you actually call ResultSet.last?
Thanks
Brett
Thanks
Brett
ASKER
Thank you, I think i know what happen :)
ASKER
My driver version is
MS SQL Server 2000 Driver for JDBC - Service Pack 1
and i also tried to create a scrollable resultset
it still get the exception....
javax.servlet.ServletExcep
at org.apache.jasper.runtime.
at org.apache.jsp.ad_0005fupd
...........