Exception : ResultSet is closed

[Naresh Talluri]

Hi folks
I have a problem while closing the ResultSet in JDBC.
iam using Postgre DB, here for normal execution it is working fine,
but while we are doing load test at the rate of 30 or 40 hits to the
application on a peak volume it is throwing the error like
"PSQLException:This ResultSet is closed."
can you please let me know what are all the possibilities....
here is my DB releasing code..

if (pConnection != null) {
                pConnection.close();
                pConnection = null;
     
       if (pStatement != null) {
                pStatement.close();
                pStatement = null;
 
       if(pResultSet != null) {
                pResultSet.close();
                pResultSet = null;

All these statements are enclosed in try/catch block...


I really appreciate for any thoughts...

--Naresh

[Herman Schelti]

hi,

change resultset first, then statement, then connection.

Herman

[Naresh Talluri]

Hi
in my code i had put like that only , but while posting
i copy pasted like that...sorry for that one..
No one resource is sharing my application.
but in the normal condition it is working fine but in the peak volume only it is getting trouble...
getDirectoryContents() is the method iam going to call.
the code shown below:

 public Vector getDirectoryContents(String pDirectoryId)throws BusinessException{
Connection lConn = null;
Statement lStatement = null;
ResultSet lResultSet = null;
String lSql = "";
String lEntyId ="";
Vector lDirectoryContactViewList =new Vector();
Vector lColumnViewList =null;
lSql ="select entryid from directorymanagementsystem.entries where directoryid='"+pDirectoryId+"'";
mLogger.info(new StringBuffer("Printing sql from getDirectoryContents").append(lSql));
try {
System.out.println("inside 1");
lConn = DBAccess.getConnection();
lStatement = lConn.createStatement();
lResultSet = lStatement.executeQuery(lSql);
while(lResultSet.next()){ 
System.out.println("inside 2");
lEntyId = lResultSet.getString("entryid");
lColumnViewList = getColumns(lEntyId);
DirectoryContactView lDirectoryContact = new DirectoryContactView();
lDirectoryContact.setDirectoryId(pDirectoryId);
lDirectoryContact.setEntryId(lEntyId);
lDirectoryContact.setColumnView(lColumnViewList);
 
lDirectoryContactViewList.add(lDirectoryContact);
}
}catch(SQLException e){
System.out.println("inside 3");
mLogger.info(new StringBuffer(e.getMessage()));
throw new BusinessException(e.toString(), e.getStackTrace());
}finally{
System.out.println("inside 4");
DBAccess.closeResultSet(lResultSet);
DBAccess.closeStatement(lStatement);
DBAccess.closeDBConnection(lConn);
}
 
return lDirectoryContactViewList;
}
 
 
public Vector getColumns(String pEntyId)throws BusinessException{
Connection lConn = null;
Statement lStatement = null;
ResultSet lResultSet = null;
Vector lColumnViewList =new Vector();
String lSql = "";
lSql = "select * from directorymanagementsystem.getcolumnvalues('"+pEntyId+"')";
mLogger.info(new StringBuffer("In function getColumns entryid is ").append(pEntyId));
mLogger.info(new StringBuffer("Printing sql from getColumns ").append(lSql));
try {
lConn = DBAccess.getConnection();
lStatement = lConn.createStatement();
lResultSet = lStatement.executeQuery(lSql);
while(lResultSet.next()){
ColumnView lcolumn = new ColumnView();
lcolumn.setColumnId(lResultSet.getString("columnid"));
lcolumn.setTitle(lResultSet.getString("title"));
lcolumn.setDialable(lResultSet.getBoolean("dialable"));
lcolumn.setFetchable(lResultSet.getBoolean("fetchable"));
lcolumn.setColumnTypeId(lResultSet.getString("columntypeid"));
lcolumn.setValidatorClass(lResultSet.getString("validatorclass"));
lcolumn.setColumnValue(lResultSet.getString("columnvalue"));
 
lColumnViewList.add(lcolumn);
}
}catch(SQLException e){
mLogger.info(new StringBuffer(e.getMessage()));
throw new BusinessException(e.toString(), e.getStackTrace());
}finally{
 
DBAccess.closeResultSet(lResultSet);
DBAccess.closeStatement(lStatement);
DBAccess.closeDBConnection(lConn);
}
return lColumnViewList;
}

Releasing DB resources :

public static void closeDBConnection(Connection pConnection) {
try {
if (pConnection != null) {
pConnection.close();
pConnection = null;
}
} catch (SQLException e) {
//System.out.println("CAN'T CLOSE DBCONNECTION WARNING WARNING DANGER: " + e.getMessage());
new BusinessException("SQLException while trying to closeDBConnection in DBAccess: " + e.getMessage(), e.getStackTrace());
}
}
public static void closeStatement(Statement pStatement) {
try {
if (pStatement != null) {
pStatement.close();
pStatement = null;
}
} catch (SQLException e) {
new BusinessException("SQLException while trying to closeStatement in DBAccess: " + e.getMessage(), e.getStackTrace());
}
}
public static void closeResultSet(ResultSet pResultSet) {
try {
if (pResultSet != null) {
pResultSet.close();
pResultSet = null;
}

} catch (SQLException e) {
//new BusinessException("SQLException while trying to closeResultSet in DBAccess: " + e.getMessage(), e.getStackTrace());
}
}

can you please let me know the possibilities to overcome this one...

-Naresh


[ April 08, 2008: Message edited by: Naresh Talluri ]

[Naresh Talluri]

here iam getting this error only on the load test only, not frequently.