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/07/20 22:58:06 UTC

[jira] Created: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
------------------------------------------------------------------------------

                 Key: DERBY-2966
                 URL: https://issues.apache.org/jira/browse/DERBY-2966
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.4.0.0
            Reporter: Kathey Marsden
            Priority: Critical


In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.



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


[jira] Resolved: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

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

Mamta A. Satoor resolved DERBY-2966.
------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.4.0.0
                   10.3.1.4

> rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-2966
>                 URL: https://issues.apache.org/jira/browse/DERBY-2966
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Mamta A. Satoor
>            Priority: Critical
>             Fix For: 10.3.1.4, 10.4.0.0
>
>         Attachments: NoConnectionBug.java
>
>
> In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.

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


[jira] Closed: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

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

Kathey Marsden closed DERBY-2966.
---------------------------------


verified fix

> rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-2966
>                 URL: https://issues.apache.org/jira/browse/DERBY-2966
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Mamta A. Satoor
>            Priority: Critical
>             Fix For: 10.3.1.4, 10.4.0.0
>
>         Attachments: NoConnectionBug.java
>
>
> In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.

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


[jira] Assigned: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

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

Mamta A. Satoor reassigned DERBY-2966:
--------------------------------------

    Assignee: Mamta A. Satoor

> rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-2966
>                 URL: https://issues.apache.org/jira/browse/DERBY-2966
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Mamta A. Satoor
>            Priority: Critical
>         Attachments: NoConnectionBug.java
>
>
> In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.

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


[jira] Commented: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

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

Kathey Marsden commented on DERBY-2966:
---------------------------------------

Thanks Mamta,

The tests that were failing with no connection and no current row are passing now.


> rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-2966
>                 URL: https://issues.apache.org/jira/browse/DERBY-2966
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Mamta A. Satoor
>            Priority: Critical
>             Fix For: 10.3.1.4, 10.4.0.0
>
>         Attachments: NoConnectionBug.java
>
>
> In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.

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


[jira] Updated: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

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

Kathey Marsden updated DERBY-2966:
----------------------------------

    Attachment: NoConnectionBug.java

java NoConnectionBug


 UCS_BASIC collation
  Testing updateShort on SQL type SMALLINT
PASS: moveInsertRow did not cause loss of connection

[snip all ok for UCSBASIC]



 Territory no_NO
  Testing updateShort on SQL type SMALLINT
Exception in thread "main" java.sql.SQLException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:104)
        at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:208)
        at org.apache.derby.impl.jdbc.EmbedStatement.checkExecStatus(EmbedStatement.java:1396)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1649)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(EmbedPreparedStatement.java:275)
        at NoConnectionBug.runTestUpdateXXXAllDataTypesInsertRow(NoConnectionBug.java:171)
        at NoConnectionBug.testUpdateXXXAllDataTypesInsertRow(NoConnectionBug.java:202)
        at NoConnectionBug.main(NoConnectionBug.java:110)

> rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-2966
>                 URL: https://issues.apache.org/jira/browse/DERBY-2966
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Priority: Critical
>         Attachments: NoConnectionBug.java
>
>
> In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.

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


[jira] Commented: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

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

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

Commited a patch in main (Revision: 559125) and migrated it into 10.3 codeline (Revision: 559133) . Commit comments were as follows

DERBY-2966

We need to have context set up inside a moveToInsertRow code because that code tries to do DTD.getNull and getNull needs to find RuleBasedCollator which is found by relying on the context. Putting the context fixed the problem.



> rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-2966
>                 URL: https://issues.apache.org/jira/browse/DERBY-2966
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Mamta A. Satoor
>            Priority: Critical
>             Fix For: 10.3.1.4, 10.4.0.0
>
>         Attachments: NoConnectionBug.java
>
>
> In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.

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


[jira] Updated: (DERBY-2966) rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.

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

Kathey Marsden updated DERBY-2966:
----------------------------------

    Component/s: JDBC

> rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-2966
>                 URL: https://issues.apache.org/jira/browse/DERBY-2966
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Priority: Critical
>         Attachments: NoConnectionBug.java
>
>
> In the attached test case, rs.moveToInsertRow()  causes loss of the connection with a TERRITORY_BASED collation database. With UCS_BASIC it is fine.

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