Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deploying SQLJ classes as Java Stored Procedures using JDeveloper 10g

715047Jul 31 2009
Hello,

I have defined a SQLJ class, MwaSqljDao.sqlj, in JDeveloper. When I right click on the SQLJ class and "make" the class. It appears to succeed.

However when I attempt to build the project in which the SQLJ class is a member of, a class that uses the SQLJ class has the following compile error:
- MwaSqljDao not found.

After a little digging it appears JDeveloper is able to compile the .sqlj file to a .java file in the classes output directory. However it does not take it to the next step of compiling the .java file into a .class file.

Is SQLJ still a main stream Oracle technology? Or has it been cast to way side to make way for other technology?

If SQLJ is still a supported Oracle technology how do go about compiling the SQLJ class using JDeveloper?

My goal is to deploy SQLJ into JServer as a Java Stored Procedure class.

Thank you,
Rob

Comments

60437
Answer
The workspace IDs in each database must be identical. The idea is that the host application be "the same" application in terms of its internal object IDs, its application ID, and the containing workspace ID. You can achieve this by exporting the workspace to a file and importing/installing it into the next database in order to prepare for the introduction of "copies of" applications and their components into the "copy of" the workspace.

Scott
Marked as Answer by 647472 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 28 2009
Added on Jul 31 2009
0 comments
309 views