Bug 1019507

Summary: [Bug in HTTP Connectors Load Balancing Guide]: Bad SQL example
Product: [JBoss] JBoss Enterprise Application Platform 5 Reporter: dereed
Component: doc-HTTP_Connectors_GuideAssignee: Scott Mumford <smumford>
Status: CLOSED WONTFIX QA Contact: Russell Dickenson <rdickens>
Severity: unspecified Docs Contact:
Priority: low    
Version: 5.2.0CC: dereed
Target Milestone: ---Keywords: Documentation, Triaged
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-04-24 00:54:55 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description dereed 2013-10-15 21:55:37 UTC 
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
Comment 1 Scott Mumford 2014-04-07 01:54:03 UTC 
MySQL has been removed as a possible usage for the SQL command.

Moving bug to MODIFIED until an updated build is available for review.
Comment 4 Scott Mumford 2014-06-16 04:45:58 UTC 
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