HP OSMS Blueprint: Database Server on HP ProLiant Servers with MySQL and SLES10

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 10 indicate that read-write access to the MySQL database
was successful.
Figure 10 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 11 indicates the write access
to the database is denied. The List of Employee Records is displayed indicating the database
was read successfully.
Connecting External Systems to the MySQL Database 35