This sample demonstrates how to use the PowerBuilder 10 XML Web DataWindow in EAServer by writing the necessary code in a JSP file. You create a Web application in EAServer Manager, copy a JSP file into the Web application, 131j96b and view the XML Web DataWindow in a browser. This sample uses the Unicode version of the EAS Demo database.
The sample contains two files:
XMLWebDWSample.pbl contains the DataWindow object used in the sample.
XMLWebDWSample.jsp contains the code that displays the DataWindow in a browser.
XML Web DataWindow.
Unicode enabling.
For international characters to display correctly in the DataWindow, they must be installed on your system. You can install additional characters from the Windows control panel using the Regional Options (Windows 2000) or Regional and Language Options (Windows XP) dialog boxes.
Adaptive Server Anywhere (ASA) 9.0.1 and the EAS Demo DB V10 Unicode database must be installed on your system. Both are installed as part of the PowerBuilder typical install. You must also have Internet Explore 6.0 or later or Netscape 7.1 or later, and you must install EAServer 5.1.
Install EAServer 5.1 following the instructions in chapter 2 of the PowerBuilder Enterprise Installation Guide. The EAServer Developer Edition is provided on Disk 2 in the PowerBuilder Enterprise product package.
If you are using an evaluation version of PowerBuilder, see the readme file on the evaluation CD for how to obtain and install EAServer.
First you create a Web
application in EAServer:
Copy XMLWebDWSample.pbl
to %EAServer%\bin, where %EAServer% is the location of your
EAServer 5.1 installation.
Make sure
that you have a DSN called EAS Demo DB V10 Unicode installed on your system.
This DSN is installed when you install PowerBuilder.
Select
Start>Programs>Sybase>EAServer 5.1.0>Jaguar Server to start
EAServer.
Select
Start>Programs>Sybase>EAServer 5.1.0>EAServer Manager to start
Sybase Central.
In Sybase
Central, select Tools>Connect>EAServer Manager>OK to open the Login
dialog box.
Enter
jagadmin as the User Name, leave the Password box blank, and click Connect.
Right-click
Web Applications in the left pane and select New Web Application.
Enter a name for the Web application, 131j96b such as MyWebApp.
Enter the name you just gave to the Web Application in the Context Path box and
click OK.
Select your
server in the Servers folder in the left pane (the default is Jaguar) and
expand the node.
Right-click Installed Web Applications, select Install a Web Application, click
Install and Existing Web Application, select the Web Application you just
created, and click OK.
Make sure
that the HTMLGenerator100 component is in the DataWindow package.
If it is not, run the PBVM setup file from the CD to deploy the PBVM and
HTMLGenerator100 to your EAServer.
Copy XMLWebDWSample.jsp
to the %EAServer%\Repository\WebApplication\MyWebApp directory.
This directory was created when you created the Web application.
Open the XMLWebDWSample.jsp
file and change the following line to match your EAServer host name and port,
for example "localhost:9000":
String host = "adcpbqam2k3:9050";
Now you can access and
manipulate the DataWindow in a Web browser:
Type the
following address into your browser:
https://<hostname>:<http port number>/<Web
application>/XMLWebDWSample.jsp
where <hostname> is the name of the host that EAServer resides on,
<http port number> is the HTTP port number of EAServer, typically
8080,
<Web application> is the name of the Web application you created
on the server.
For example: https://localhost:8080/MyWebApp/XMLWebDWSample.jsp.
You see a grid-style DataWindow in the browser showing information about
employees. (If the DataWindow does not display, right-click the server in
EAServer Manager and select Shutdown and Start from the pop-up menu.)
Use the buttons at the bottom of the DataWindow to navigate through the data and to insert, delete, update, and retrieve data.
For more information about using the XML Web DataWindow, see chapters 6 and 7 of the DataWindow Programmer's Guide in the compiled HTML Help. For information about working with the Web DataWindow in JSP pages in PowerBuilder, see chapters 8 to 11 in Working with Web and JSP Targets.
|
