You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2007/04/11 23:53:32 UTC

[jira] Created: (DERBY-2541) Create initial testing framework for Junit Collation testing

Create initial testing framework for Junit Collation testing
------------------------------------------------------------

                 Key: DERBY-2541
                 URL: https://issues.apache.org/jira/browse/DERBY-2541
             Project: Derby
          Issue Type: Sub-task
          Components: Test
            Reporter: Kathey Marsden
         Assigned To: Kathey Marsden
            Priority: Minor
             Fix For: 10.3.0.0


Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.





-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12488741 ] 

Daniel John Debrunner commented on DERBY-2541:
----------------------------------------------

You can look at Decorator.encryptedDatabase() for an example of how to do this using the existing single use decorator.

> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-2541:
----------------------------------

    Attachment: DERBY-2541_diff.txt

Attaching a patch for this issue.  I found that there was already a JDBCDataSource.getDataSourceLogical(dbname), so I was able to use the additionalDatabaseDecorator.

This test has simple order by tests for the default sort order (unicode), English, Norwegian, and Polish.  Only the default is enabled for now.


> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12489200 ] 

Kathey Marsden commented on DERBY-2541:
---------------------------------------

I believe they are all created within the same Derby system.




> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden resolved DERBY-2541.
-----------------------------------

    Resolution: Fixed
    Derby Info:   (was: [Patch Available])

> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-2541:
----------------------------------

    Derby Info: [Patch Available]

> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-2541:
----------------------------------

    Attachment: DERBY-2541_stat.txt

> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12489196 ] 

Mamta A. Satoor commented on DERBY-2541:
----------------------------------------

Kathey, I reviewed the patch from a functionality point of view (and not much from Junit point of view) and the patch looks good. I have a generic question. All these databases with different collations will be tested within same Derby system, right? I would like us to test the fact that within same Derby system, different databases with different collations work in harmony. Thanks Kathey for taking this on.

> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden closed DERBY-2541.
---------------------------------


> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2541_diff.txt, DERBY-2541_stat.txt
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-2541) Create initial testing framework for Junit Collation testing

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-2541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12488434 ] 

Kathey Marsden commented on DERBY-2541:
---------------------------------------

For creating the databases I am going with the JDBCDataSource methods. e.g.
 
    DataSource ds = JDBCDataSource.getDataSource("nordb");
      JDBCDataSource.setBeanProperty(ds, "connectionAttributes", 
                  "create=true;territory=no;collation=TERRITORY_BASED");

I am looking at the removal of the databases.  I was thinking of a  decorator.
TestConfiguration.cleanupDatabases(Test test, String[] databasesToRemove).
Does this sound like a reasonable approach?  There should be code for additionalDatabaseDecorator for the removal but I don't see it right away.




> Create initial testing framework for Junit Collation testing
> ------------------------------------------------------------
>
>                 Key: DERBY-2541
>                 URL: https://issues.apache.org/jira/browse/DERBY-2541
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>
> Collation support testing needs to be able to create multiple new databases with the collation attribute set., upgrade databases etc.  Add a few basic tests showing how this will work even though the feature is not yet functional.  I looked at the additionalDatabaseDecorator, but it does not seem to have a way to change the attributes.   Another option is to use  JDBCDataSource.setBeanProperty to set the attributes, but then the cleanup is not automatic. I am just starting to look at this so if anyone has any good ideas, please post.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.