ORA-29533; SQLJ import with JDeveloper
714055Jul 27 2009 — edited Nov 20 2014Hi all,
I have got recently strange problem with JDeveloper and SQLJ on Oracle 9i. We still use 9i on some production and development machines. And the job was actually to develop some small SQLJ/XML application with 9i. Development was performed with JDeveloper 11g. The same tool was used also for application export/import/deploy. It means there is nothing like direct usage of command line tool loadjava, only with JDev. Anyway, several versions were deployed very easily, no problems. But the last one, which wasn't really something special, can not be deployed anymore due to following reasons:
ORA-29533: attempt to overwrite class or resource <CLASS> while defining or compiling <CLASS>
ORA-06512: at line 1
java.sql.SQLException: ORA-29533: attempt to overwrite class or resource <CLASS> while defining or compiling <CLASS>
ORA-06512: at line 1
Those errors occur only on SQLJ Java classes. All regular Java classes passing compilation and deployment without any problem at all. Even if I drop all classes with dropjava, and import again - it does not help. Even if I rename classes, and import again (as ORA-29533 error code suggests) - it does not help.
It would be great if someone can give me an idea about this.
regards