Unanswered: Error while inserting data after renaming of the table through JDBC
We have very old schema (tables) with fairly large amount of data in each table , and we want to enhance complete schema and build views on top of the tables.i.e our old table name is xyz,we want to upgrade this table with new name xyz_tbl and view on top of this table is xyz ( same as old table names).
While upgrading the schema instead of creating new tables and pushing existing data into new tables,I renamed the existing table to new table name and created view for each table same as old table name.
old table name: xyz
new table name: xyz_tbl
view name: xyz
I ran following commands to rename and recompile all the tables
and created view on top of the existing table called as xyz (same as old table name).
I also created all the stored procedures and triggers to point to new table names.
It seems every thing looks okay to me from isql, but while inserting and updating data into the table through JDBC using stored procedures it is creating the problem.It is not inserting any data into the table.
I saw following error message in ASE server(12.5.2) log file.
I could have created new tables and loaded data into the tables,but we have about 20 tables with large amount of data,and I have to do this at atleast five places since we are using same schema in all the places.
Thanks a lot for your immediate response,there are some triggers pointing to old tables xyzs ,as you suggested I recreated the triggers and other objects to point to new table names(xyz_tbl) and it is working fine.
Will be there any data inconsistency issues with this process ( renaming of the tables instead of dropping and recreating of the tables)?