18 messages in com.mysql.lists.javaRE: driver problem
FromSent OnAttachments
Jeff Mathis22 Jul 2003 15:25 
Jeff Mathis22 Jul 2003 15:35 
Mark Matthews22 Jul 2003 17:45 
Rakesh Ayilliath23 Jul 2003 06:01 
Shapiro, David23 Jul 2003 06:14 
Jeff Mathis23 Jul 2003 08:24 
Rakesh Ayilliath23 Jul 2003 08:25 
Christopher Taylor23 Jul 2003 18:44 
Jeff Mathis24 Jul 2003 08:20 
Jeff Mathis24 Jul 2003 12:43 
Jeff Mathis24 Jul 2003 13:25 
Mark Matthews24 Jul 2003 14:05 
Christopher Taylor24 Jul 2003 17:38 
Jeff Mathis25 Jul 2003 08:41 
Jeff Mathis25 Jul 2003 15:06 
Jeff Mathis25 Jul 2003 15:12 
Christopher Taylor25 Jul 2003 19:34 
Jeff Mathis28 Jul 2003 07:51 
Subject:RE: driver problem
From:Rakesh Ayilliath (ayil@hotmail.com)
Date:07/23/2003 08:25:19 AM
List:com.mysql.lists.java

I did that... no other errors. well the whole thing just works fine on the older driver...

-------Original Message-------

From: Shapiro, David Date: Wednesday, July 23, 2003 06:49:54 PM To: 'Rakesh Ayilliath'; ja@lists.mysql.com Subject: RE: driver problem

It was not open probably because of some kind of error. Do a catch around it to get the error.

-----Original Message----- From: Rakesh Ayilliath [mailto:ayil@hotmail.com] Sent: Wednesday, July 23, 2003 9:02 AM To: ja@lists.mysql.com Subject: driver problem

Hi,

I have a java based application thats using mm.mysql-2.0.6.jar. Just happened to change the driver (and driver settings) to mysql-connector-java-3.0.8-stable

I get the following error :

java.sql.SQLException: Operation not allowed after ResultSet closed

for the statements :

st = myConnection.createStatement(); rs = st.executeQuery(s); rs.last(); count = rs.getRow(); custDetails= new String[count+1][12]; rs.beforeFirst(); while(rs.next()) { custDetails[i][0] = rs.getString("CustName"); custDetails[i][1] = rs.getString("CustCode"); custDetails[i][2] = rs.getString("CustCity"); custDetails[i][3] = rs.getString("CustState"); custDetails[i][4] = rs.getString("CustPhoneHome"); custDetails[i][5] = rs.getString("MhspNumber"); custDetails[i][6] = rs.getString("PolicyNo"); custDetails[i][7] = rs.getString("age"); custDetails[i][8] = rs.getString("PolicyName"); custDetails[i][9] = rs.getString("ProposalKey"); custDetails[i][10] = checkCancelledCases(custDetails[i][5]); i++; }

the same code is executing fine with mm.mysql-2.0.6.jar

The first iteration of the for loop happens without problems. Exception is thrown after the i++;

kindly help.

regards Rakesh Ayilliath

____________________________________________________ <http://www.incredimail.com/redir.asp?ad_id=309&lang=9> IncrediMail - Email has finally evolved - <http://www.incredimail.com/redir.asp?ad_id=309&lang=9> Click Here