+ Reply to Thread
Results 1 to 4 of 4

Codepage 850 is not supported by the Java environment.

  1. Codepage 850 is not supported by the Java environment.

    Hi,

    I'm using sqljdbc_1.0.809.102 connecting to MS SQL 2000 with the server
    collation set to SQL_Latin1_general_CP850_CI_AS

    Here is the exception:
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed
    Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Codepage 850 is not
    supported by the Java environment.
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
    Source)

    Never had this problem with old MS JDBC driver and jTDS.

    Is there any workaround to this problem? What you would suggest?
    Which codepages are supported?

    Thanks,
    Igor


  2. RE: Codepage 850 is not supported by the Java environment.

    Hello Igor,

    I have tested getting data from a SQL Server 2000 table with the collation
    specified and I did not get the exception. Here's the table I used:

    CREATE TABLE [dbo].[CP850Table] (
    [id] [int] NOT NULL ,
    [data] [varchar] (50) COLLATE SQL_Latin1_General_CP850_CI_AS NULL
    ) ON [PRIMARY]
    GO

    ALTER TABLE [dbo].[CP850Table] ADD
    CONSTRAINT [PK_CP850Table] PRIMARY KEY CLUSTERED
    (
    [id]
    ) ON [PRIMARY]
    GO

    Can you post some code as well as some sample data you have in the table
    that you're seeing the problem with? If possible, can you post the data in
    its binary form to avoid any possible character display data issues? E.g.

    insert into cp850table values (2, 0x74657374)

    Additonally, I would like to know which Java Virtual Machine and version
    you are using.

    Thanks,
    Kamil

    Kamil Sykora [MSFT]
    Microsoft Developer Support - Webdata

    This posting is provided "AS IS", with no warranties, and confers no
    rights.

    Please do not send email directly to this alias. This alias is for
    newsgroup
    purposes only.

    --------------------
    | From: "=?Utf-8?B?bXlhZ2NoZXY=?="
    | Subject: Codepage 850 is not supported by the Java environment.
    | Date: Thu, 23 Feb 2006 01:02:28 -0800
    | Lines: 20
    |
    | Hi,
    |
    | I'm using sqljdbc_1.0.809.102 connecting to MS SQL 2000 with the server
    | collation set to SQL_Latin1_general_CP850_CI_AS
    |
    | Here is the exception:
    | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed
    | Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Codepage 850 is
    not
    | supported by the Java environment.
    | at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
    | Source)
    |
    | Never had this problem with old MS JDBC driver and jTDS.
    |
    | Is there any workaround to this problem? What you would suggest?
    | Which codepages are supported?
    |
    | Thanks,
    | Igor
    |
    |


  3. RE: Codepage 850 is not supported by the Java environment.

    The problem is that the collation is set on the db level. So the exception is
    trown during the connection establishment and login phase.

    The execution context: JBoss 3.2.5 that starts with Sun JDK 1.4.2_04.

    Here is the datasource definition:

    jdbc/JFDataSource

    jdbc:sqlserver://HOST:1600;databaseName=DB_NAME

    com.microsoft.sqlserver.jdbc.SQLServerDriver
    auser
    000000
    5
    20


    The exception is thrown on the AS startup.

    To reproduce it create new database with the collation set to
    SQL_Latin1_General_CP850_CI_AS and try connect to it.

    Igor

    "Kamil Sykora [MSFT]" wrote:

    > Hello Igor,
    >
    > I have tested getting data from a SQL Server 2000 table with the collation
    > specified and I did not get the exception. Here's the table I used:
    >
    > CREATE TABLE [dbo].[CP850Table] (
    > [id] [int] NOT NULL ,
    > [data] [varchar] (50) COLLATE SQL_Latin1_General_CP850_CI_AS NULL
    > ) ON [PRIMARY]
    > GO
    >
    > ALTER TABLE [dbo].[CP850Table] ADD
    > CONSTRAINT [PK_CP850Table] PRIMARY KEY CLUSTERED
    > (
    > [id]
    > ) ON [PRIMARY]
    > GO
    >
    > Can you post some code as well as some sample data you have in the table
    > that you're seeing the problem with? If possible, can you post the data in
    > its binary form to avoid any possible character display data issues? E.g.
    >
    > insert into cp850table values (2, 0x74657374)
    >
    > Additonally, I would like to know which Java Virtual Machine and version
    > you are using.
    >
    > Thanks,
    > Kamil
    >
    > Kamil Sykora [MSFT]
    > Microsoft Developer Support - Webdata
    >
    > This posting is provided "AS IS", with no warranties, and confers no
    > rights.
    >
    > Please do not send email directly to this alias. This alias is for
    > newsgroup
    > purposes only.
    >
    > --------------------
    > | From: "=?Utf-8?B?bXlhZ2NoZXY=?="
    > | Subject: Codepage 850 is not supported by the Java environment.
    > | Date: Thu, 23 Feb 2006 01:02:28 -0800
    > | Lines: 20
    > |
    > | Hi,
    > |
    > | I'm using sqljdbc_1.0.809.102 connecting to MS SQL 2000 with the server
    > | collation set to SQL_Latin1_general_CP850_CI_AS
    > |
    > | Here is the exception:
    > | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed
    > | Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Codepage 850 is
    > not
    > | supported by the Java environment.
    > | at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
    > | Source)
    > |
    > | Never had this problem with old MS JDBC driver and jTDS.
    > |
    > | Is there any workaround to this problem? What you would suggest?
    > | Which codepages are supported?
    > |
    > | Thanks,
    > | Igor
    > |
    > |
    >
    >


  4. RE: Codepage 850 is not supported by the Java environment.

    Hello Igor,

    I have still been unable to reproduce this even with a new database created
    with a SQL_Latin1_General_CP850_CI_AS database. I do have a slightly higher
    version of the VM, however: 1.4.2_08.

    Would you be able to test this with a simple console application outside of
    JBoss?
    Would you be able to test it with a higher VM version?

    Thanks,
    Kamil

    Kamil Sykora [MSFT]
    Microsoft Developer Support - Webdata

    This posting is provided "AS IS", with no warranties, and confers no
    rights.

    Please do not send email directly to this alias. This alias is for
    newsgroup
    purposes only.
    --------------------
    | From: =?Utf-8?B?bXlhZ2NoZXY=?=
    | Subject: RE: Codepage 850 is not supported by the Java environment.
    | Date: Thu, 9 Mar 2006 02:10:27 -0800
    |
    | The problem is that the collation is set on the db level. So the
    exception is
    | trown during the connection establishment and login phase.
    |
    | The execution context: JBoss 3.2.5 that starts with Sun JDK 1.4.2_04.
    |
    | Here is the datasource definition:
    |
    | jdbc/JFDataSource
    |
    |
    jdbc:sqlserver://HOST:1600;databaseName=DB_NAME url>
    |
    | com.microsoft.sqlserver.jdbc.SQLServerDriver
    | auser
    | 000000
    | 5
    | 20
    |

    |
    | The exception is thrown on the AS startup.
    |
    | To reproduce it create new database with the collation set to
    | SQL_Latin1_General_CP850_CI_AS and try connect to it.
    |
    | Igor
    |
    | "Kamil Sykora [MSFT]" wrote:
    |
    | > Hello Igor,
    | >
    | > I have tested getting data from a SQL Server 2000 table with the
    collation
    | > specified and I did not get the exception. Here's the table I used:
    | >
    | > CREATE TABLE [dbo].[CP850Table] (
    | > [id] [int] NOT NULL ,
    | > [data] [varchar] (50) COLLATE SQL_Latin1_General_CP850_CI_AS NULL
    | > ) ON [PRIMARY]
    | > GO
    | >
    | > ALTER TABLE [dbo].[CP850Table] ADD
    | > CONSTRAINT [PK_CP850Table] PRIMARY KEY CLUSTERED
    | > (
    | > [id]
    | > ) ON [PRIMARY]
    | > GO
    | >
    | > Can you post some code as well as some sample data you have in the
    table
    | > that you're seeing the problem with? If possible, can you post the data
    in
    | > its binary form to avoid any possible character display data issues?
    E.g.
    | >
    | > insert into cp850table values (2, 0x74657374)
    | >
    | > Additonally, I would like to know which Java Virtual Machine and
    version
    | > you are using.
    | >
    | > Thanks,
    | > Kamil
    | >
    | > Kamil Sykora [MSFT]
    | > Microsoft Developer Support - Webdata
    | >
    | > This posting is provided "AS IS", with no warranties, and confers no
    | > rights.
    | >
    | > Please do not send email directly to this alias. This alias is for
    | > newsgroup
    | > purposes only.
    | >
    | > --------------------
    | > | From: "=?Utf-8?B?bXlhZ2NoZXY=?="
    | > | Subject: Codepage 850 is not supported by the Java environment.
    | > | Date: Thu, 23 Feb 2006 01:02:28 -0800
    | > | Lines: 20
    | > |
    | > | Hi,
    | > |
    | > | I'm using sqljdbc_1.0.809.102 connecting to MS SQL 2000 with the
    server
    | > | collation set to SQL_Latin1_general_CP850_CI_AS
    | > |
    | > | Here is the exception:
    | > | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Failed
    | > | Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Codepage 850
    is
    | > not
    | > | supported by the Java environment.
    | > | at
    com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
    | > | Source)
    | > |
    | > | Never had this problem with old MS JDBC driver and jTDS.
    | > |
    | > | Is there any workaround to this problem? What you would suggest?
    | > | Which codepages are supported?
    | > |
    | > | Thanks,
    | > | Igor
    | > |
    | > |
    | >
    | >
    |


+ Reply to Thread