[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
xAPdb - launched
- Subject: xAPdb - launched
- From: mark_harrison_uk2
- Date: Fri, 21 May 2004 14:38:00 +0000
xAPdb is now available from www.ascentium.co.uk\xap
xAPdb performs queries on a database in response to certain xAP
messages, returning the database results as xAP messages themselves.
xAPlogger is database independant, and uses any ODBC data source as
the message store.
xAPdb listens for messages in the database.query schema, and responds
in the database.result schema. xAPdb sends one xAP message per row
returned from the database.
The database.query schema defines a single body part, also called
database.query, as follows:
database.query
{
sql=SQL query to be run
datasource=name of ODBC data source against which the SQL should
be run
}
The database.result schema defines a two body part, called
database.query and database.result, as follows:
database.query
{
sql=SQL query to which this is part of the response
datasource=ODBC data source for the xAP message to which this is
part of the response
totalrows=Number of rows the query has returned
row=Row number for which this message contains the data
}
database.result
{
One keyword/value pair is returned for every SQL entity returned in
the query.
The name of the keyword is the field name of the SQL entity being
returned.
}
xAP_Automation Main Index |
xAP_Automation Thread Index |
xAP_Automation Home |
Archives Home
|