tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ULS Tech Support <tech_supp...@uls.com>
Subject Re: Another issue, jTDS with Tomcat 5.5.9
Date Tue, 20 Oct 2009 18:02:59 GMT
Tell me how i hijacked my own thread?

This is my own thread.. and i actually modified the last one i sent out, 
cleared everything and typed out brand new.

Thanks for the help.



--------------------------------------------------
From: "Pid" <pid@pidster.com>
Sent: Tuesday, October 20, 2009 6:11 AM
To: <users@tomcat.apache.org>
Subject: Re: Another issue, jTDS with Tomcat 5.5.9

> On 16/10/2009 22:04, ULS Tech Support wrote:
>> Hi there,
>
> Please start a completely new email for each thread.  Replacing the
> subject line doesn't count, it's called thread hijacking.
>
> p
>
>
>> Tomcat 5.5.9, using jTDS, with SQL Server 2005 i am getting this issue.
>>
>> 2009/10/16 10:47:15 - sql exception:java.sql.SQLException: No current
>> row in the ResultSet.
>>
>> This issue doesn't happen with TWFreeTDS (in fact, when i switch to
>> twfreetds it works fine).. but from my research so far, i may have been
>> wrong in the way i implemented it.
>>
>> Here is the code.
>>
>> public Vector queryPaged4(String strTableExt) throws SQLException {
>> dbRecords.removeAllElements();
>> boolean rc = true;
>>
>> ResultSet rs_info = null;
>> boolean bTest = false;
>> DBItems temp = null;
>>
>> //New **********
>> /* This will call a stored procedure, pass in the page # and
>> number to display on each page and will return the results
>> directly.
>> */
>>
>> CallableStatement call = dbConn.prepareCall("{call sp_PagedItems4
>> (?,?,?,?,?)}");
>> call.setString(1, strTableExt);
>> call.setString(2, filter);
>> call.setString(3, order);
>> call.setInt(4, pageNumber);
>> call.setInt(5, recsPerPage);
>>
>> if (!call.execute())//Query
>> {
>> //No ResultSets Returned;
>> } else {
>>
>> try {
>> rs_info = call.getResultSet();
>>
>> //Save the total number of records (value) in queryPagedRecords
>> queryPagedRecords = rs_info.getInt("TotalRec");
>> queryPagedMore = rs_info.getInt("MoreRecords");
>> nLowestID = rs_info.getInt("FirstRec");
>> nHighestID = rs_info.getInt("LastRec");
>>
>> if (queryPagedRecords > 0) {
>> //Test for another resultset.
>> boolean bTest = false;
>> bTest = call.getMoreResults();
>> //Next resultset established, let's get the data!
>> dbResultSet = call.getResultSet();
>>
>> while (dbResultSet.next()) {
>> //System.out.println("2: " + dbResultSet.getInt("ID"));
>> rc = true;
>>
>> //Set the items object based on the resultset.
>> temp = this.setItemsObject(true, dbResultSet);
>>
>> dbRecords.addElement(temp);
>> }
>> }
>> } catch (SQLException e) {
>> System.out.println("SQLException: " + e);
>> System.out.println("SQLException Message: " + e.getMessage());
>> } finally {
>> rs_info = null;
>> temp = null;
>> dbResultSet = null;
>> }
>> System.out.println("end");
>> }
>>
>> return dbRecords;
>> }
>>
>> Basically i'm getting the resultsets, but i'm not able to pull the data
>> from the resultsets as i get the error when i try and getInt.
>>
>> Does anyone have any clue on why this is happening, or how i can make
>> this work?
>>
>> I did try and modify the code to the following to see if it helped, but
>> again, i'm still stumped on HOW to retrieve the data from the resultsets.
>>
>> try {
>> System.out.println("start...");
>> int updateCount = 0;
>> updateCount = call.getUpdateCount();
>> System.out.println("update count = " + updateCount);
>> boolean moreResults = true;
>> while (updateCount >= 0 || moreResults) {
>> if (!moreResults) {
>> // just eat it
>> updateCount = call.getUpdateCount();
>> System.out.println("\nupdateCount= " + updateCount);
>> } else {
>> // get the data
>> if (rs_info == null) {
>> rs_info = call.getResultSet();
>> } else {
>> dbResultSet = call.getResultSet();
>> }
>>
>> //Save the total number of records (value) in queryPagedRecords
>> System.out.println("Got Data, how to process??");
>> } // if ! moreResults else
>> moreResults = call.getMoreResults();
>> System.out.println("More Results??");
>> } // while
>>
>> //rs_info.setFetchSize();
>> System.out.println("Lets get data from rs_info");
>> queryPagedRecords = rs_info.getInt("TotalRec");
>> queryPagedMore = rs_info.getInt("MoreRecords");
>> nLowestID = rs_info.getInt("FirstRec");
>> nHighestID = rs_info.getInt("LastRec");
>>
>> But it stops at the "queryPagedRecords = rs_info.getInt("TotalRec");"
>>
>> Thanks in advance to anyone who can help.
>>
>> ...Robin
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message