[EMAIL PROTECTED] wrote:
>We are experiencing a problem on NetD version 4.1.2 running on both AIX and NT where
we execute an SQL and DB2 is >returning an error but NetD does not create an
exception
and continue to send the request to DB2 until it eventually returns
Every time before we do a DB2 query we do a query of the SYSIBM.SYSDUMMY1 table to
see if it comes back with the 'Y' from the one row in the table. If this
does not
happen then we Recycle the "DSRdbmsService" with this code below:
import spider.database.*;
public abstract class WiDataObjectConnection extends CSpDataObject
{
static String [] emptyStrArray = {""};
//**************************************************************************//
//* METHOD = closeConn
//* Closes all of the data objects.
//**************************************************************************//
/**
*
* @return boolean telling whether it worked or not
*/
public static boolean closeConn()
{
return CSpDataObject.broadcastAdminMessage(
"DSRdbmsService",
CSpDataObject.CLOSE_CONNECTION,
emptyStrArray);
}
}
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
