Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

UnsupportedClassVersionError: Bad version number in .class file

3862933Jan 31 2019 — edited Jan 31 2019

Hello,

I have this issue when I try to run ./sqlcl/bin/sql:

Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in .class file

        at java.lang.ClassLoader.defineClass1(Native Method)

        at java.lang.ClassLoader.defineClass(ClassLoader.java:621)

        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)

        at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)

        at java.net.URLClassLoader.access$100(URLClassLoader.java:56)

        at java.net.URLClassLoader$1.run(URLClassLoader.java:195)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)

        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:252)

        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

My settings are:

Setting
Version
JavaJava(TM) SE Runtime Environment (build 1.8.0_131-b11)
SQLcl18.4.0.007.1818
JAVA_HOME/usr/java/jdk1.8.0_131/jre
ORACLE_HOME/opt/oracle/product/11.2.0.4/db_1
OSCENTOS 7

Regards,

Silva

Comments

Frank Kulash

Hi, @kannan-sekar
Is this thread a duplicate of: Unique Index not allowing to insert rows into table.. — oracle-tech
If so, one of them should be closed right away. It's confusing (and counter-productive) to have multiple threads for the same question. (This may not be your fault; the site can behave strangely.)

Frank Kulash

Hi,
I am unable to replicate the issue here, instead i explained in words below.
That makes it hard (perhaps impossible) to solve the problem. What problem do you have in producing a test case that the people who want to help you can replicate?
Step1: Creating table with primary key on col1
CREATE TABLE T1(PKEY NUMBER(10) PRIMARY KEY, ACCT_NO NUMBER(10), ACCT_KEY NUMBER(10), ACCT_STATUS NUMBER(1), ACCT_GRP_STATUS NUMBER(1));
The table created above doesn't have a column called col1. If you have a problem with some table that has a column called col1, post the CREATE TABLE and INSERT statements for that table.
Step2: Creating unique index on using CASE statement
CREATE UNIQUE INDEX IDX_T1_ACCT_KEY ON T1 ( CASE WHEN ACCT_STATUS = 1 AND ACCT_GRP_STATUS = -1 THEN ACCT_KEY ELSE NULL END);
Explain the requirement that the index is supposed to meet. For example, "I need to make sure that among all the rows with the same acct_key value, no more than one of them has acc_status=1 and acct_grp_status=-1."
By the way, that index uses a CASE expression, not a CASE statement. A CASE statement is something different. You'll get better answers faster if you say what you mean.
Below kind of row value is not inserted in my real world (getting unique index error).
Are you sure the index you posted is causing the error? Post the exact, complete error message you get.

1 - 2

Post Details

Added on Jan 31 2019
1 comment
1,441 views