CODEWITHSUNDEEP
javaoracle-databaseoracle-sqldeveloper
westman379
westman379

Reputation: 723

Adding Java class to Oracle database by SQL Developer - compilation error

I have technical issue with my database. In SQL Developer there is an option designed to add Java code to database. But when I try to add my code, error message appears (shown below). Do you have any idea where I can find info about what comilation error is this? Some log maybe? And what are the requiments for good Java class? I tried to add Hello World code and it worked fine.

Error message: https://s4.postimg.org/if3ip9zfh/screenshot000213.jpg

Upvotes: 0

Views: 7266

Answers (2)

JeongjinKim
JeongjinKim

Reputation: 182

I had the same issue as you, but the Oracle JDK version was a problem. I fixed this problem by changing the source code to match the JDK version. Please check the version.

Upvotes: 1

Paul
Paul

Reputation: 1167

It'll probably be easier to create a class via a script with DDL.

We do it like this:

CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "IP6Address" AS
import java.math.BigInteger;
public class IP6Address
{ 
  ... -- whatever
}
/

We do that for packages as well because we store these scripts in VCS.

Then you just run the script and wait for the compiler messages (as with any other script).

Upvotes: 4

Related Questions