HP OSMS Blueprint: Database Server on HP Server Platforms with MySQL and RHEL5

NOTE: The following section appears at the beginning of the list.jsp file:
//read-only data source
//String dsName ="jdbc/roDS";
//read-write data source
String dsName ="jdbc/rwDS";
These lines define the data source, which will be used to connect MySQL server. The string
name jdbc/roDS is for read-only data sources and the string name jdbc/rwDS is for
read-write data sources.
8. Perform a read-write test on the data and verify the following:
• The list.jsp file contains the line String dsName ="jdbc/rwDS; and it is
uncommented.
• The list.jsp file contains the line String dsName ="jdbc/roDS"; and it is
commented.
The records list should contain ID 7, the record which was inserted with the file list.jsp.
The results displayed in Figure 11 indicate that read-write access to the MySQL database
was successful.
Figure 11 Employee Records List—Read-Write Test
9. Perform a test on a read-only data source and verify the following:
• The list.jsp file contains the line String dsName ="jdbc/roDS"; and it is
uncommented.
• The list.jsp file contains the line String dsName ="jdbc/rwDS"; and it is
commented.
10. Start the Tomcat service if it is not started. Use a browser to navigate to the Tomcat server
located at:
http://<your_tomcat_server>:8080/osmsexample/list.jsp
The error message SQL Error:INSERT … displayed in Figure 12 indicates the write access
to the database is denied. The List of Employee Records is displayed indicating the database
was read successfully.
36