Issue: scarab.database.admin.url doesn't include the scarab.database.url.extension thus causing errors on a UTF-8 based database

Hi Folks,

Because I cannot register on the tracker here is another of our
issues...Ive cut&paste from our own internal scarab.

Issue ID 	*TPSW37 (Defect)*
	Created by 	Barry Pearce <mailto:[email protected]> -
07-Oct-2008 11:13:43 GMT 	Last modified by 	Barry Pearce
<mailto:[email protected]> - 07-Oct-2008 11:13:49 GMT


        Basic Info

Component/Product 	Scarab
Component/Product Version 	Subversion trunk 10627
Summary 	scarab.database.admin.url doesn't include the
scarab.database.url.extension thus causing errors on a UTF-8 based database


        Situation

Description 	

When using MySQL with utf-8 the scarab.database.url.extension will be set to specify the UTF-8 aspects of the connection such as:

scarab.database.url.extension.mysql=useUnicode=true&characterEncoding=utf8

(This setting is even included as an example in the comments!!)

By not including this on the scarab.database.admin.url errors are caused. The admin url should read:

scarab.database.admin.url.mysql=${jdbc}:${scarab.jdbc.handler}://${scarab.database.host}:${scarab.database.port}/?${scarab.database.url.extension}
scarab.database.url.mysql=${jdbc}:${scarab.jdbc.handler}://${scarab.database.host}:${scarab.database.port}/${scarab.database.name}?zeroDateTimeBehavior=convertToNull&${scarab.database.url.extension}

Status 	Unconfirmed
On Hold 	No
Severity 	9 - Critical
Occurance Likelihood 	10 - Constantly
Priority 	Low
Further Info Required? 	No
FunctionalArea 	Data Storage
Platform 	PC
Processor 	AMD Athlon XP2600+
OperatingSystem 	Ubuntu Server
Operating System Version 	Hardy Heron 8.04.1
Runtime Environment 	JBoss AS 4.2.3GA, MySQL 5.0.51a
Java Version 	J2SE 6.0


        Actions

Assessment 	

Raise with Scarab.tigris.org.

Work-Around 	

Fix the build.properties as described in the description.


-- 
Sincerely Yours

Copyright Witness Net Support
[email protected]

www.copyrightwitness.com
Registration centre for copyright works.

This e-mail and any attachments are confidential and intended for the addressee only.
The information in this mail does not amount to legal advice or opinion. Any views or legal references are those of the author and are based on personal opinion or understanding only.