Red Hat Bugzilla – Bug 1019507
[Bug in HTTP Connectors Load Balancing Guide]: Bad SQL example
Last modified: 2015-04-23 20:54:55 EDT
Document URL: https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/5/html-single/HTTP_Connectors_Load_Balancing_Guide/index.html Section Number and Name: Chapter 18. High-Availability Web Sessions Describe the issue: There is an SQL snippet labeled as "The following command creates the table with default settings in the most common databases (MySQL, IBM DB2, Oracle Database):". However, the given SQL does not work in MySQL (version 5.5.31). LONGVARBINARY is not a valid type in MySQL, and VARBINARY requires a size to be specified. Suggestions for improvement: Include SQL that works in MySQL. Additional information: Also, should
MySQL has been removed as a possible usage for the SQL command. Moving bug to MODIFIED until an updated build is available for review.
Moving to POST pending rebuild. New content will be available at the URL below: https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/5/html-single/HTTP_Connectors_Load_Balancing_Guide/index.html#ch-High-Availability_Web_Sessions_with_Database_Persistence