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 "snowdolphin (JIRA)" <ji...@apache.org> on 2007/01/18 08:47:30 UTC

[jira] Created: (DERBY-2251) When I Create a table with Chinese table name , ij report IO exception.

When I Create a table with Chinese table name , ij report IO exception.
-----------------------------------------------------------------------

                 Key: DERBY-2251
                 URL: https://issues.apache.org/jira/browse/DERBY-2251
             Project: Derby
          Issue Type: Bug
          Components: Network Client
    Affects Versions: 10.1.1.0
         Environment: Linux version 2.6.5-7.267-smp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Wed Jun 21 10:50:51 UT
C 2006
            Reporter: snowdolphin


I use this command create a database :

connect 'jdbc:derby://mytest.com:1527/mydb1;territory=zh_CN;create=true;user=usr;password=pwd';

I want to Create a table with a Chinese name :

Create Table usr."中国" ("世界" char(15));
Create Table usr."中国" (C1 char(15));
Create Table "中国" (C1 char(15));
Create Table T1 ("中国" char(15));

Report very much IO exception.

And the derby Crash.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Commented: (DERBY-2251) When I Create a table with Chinese table name , ij report IO exception.

Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-2251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465688 ] 

Knut Anders Hatlen commented on DERBY-2251:
-------------------------------------------

This is because the network driver uses EBCDIC encoding for meta data (database names, table names etc.). See also DERBY-728.

> When I Create a table with Chinese table name , ij report IO exception.
> -----------------------------------------------------------------------
>
>                 Key: DERBY-2251
>                 URL: https://issues.apache.org/jira/browse/DERBY-2251
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions: 10.1.1.0
>         Environment: Linux version 2.6.5-7.267-smp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Wed Jun 21 10:50:51 UT
> C 2006
>            Reporter: snowdolphin
>
> I use this command create a database :
> connect 'jdbc:derby://mytest.com:1527/mydb1;territory=zh_CN;create=true;user=usr;password=pwd';
> I want to Create a table with a Chinese name :
> Create Table usr."中国" ("世界" char(15));
> Create Table usr."中国" (C1 char(15));
> Create Table "中国" (C1 char(15));
> Create Table T1 ("中国" char(15));
> Report very much IO exception.
> And the derby Crash.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Commented: (DERBY-2251) When I Create a table with Chinese table name , ij report IO exception.

Posted by "Bernt M. Johnsen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-2251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465706 ] 

Bernt M. Johnsen commented on DERBY-2251:
-----------------------------------------

I don't think this is related to DERBY-728. I tried it out myself, it seems to work with chinese characters in table names from both Java code and from IJ. It would be nice if the stack trace from the observed crash could be attached to this report.

> When I Create a table with Chinese table name , ij report IO exception.
> -----------------------------------------------------------------------
>
>                 Key: DERBY-2251
>                 URL: https://issues.apache.org/jira/browse/DERBY-2251
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions: 10.1.1.0
>         Environment: Linux version 2.6.5-7.267-smp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Wed Jun 21 10:50:51 UT
> C 2006
>            Reporter: snowdolphin
>
> I use this command create a database :
> connect 'jdbc:derby://mytest.com:1527/mydb1;territory=zh_CN;create=true;user=usr;password=pwd';
> I want to Create a table with a Chinese name :
> Create Table usr."中国" ("世界" char(15));
> Create Table usr."中国" (C1 char(15));
> Create Table "中国" (C1 char(15));
> Create Table T1 ("中国" char(15));
> Report very much IO exception.
> And the derby Crash.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] Resolved: (DERBY-2251) When I Create a table with Chinese table name , ij report IO exception.

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

Kathey Marsden resolved DERBY-2251.
-----------------------------------

    Resolution: Cannot Reproduce

According to the comments, this issue can no longer be reproduced.


> When I Create a table with Chinese table name , ij report IO exception.
> -----------------------------------------------------------------------
>
>                 Key: DERBY-2251
>                 URL: https://issues.apache.org/jira/browse/DERBY-2251
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions: 10.1.1.0
>         Environment: Linux version 2.6.5-7.267-smp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Wed Jun 21 10:50:51 UT
> C 2006
>            Reporter: snowdolphin
>
> I use this command create a database :
> connect 'jdbc:derby://mytest.com:1527/mydb1;territory=zh_CN;create=true;user=usr;password=pwd';
> I want to Create a table with a Chinese name :
> Create Table usr."中国" ("世界" char(15));
> Create Table usr."中国" (C1 char(15));
> Create Table "中国" (C1 char(15));
> Create Table T1 ("中国" char(15));
> Report very much IO exception.
> And the derby Crash.

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


[jira] Closed: (DERBY-2251) When I Create a table with Chinese table name , ij report IO exception.

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

Tiago R. Espinha closed DERBY-2251.
-----------------------------------


> When I Create a table with Chinese table name , ij report IO exception.
> -----------------------------------------------------------------------
>
>                 Key: DERBY-2251
>                 URL: https://issues.apache.org/jira/browse/DERBY-2251
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions: 10.1.1.0
>         Environment: Linux version 2.6.5-7.267-smp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Wed Jun 21 10:50:51 UT
> C 2006
>            Reporter: snowdolphin
>
> I use this command create a database :
> connect 'jdbc:derby://mytest.com:1527/mydb1;territory=zh_CN;create=true;user=usr;password=pwd';
> I want to Create a table with a Chinese name :
> Create Table usr."中国" ("世界" char(15));
> Create Table usr."中国" (C1 char(15));
> Create Table "中国" (C1 char(15));
> Create Table T1 ("中国" char(15));
> Report very much IO exception.
> And the derby Crash.

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


[jira] Commented: (DERBY-2251) When I Create a table with Chinese table name , ij report IO exception.

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

snowdolphin commented on DERBY-2251:
------------------------------------

Thanks Hatlen and Johnsen!

I tried it use an other user ID in the derby server  , It can't be reproduced , and it run correct!

I feel very strange. I think it maybe the environment problem.

Thanks Hatlen and Johnsen again!

> When I Create a table with Chinese table name , ij report IO exception.
> -----------------------------------------------------------------------
>
>                 Key: DERBY-2251
>                 URL: https://issues.apache.org/jira/browse/DERBY-2251
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions: 10.1.1.0
>         Environment: Linux version 2.6.5-7.267-smp (geeko@buildhost) (gcc version 3.3.3 (SuSE Linux)) #1 SMP Wed Jun 21 10:50:51 UT
> C 2006
>            Reporter: snowdolphin
>
> I use this command create a database :
> connect 'jdbc:derby://mytest.com:1527/mydb1;territory=zh_CN;create=true;user=usr;password=pwd';
> I want to Create a table with a Chinese name :
> Create Table usr."中国" ("世界" char(15));
> Create Table usr."中国" (C1 char(15));
> Create Table "中国" (C1 char(15));
> Create Table T1 ("中国" char(15));
> Report very much IO exception.
> And the derby Crash.

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