[
https://issues.apache.org/jira/browse/DERBY-3420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12665441#action_12665441
]
Knut Anders Hatlen commented on DERBY-3420:
-------------------------------------------
Here's an example of how to use it:
1) Create a file called connection.properties which contains:
territory=no_NO
collation=TERRITORY_BASED
create=true
2) Start ij with -ca connection.properties
Now databases that don't exist should be automatically created when you connect
to them, and they should have Norwegian collation by default.
3) Connect to a database that doesn't already exist and see that it's created
and that ORDER BY uses Norwegian collation rules:
ij> connect 'jdbc:derby:mydb';
ij> select * from (values 'aa','ab','ba','bb') v(x) order by x;
X
--
ab
ba
bb
aa
4 rows selected
> The -ca option should be removed from ij and from the ij command usage line
> ---------------------------------------------------------------------------
>
> Key: DERBY-3420
> URL: https://issues.apache.org/jira/browse/DERBY-3420
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.3.2.1
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Priority: Minor
> Attachments: removeObsoleteArg.diff
>
>
> The ij tool gives the following help output:
> Usage: java org.apache.derby.tools.ij [-p propertyfile] [-ca
> connectionAttributePropertyFile] [inputfile]
> The -ca connectionAttributePropertyFile option is no longer needed and is
> deprecated, so it is not documented in the Tools Guide. The option should
> also be removed from the usage statement.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
