SJC2 & MSSQL 2005 : pagesize()
Hi all,
In the editor I am just creating a dataprovider on a database table and a jsp page with a table to display the data (just drag/drop).
It works!
So if I modify the default 0 value of property Pagesize of the CachedRowset, I recieve the following error message when this same page is running:
Exception Details: org.apache.jasper.JasperException
com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
Possible Source of Error:
Class Name: org.apache.jasper.servlet.JspServletWrapper
File Name: JspServletWrapper.java
Method Name: service
Line Number: 384
I am using the latest Microsoft JDBC driver : jdbc:sqlserver://localhost:1433;DatabaseName=xxx;selectMethod=cursor;
Regarding the error message, I try to change the concurency/ type values
but it gives the same error.
Any idea is welcome.
Thank you
Message was edited by:
dzafer
Message was edited by:
dzafer
