Skip to Content
avatar image
Former Member

NWDS 7.1 SP03

Dear all,

I installed the NWDS 7.1 SP03. I want to create tables in a dictionary project. Is it possible to create these tables via open sql statements?

In this tutorial https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0c6b369-065a-2910-8f9e-fb6ad535558f

they mention a view under Data -> Database Explorer, but i dont see this view in my studio...

I do have the Data Source Explorer view, and i can connect to my dictionary, but when i choose New Table from there, it gives me a RuntimeException in the error log, ClassCastException org.eclipse.emf.common.util.BasicEList.... in the NewTableWizardAction.run(NewTableWizardAction.java:66) ....

When i generate the ddl script for an existing table in my dictionary, and try to do Execute All for the generated script, it says "Driver definition not specified for bd" where db is the name of my connection profile to my dictionary project...

I hope someone can help.

Kind regards,

J.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 03, 2008 at 11:26 AM

    Hi, Joren,

    1. The tutorial you are viewing describes working with an older version of NWDS. In CE SP3, you use the Data Source Explorer instead of the Database Explorer.

    2. You cannot create Java Dictionary tables using SQL, because Java Dictionary is not a real database, but just a meta-data representation of a real database.

    You should use Java Dictionary only if you plan to use the system database. You define your tables in the Java Dictionary (using the table editor in the Dictionary perspective of NWDS), and then you deploy these tables' definitions on the system database to create them physically.

    3. Unfortunately, I cannot comment on the exception that you're getting...

    4. Typically, you should use the "Generate DDL" function when you want to generate database tables from already existing entities; not for creating SQL queries or something.

    5. For CE SP3, you can find information about creating tables in Java Dictionary on the following link:

    http://help.sap.com/saphelp_nwce10/helpdata/en/87/773a55f35a65409009e87261c84eb2/frameset.htm

    Moreover, you can find additional information about Java Dictionary on the following link:

    http://help.sap.com/saphelp_nwce10/helpdata/en/69/f9bc3d52f39d33e10000000a11405a/frameset.htm

    In case this does not solve your problem, please describe in detail what exactly you would like to do.

    Regards,

    Yordan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi there, thx alot, that did help indeed!

      I was able to connect with sapce1db.

      I can see there is a schema for sapce1db that contains alot of sap tables.

      So next thing i gonna try is to create my own schema so i dont mix my tables with existing sap tables.

      thx alot for the help.

      Greetz,

      J.