Topic
5 replies Latest Post - ‏2013-08-02T14:08:59Z by OctavioGonzalez
ilhe
ilhe
3 Posts
ACCEPTED ANSWER

Pinned topic Change schema name in backend 2.x.

‏2013-07-25T12:00:14Z |

Hi,

I have CMP Entity beans 2.x in my Project i RAD7.5. In the backend I have a DB2 schema with name S1. I want to change it to S2.

There is not visible field I can edit and change the schmea name. How can I change S1 to S2 (both schemas are in DB2).

Thanks for aany idea!

ilhe

  • OctavioGonzalez
    OctavioGonzalez
    12 Posts
    ACCEPTED ANSWER

    Re: Change schema name in backend 2.x.

    ‏2013-07-31T16:26:50Z  in response to ilhe

    Hi ilhe,

     

    You could try expanding the content the little folder names Data Models in your project, under databases your schema will be there, right click on it and select Refactor -> Rename and remember to save the dbm file.

     

    Hope this helps

    • ilhe
      ilhe
      3 Posts
      ACCEPTED ANSWER

      Re: Change schema name in backend 2.x.

      ‏2013-07-31T16:42:13Z  in response to OctavioGonzalez

      Hi,

      Thank you, Octavio!

      I had tried it after I posted this question, changed the name with Refactor. I searched to find the old name and it was not found. But after a program interrupted, there was the old scheme again.

      Regards

      ilhe

      • OctavioGonzalez
        OctavioGonzalez
        12 Posts
        ACCEPTED ANSWER

        Re: Change schema name in backend 2.x.

        ‏2013-07-31T16:55:53Z  in response to ilhe

        What do you mean by a "a program interrupted" ??

        • ilhe
          ilhe
          3 Posts
          ACCEPTED ANSWER

          Re: Change schema name in backend 2.x.

          ‏2013-07-31T17:00:21Z  in response to OctavioGonzalez

          It is when Application fails and Throws Exception (in java).

          Perhaps I was not precise enough. The scheme is sqlId, see here:

          DataSourceJdbc. dataSourceName is java:comp/env/jdbc/ TheKIWDataSource sqlID is S1.

          Can this say something?

          Updated on 2013-07-31T17:10:54Z at 2013-07-31T17:10:54Z by ilhe
          • OctavioGonzalez
            OctavioGonzalez
            12 Posts
            ACCEPTED ANSWER

            Re: Change schema name in backend 2.x.

            ‏2013-08-02T14:08:59Z  in response to ilhe

            So the error shows when you try to deploy?

            Have you checked the configuration of the server or the WebSphere Application Server deployment? (Accesible on the ear)