[
https://issues.apache.org/jira/browse/DERBY-2334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12474075
]
Daniel John Debrunner commented on DERBY-2334:
----------------------------------------------
logDevice and collation apply to a single database, not all databases in the
system. The service.properties file is information for a single database.
Ideally the contents of service.properties is the minimal information that is
required to boot the service (typically a database). Further database specific
information is stored by the storage system, in the properties conglomerate.
Thus database properties are stored in either service.properties or the
properties conglomerate, though they are set and read the same way. Only if a
property is listed in PropertyUtil.servicePropertyList does it get stored in
service.properties. Thus if you just removed collation from servicePropertyList
it would automatically get stored within the database (in the properties
conglomerate).
it may be easier to think of this that a JDBC attribute is being used to set a
database property. I.e. on boot , the value of collation sets the database
property derby.database.collation, with derby.database.collation defaulting to
USC_BASIC if the attribute is not provided.
> Accept the new collation attribute and store it in services.properties file.
> Will be used for language based collation ordering.
> --------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2334
> URL: https://issues.apache.org/jira/browse/DERBY-2334
> Project: Derby
> Issue Type: Sub-task
> Components: JDBC
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Mamta A. Satoor
> Attachments: DERBY2334_AcceptCollationAttribute_diff_V01.txt,
> DERBY2334_AcceptCollationAttribute_stat_V01.txt
>
>
> A user would specify the collation desired (UCS_BASIC or
> TERRITORY_BASED_COLLATION) through the new jdbc url attribute - collation.
> This attribute will be used to determine collation ordering for character
> datatypes,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
