RE: New SQLcl issue - Error Message = No suitable driver found for jdbc:oracle:oci8:@ - SQLcl: Release 4.2.0.16.049.0842 RC on Fri Feb 19 09:02:47 2016

  • From: Jeff Smith <jeff.d.smith@xxxxxxxxxx>
  • To: Binh.Le@xxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 19 Feb 2016 07:22:57 -0800 (PST)

Works for me - I know that's not helpful.but.

 

What version of Oracle are you trying to connect to?

 

Are you attempting a thick connection?

 

C:\Users\jdsmith\Desktop\sqldeveloper\sqlcl\feb OTN\sqlcl\bin>dir

Volume in drive C is System

Volume Serial Number is 8240-78C8

 

Directory of C:\Users\jdsmith\Desktop\sqldeveloper\sqlcl\feb OTN\sqlcl\bin

 

02/19/2016  10:19 AM    <DIR>          .

02/19/2016  10:19 AM    <DIR>          ..

02/18/2016  08:42 AM             5,158 sql

02/18/2016  08:42 AM             1,915 sql.bat

02/18/2016  08:43 AM           317,355 sql.exe

               3 File(s)        324,428 bytes

               2 Dir(s)   5,880,463,360 bytes free

 

C:\Users\jdsmith\Desktop\sqldeveloper\sqlcl\feb OTN\sqlcl\bin>sql 
hr/oracle@localhost:1521/pdb1

 

SQLcl: Release 4.2.0.16.049.0842 RC on Fri Feb 19 10:20:01 2016

 

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing 
options

 

 

SQL> desc hr.departments

Name            Null?    Type

--------------- -------- ------------

DEPARTMENT_ID   NOT NULL NUMBER(4)

DEPARTMENT_NAME NOT NULL VARCHAR2(30)

MANAGER_ID               NUMBER(6)

LOCATION_ID              NUMBER(4)

SQL> info hr.departments

TABLE: DEPARTMENTS

         LAST ANALYZED:2014-08-20 01:00:59.0

         ROWS         :27

         SAMPLE SIZE  :27

         INMEMORY     :

         COMMENTS     :Departments table that shows details of departments 
where employees

                       work. Contains 27 rows; references with locations, 
employees, and job_history tables.

 

Columns

NAME              DATA TYPE           NULL  DEFAULT    COMMENTS

*DEPARTMENT_ID    NUMBER(4,0)         No                   Primary key column 
of departments table.

DEPARTMENT_NAME  VARCHAR2(30 BYTE)   No                   A not null column 
that shows name of a department. Administra

tion,

                                                                     Marketing, 
Purchasing, Human Resources, Shipping, I

T, Executive, Public

                                                                     Relations, 
Sales, Finance, and Accounting.

MANAGER_ID       NUMBER(6,0)         Yes                  Manager_id of a 
department. Foreign key to employee_id column

of employees table. The manager_id column of the employee table references this 
column.

LOCATION_ID      NUMBER(4,0)         Yes                  Location id where a 
department is located. Foreign key to loc

ation_id column of locations table.

 

Indexes

INDEX_NAME           UNIQUENESS  STATUS  FUNCIDX_STATUS  COLUMNS        
COLUMN_EXPRESSION

HR.DEPT_ID_PK        UNIQUE      VALID                   DEPARTMENT_ID

HR.DEPT_LOCATION_IX  NONUNIQUE   VALID                   LOCATION_ID

 

 

References

TABLE_NAME   CONSTRAINT_NAME  DELETE_RULE  STATUS   DEFERRABLE      VALIDATED  
GENERATED

EMPLOYEES    EMP_DEPT_FK      NO ACTION    ENABLED  NOT DEFERRABLE  VALIDATED  
USER NAME

JOB_HISTORY  JHIST_DEPT_FK    NO ACTION    ENABLED  NOT DEFERRABLE  VALIDATED  
USER NAME

 

SQL>

 

From: Le, Binh T. [mailto:Binh.Le@xxxxxxx] ;
Sent: Friday, February 19, 2016 9:36 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: New SQLcl issue - Error Message = No suitable driver found for 
jdbc:oracle:oci8:@ - SQLcl: Release 4.2.0.16.049.0842 RC on Fri Feb 19 09:02:47 
2016

 

Hi,

 

Have anyone upgrade SQLcl came out yesterday?

 

I ran in issue with error : Error Message = No suitable driver found for 
jdbc:oracle:oci8:@

 

I saw new directory call thick in the directory.

 

I wonder if anyone have the fix fir this.

 

Thanks,

Binh

Notice of Confidentiality: **This E-mail and any of its attachments may contain 
Lincoln National Corporation proprietary information, which is privileged, 
confidential,
or subject to copyright belonging to the Lincoln National Corporation family of 
companies. This E-mail is intended solely for the use of the individual or 
entity to 
which it is addressed. If you are not the intended recipient of this E-mail, 
you are 
hereby notified that any dissemination, distribution, copying, or action taken 
in 
relation to the contents of and attachments to this E-mail is strictly 
prohibited 
and may be unlawful. If you have received this E-mail in error, please notify 
the 
sender immediately and permanently delete the original and any copy of this 
E-mail 
and any printout. Thank You.**

Other related posts: