xiv Contents Testing and Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 Conclusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . | xiv Contents Testing and Documentation .162 Chapter 8 Database Introduction .171 Databases Supported in WebSphere Configuration Settings .172 Apache Derby .173 IBM MySQL .175 Oracle .176 Microsoft SQL Zero Resource Establishing a New ZRM Creating a Zero Resource Making ZRM Data Available as a Adding Data to a Zero Resource Model .182 Loading Data Using a ZRM Test Page .183 Iterative Zero Resource Model Design .184 Database Access with Working with Simple Query Methods .188 Data Manipulation Statements .191 Prepared Statements .192 Externalizing SQL Statements .194 Connection Data Access Using Data Access in Standard JDBC Database Access .197 Command-Line Database Management .205 Chapter 9 Security SSL Configuration .209 Enabling Security .213 Application Secret Key .213 Authentication Login Knowing Your Users .219 Additional Files for Our Testing the Secure Directory Server Configuration .224 Directory Server User Details .226 Download from Contents xv OpenID Securing Outbound Chapter 10 Event Timers .235 Application Initialization Using Simple File Kicker and Receiver .243 Custom Chapter 11 Framework Java Groovy APIs .255 PHP Active Content Assemble Chapter 12 Client-Side Programming with the Dojo Enter the Dojo .270 Enabling Dojo in Your Application .271 AppBuilder Page Put a Dojo Face on ZRM and Application DBA A Complete RIA Using WebSphere sMash and Project Layout Mockup .284 Initial Page Application .