Frequently Asked Questions

This document attempts to answer some of the more frequently asked questions regarding various aspects of JAAD. These questions are typically asked over and over again on the mailing lists, as a courtesy to the developers, we ask that you read this document before posting to the mailing lists.

General

  1. What is JAAD?

General

What is JAAD ?
Please see the Goals and Features documents.

Using JAAD

The application throws a ClassNotFound: com.tibco.tibrv.TibrvMsg exception ?
TIBCO/ActiveDatabase (ADB) depends on TIBCO/RV . Since RV is a commercial product you must purchase it separately. Once you have purchased the product or downloaded an evaluation copy, make sure it is in your CLASSPATH . This should fix the problem.
I want to send a request to ADB and expect a reply message in response. This request/reply should happen synchronously. What method should I use ?
You should call sendRequest on the request object.
I want to send a request to ADB and do not expect a reply message in response. What method should I use ?
You should call send on the request object.
What are bind variables ?
The SQL statement sent to ADB can contain placeholders. These placeholders are replaced by actual values of bind variables on the ADB agent.
I want to send a request to ADB and expect a reply message in response. This request/reply should happen synchronously. Is there a way to specify a timeout for the response ?
By default, JAAD sets a timeout of 60 seconds on synchronous request/reply. You can change the timeout by calling setTimeout on the request object. An exception is thrown if the response is not received within the specified timeout period.
I want to execute a SQL statement at the target database. What statements can I execute on the database ?
ADB allows any valid SQL statement, including stored procedures, to be executed on the target database. In fact, more than one SQL statement can be executed in a single request. JAAD fully supports the construction of multiple SQL statements within a single request.
I am executing a SQL statement against the target database. The result set I get from ADB contains too many rows. How can I restrict the number of result rows ?
Select the appropriate maxRows parameter when constructing the AdbRequestStmt object(s). The default value for maxRows is -1 , which implies no limit on the number of result rows.
I am executing a SQL statement against the target database. The response I get from ADB is invalid - i.e. when I call isValid on the response object it returns true . How do I figure out details of the error ?
When a response object is invalid, then it is possible to get the details of the error by calling getError on the response object.