This example uses the Unwired Accelerator sample database to illustrate how to use a JNDI data source resource in the definition of a database application.
Creating a database element using a connection
cache reference
Log in to Web Studio, select Build | Applications, then click New to access the Application Builder.
When the Application Builder displays, click the down-arrow to the right of the Add button, and select Database Element.
When the Web Studio – New Web Element window appears, select the Connection Cache option.
Complete these fields:
Conn Cache Name – from the drop-down list, select the name of the connection cache for the sample database:
sampledb
SQL Query String – enter this SQL statement as one line:
select c.lname, p.name, si.quantity, si.id, si.prod_id from customer c, sales_order s, sales_order_items si, product p where c.id = s.cust_id and s.id = si.id and si.prod_id = p.id
Click Preview. You see the data that corresponds to the SQL query.
Click Next.
On the next three windows (Split, Define, and, Filter), click Next to bypass the options. See the “Data-capable post-processing options” section in Chapter 5 of the Enterprise Portal Developer’s Guide for descriptions of these options.
In the Window Preview, enter Sales
Update for the Element Name, then click Next.
In the Continuous Capture window, click Finish. Do not click Continue in this window.
Back in the Application Builder, click Save and complete the options on the Web Studio – New Application Finish window.
In the Finish window, under the Content tab, in the
Name field, enter salesup.
Accept all the other defaults, and click Finish.
In the pop-up confirmation, click OK.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
