facebook

"Edit Data" on Oracle 10 table shows error message

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #275002 Reply

    DavidGunkel
    Member

    Configuration:

    *** Date:
    Dienstag, 4. September 2007 14.23 Uhr CEST

    ** System properties:
    OS=WindowsXP
    OS version=5.1
    Java version=1.6.0_02

    *** MyEclipse details:
    MyEclipse Enterprise Workbench
    Version: 6.0.0 GA
    Build id: 6.0.0-GA-200708

    *** Eclipse details:
    Eclipse SDK

    Version: 3.3.0
    Build id: I20070625-1500

    Eclipse Graphical Editing Framework

    Version: 3.3.0.v20070620
    Build id: 20070620-1021

    Eclipse Project SDK

    Version: 3.3.0.v20070607-7M7J-BIolz-OcxWxvWAPSfLPqevO
    Build id: I20070625-1500

    Eclipse Platform

    Version: 3.3.0.v20070612-_19UEkLEzwsdF9jSqQ-G
    Build id: I20070625-1500

    Eclipse RCP

    Version: 3.3.0.v20070607-8y8eE8NEbsN3X_fjWS8HPNG
    Build id: I20070625-1500

    Eclipse Plug-in Development Environment

    Version: 3.3.0.v20070607-7N7M-DUUEF6Ez0H46IcCC
    Build id: I20070625-1500

    Eclipse Java Development Tools

    Version: 3.3.0.v20070606-0010-7o7jCHEFpPoqQYvnXqejeR
    Build id: I20070625-1500

    Eclipse Graphical Editing Framework

    Version: 3.3.0.v20070620
    Build id: 20070620-1021

    Eclipse startup command=-os
    win32
    -ws
    win32
    -arch
    x86
    -showsplash
    D:\Develop\IDE\eclipse3.3\eclipse\plugins\org.eclipse.platform_3.3.0.v20070613\splash.bmp
    -launcher
    D:\Develop\IDE\eclipse3.3\eclipse\eclipse.exe
    -name
    Eclipse
    –launcher.library
    D:\Develop\IDE\eclipse3.3\eclipse\plugins\org.eclipse.equinox.launcher.win32.win32.x86_1.0.0.v20070523\eclipse_1017a.dll
    -startup
    D:\Develop\IDE\eclipse3.3\eclipse\plugins\org.eclipse.equinox.launcher_1.0.0.v20070606.jar
    -launcher
    D:\Develop\IDE\eclipse3.3\eclipse\eclipse.exe
    -clean
    -vm
    C:\Programme\Java\jre1.6.0_02\bin\client\jvm.dll

    When right-clicking a table of an oracle-db (v10) in the “DB Browser” and selecting “Edit Data”, an empty edit-view comes up with the error message

    Error: Cannot edit: null

    in the status bar.

    The used jdbc-driver shown in “DB Connection Info” is Oracle thin driver, version 10.2.0.1.0.

    Information about table fields, indices etc. is correctly displayed. The user has access rights to modify data.

    #275042 Reply

    Riyad Kalla
    Member

    Is the table empty or does it contain rows of data?

    #275048 Reply

    DavidGunkel
    Member

    The table contains data, as “Row Count” from “Table/Object Info” correctly shows.

    #275090 Reply

    Riyad Kalla
    Member

    Are you running in a non-US locale by chance?

    #275218 Reply

    DavidGunkel
    Member

    Yes, my locale is a non-US locale: Windows and DB both use GERMAN, Codepage=1252.

    ______________
    David

    #275259 Reply

    Riyad Kalla
    Member

    David,
    This is a known issue I’m sorry you ran into that. We will hopefully get it fixed soon.

    The workaround for the time being is to launch with a US locale, like the following:

    
    eclipse.exe -nl en_EN
    
    #275301 Reply

    DavidGunkel
    Member

    Sorry, but this doesn’t help. Starting eclipse with -nl en_EN leads to error messages from Oracle at connect time:

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2007-09-10 07:45:30.034
    !MESSAGE Error while performing database login with the da3ss021_b29 driver
    !STACK 0
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
    ORA-12705: Cannot access NLS data files or invalid environment specified
    
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
        at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
        at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:51)
        at java.lang.Thread.run(Unknown Source)
    #275302 Reply

    DavidGunkel
    Member

    Information

    Using

    
    eclipse.exe -nl en_US

    (insead of locale en_EN)

    works!

    #275388 Reply

    Riyad Kalla
    Member

    David,
    I’m sorry about that I copied the wrong locale and pasted it, you got exactly the right one (en_US).

Viewing 9 posts - 1 through 9 (of 9 total)
Reply To: "Edit Data" on Oracle 10 table shows error message

You must be logged in to post in the forum log in