Schema Change - Generated Roo App

[pavan4uus]

Hi,

I generated Roo MVC app using database reverse engneer.

Now i want to point to different schema instead of generated one.

If I change all the schema details in databse.properties file, its not working throwing exception "table doesn't exists".

Is there any way to change database schema without touching the generated roo code???

Thanks,

[Alan Stewart]

Your reverse-engineered entities have the table name in the @RooEntity annotation and would explain your issue if the new schema does have all of the same tables.

[pavan4uus]

if the schema name is different, the i should change schema name in each and every java file.

I have same table structure in both schema.

eg: current schema name is META
new schema name is METADATA

if i want to point to new schema then what should i do?????

[Alan Stewart]

You can re-run the database reverse engineer command using the new schema name. If your tables have exactly the same names as the previous schema, then your entities should be updated. Or as you suggest, manually change the schema names in your entities.