db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2334) Accept the new collation attribute and store it in services.properties file. Will be used for language based collation ordering.
Date Mon, 19 Feb 2007 05:00:10 GMT

    [ 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.


Mime
View raw message