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

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

    Re: Change schema name in backend 2.x.

    ‏2013-07-31T16:26:50Z  

    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

    Re: Change schema name in backend 2.x.

    ‏2013-07-31T16:42:13Z  

    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

    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

    Re: Change schema name in backend 2.x.

    ‏2013-07-31T16:55:53Z  
    • ilhe
    • ‏2013-07-31T16:42:13Z

    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

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

  • ilhe
    ilhe
    3 Posts

    Re: Change schema name in backend 2.x.

    ‏2013-07-31T17:00:21Z  

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

    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

    Re: Change schema name in backend 2.x.

    ‏2013-08-02T14:08:59Z  
    • ilhe
    • ‏2013-07-31T17:00:21Z

    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?

    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)