Bug 1019507 - [Bug in HTTP Connectors Load Balancing Guide]: Bad SQL example
Summary: [Bug in HTTP Connectors Load Balancing Guide]: Bad SQL example
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: JBoss Enterprise Application Platform 5
Classification: JBoss
Component: doc-HTTP_Connectors_Guide
Version: 5.2.0
Hardware: Unspecified
OS: Unspecified
low
unspecified
Target Milestone: ---
: ---
Assignee: Scott Mumford
QA Contact: Russell Dickenson
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-10-15 21:55 UTC by dereed
Modified: 2015-04-24 00:54 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2015-04-24 00:54:55 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.