websphere 5.1 Jtds jdbc driver issue
Can some one suggest the possible solution to this issue.
I am trying to use Jtds 1.2 jdbc driver to connect to Sqlserver 2000 from the websphere 5.1 app server ( actually test server environment from WSAD 5.1.2) and I am getting the SQLException as follows "The requested size is greater than the maximum number of rows" . We have the same Jtds driver running fine on JBoss app server for the same application. So I am guessing it must be some configuration that I am missing in websphere that I could nt able to figure out. Appreciate if some one can direct me.
The run time error....
[7/3/06 11:34:47:297 CDT] 7c2fe6bb WebGroup I SRVE0181I: [Form Action Servlet] [ARJ] [Servlet.LOG]: java.sql.SQLException: java.sql.SQLException: The requested fetch size is greater than the maximum number of rows.
at net.sourceforge.jtds.jdbc.JtdsStatement.setFetchSize(JtdsStatement.java:956)
at net.sourceforge.jtds.jdbcx.proxy.StatementProxy.setFetchSize(StatementProxy.java:393)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.enforceStatementProperties(WSJdbcStatement.java:290)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:443)
at com.actek.j2ee.common.sessionbean.QuerySessionBean.processQueryParm(QuerySessionBean.java:140)
...........................
and the concised SQL query, app error are as follows...
SELECT TOP 101 P.CreditTrnNo, P.CreditType, P.CustomerNo, P.Reviewed, P.NextReviewDate, P.DateComp .......... FROM CreditTrn P LEFT OUTER JOIN Customer Customer_CreditTrn ON P.CustomerNo = Customer_CreditTrn.CustomerNo LEFT OUTER JOIN Dealer Dealer_CreditTrn ON P.DealerNo = Dealer_CreditTrn.DealerNo LEFT OUTER JOIN UsrSet UsrSet_CreditTrn ON P.ChkUserNo = UsrSet_CreditTrn.UserNo WHERE Customer_CreditTrn.CustomerId = '013108' ORDER BY P.SalePend DESC, P.CompReq DESC, P.TrnType, P.FstDate, P.FstTime
java.sql.SQLException: The requested fetch size is greater than the maximum number of rows.
at net.sourceforge.jtds.jdbc.JtdsStatement.setFetchSize(JtdsStatement.java:956)
at net.sourceforge.jtds.jdbcx.proxy.StatementProxy.setFetchSize(StatementProxy.java:393)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.enforceStatementProperties(WSJdbcStatement.java:290)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:443)